Hi all !!
Last week I made a backup of a database since we need this database to
be restored on a different server.
To do the backup I used Backup tool included in SQL (right click on
database / All tasks / Backup Database ). Backup was made with default
options (appent to media checked as well).
The backup file was 1,7 GB size and I decided to compress it in order
to being able to burn a CD and send it, the compress file was 250 MB so
I burnt a CD with compress database and sent it.
My problem is when the guys where the other server is allocated
restored the backup they could do it but didn't recover the newest
version of the database, they recover an older version from 3 weeks
ago.
I wonder if this problem could be caused because I didn't check
overwrite media option (and I check append to media option) from SQL
backup tool or this can be caused for any other reason like they
weren't able to recover it properly or that I should use other
different tool from SQL one.
Thanks in advance !
Miguel
Miguel Angel
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message200843.html
Most likely you have several backups on the backup file. You can use RESTORE HEADERONLY to check this and then
the FILE option when you perform the restore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Miguel Angel" <Miguel.Angel.15dlii@.mail.webservertalk.com> wrote in message
news:Miguel.Angel.15dlii@.mail.webservertalk.com...
> Hi all !!
> Last week I made a backup of a database since we need this database to
> be restored on a different server.
> To do the backup I used Backup tool included in SQL (right click on
> database / All tasks / Backup Database ). Backup was made with default
> options (appent to media checked as well).
> The backup file was 1,7 GB size and I decided to compress it in order
> to being able to burn a CD and send it, the compress file was 250 MB so
> I burnt a CD with compress database and sent it.
> My problem is when the guys where the other server is allocated
> restored the backup they could do it but didn't recover the newest
> version of the database, they recover an older version from 3 weeks
> ago.
> I wonder if this problem could be caused because I didn't check
> overwrite media option (and I check append to media option) from SQL
> backup tool or this can be caused for any other reason like they
> weren't able to recover it properly or that I should use other
> different tool from SQL one.
> Thanks in advance !
> Miguel
>
> --
> Miguel Angel
> Posted via http://www.webservertalk.com
> View this thread: http://www.webservertalk.com/message200843.html
>
Showing posts with label tool. Show all posts
Showing posts with label tool. Show all posts
Sunday, March 11, 2012
Wednesday, March 7, 2012
Backup Only Tool
Hi there,
We have several users that require a tool to make ad hoc backups. Fo
obvious reasons we don't want to give them any other functionality
such as restoring a database. Is there a tool, 3rd party or otherwise,
that would suitable for this?
Any help much appreciated.
Joe
it would be very easy to slap together a simple script using dmo/smo that
your users could plug in a server and database name and location and have it
perform a backup.
TheSQLGuru
President
Indicium Resources, Inc.
"joe" <joelocker@.gmail.com> wrote in message
news:1186999278.638852.239050@.57g2000hsv.googlegro ups.com...
> Hi there,
> We have several users that require a tool to make ad hoc backups. Fo
> obvious reasons we don't want to give them any other functionality
> such as restoring a database. Is there a tool, 3rd party or otherwise,
> that would suitable for this?
> Any help much appreciated.
> Joe
>
We have several users that require a tool to make ad hoc backups. Fo
obvious reasons we don't want to give them any other functionality
such as restoring a database. Is there a tool, 3rd party or otherwise,
that would suitable for this?
Any help much appreciated.
Joe
it would be very easy to slap together a simple script using dmo/smo that
your users could plug in a server and database name and location and have it
perform a backup.
TheSQLGuru
President
Indicium Resources, Inc.
"joe" <joelocker@.gmail.com> wrote in message
news:1186999278.638852.239050@.57g2000hsv.googlegro ups.com...
> Hi there,
> We have several users that require a tool to make ad hoc backups. Fo
> obvious reasons we don't want to give them any other functionality
> such as restoring a database. Is there a tool, 3rd party or otherwise,
> that would suitable for this?
> Any help much appreciated.
> Joe
>
Backup Only Tool
Hi there,
We have several users that require a tool to make ad hoc backups. Fo
obvious reasons we don't want to give them any other functionality
such as restoring a database. Is there a tool, 3rd party or otherwise,
that would suitable for this?
Any help much appreciated.
Joeit would be very easy to slap together a simple script using dmo/smo that
your users could plug in a server and database name and location and have it
perform a backup.
TheSQLGuru
President
Indicium Resources, Inc.
"joe" <joelocker@.gmail.com> wrote in message
news:1186999278.638852.239050@.57g2000hsv.googlegroups.com...
> Hi there,
> We have several users that require a tool to make ad hoc backups. Fo
> obvious reasons we don't want to give them any other functionality
> such as restoring a database. Is there a tool, 3rd party or otherwise,
> that would suitable for this?
> Any help much appreciated.
> Joe
>|||I would be extremely careful of allowing this unless you have bagloads
of disk space available. it is impossible to manage the number of
backups that could be created which could lead to rapid disk space
usage. if you haven't given much thoguht to your server configuration
and have backups on the same disk space as your databases, you could
very quickly run into the situation where your databases will not have
any available space left to write to.
You may want to instead create a maintenance plan that kept only a
certain number of backups (or certain number of days) and then create
the script to run the maintenance plan to put some more controls in
place on disk space usage.
I will not list specific examples, but you should really consider the
disk space usage and also consider why the users need to backup
databases themselves.|||I wouldn't allow them to do backups on the server - only on their local
machine or a file server that it is ok if they fill up. :-)
TheSQLGuru
President
Indicium Resources, Inc.
"Joe Mama" <Les.Barkhouse@.gmail.com> wrote in message
news:1187100581.123220.126500@.19g2000hsx.googlegroups.com...
>I would be extremely careful of allowing this unless you have bagloads
> of disk space available. it is impossible to manage the number of
> backups that could be created which could lead to rapid disk space
> usage. if you haven't given much thoguht to your server configuration
> and have backups on the same disk space as your databases, you could
> very quickly run into the situation where your databases will not have
> any available space left to write to.
> You may want to instead create a maintenance plan that kept only a
> certain number of backups (or certain number of days) and then create
> the script to run the maintenance plan to put some more controls in
> place on disk space usage.
> I will not list specific examples, but you should really consider the
> disk space usage and also consider why the users need to backup
> databases themselves.
>
We have several users that require a tool to make ad hoc backups. Fo
obvious reasons we don't want to give them any other functionality
such as restoring a database. Is there a tool, 3rd party or otherwise,
that would suitable for this?
Any help much appreciated.
Joeit would be very easy to slap together a simple script using dmo/smo that
your users could plug in a server and database name and location and have it
perform a backup.
TheSQLGuru
President
Indicium Resources, Inc.
"joe" <joelocker@.gmail.com> wrote in message
news:1186999278.638852.239050@.57g2000hsv.googlegroups.com...
> Hi there,
> We have several users that require a tool to make ad hoc backups. Fo
> obvious reasons we don't want to give them any other functionality
> such as restoring a database. Is there a tool, 3rd party or otherwise,
> that would suitable for this?
> Any help much appreciated.
> Joe
>|||I would be extremely careful of allowing this unless you have bagloads
of disk space available. it is impossible to manage the number of
backups that could be created which could lead to rapid disk space
usage. if you haven't given much thoguht to your server configuration
and have backups on the same disk space as your databases, you could
very quickly run into the situation where your databases will not have
any available space left to write to.
You may want to instead create a maintenance plan that kept only a
certain number of backups (or certain number of days) and then create
the script to run the maintenance plan to put some more controls in
place on disk space usage.
I will not list specific examples, but you should really consider the
disk space usage and also consider why the users need to backup
databases themselves.|||I wouldn't allow them to do backups on the server - only on their local
machine or a file server that it is ok if they fill up. :-)
TheSQLGuru
President
Indicium Resources, Inc.
"Joe Mama" <Les.Barkhouse@.gmail.com> wrote in message
news:1187100581.123220.126500@.19g2000hsx.googlegroups.com...
>I would be extremely careful of allowing this unless you have bagloads
> of disk space available. it is impossible to manage the number of
> backups that could be created which could lead to rapid disk space
> usage. if you haven't given much thoguht to your server configuration
> and have backups on the same disk space as your databases, you could
> very quickly run into the situation where your databases will not have
> any available space left to write to.
> You may want to instead create a maintenance plan that kept only a
> certain number of backups (or certain number of days) and then create
> the script to run the maintenance plan to put some more controls in
> place on disk space usage.
> I will not list specific examples, but you should really consider the
> disk space usage and also consider why the users need to backup
> databases themselves.
>
Backup Only Tool
Hi there,
We have several users that require a tool to make ad hoc backups. Fo
obvious reasons we don't want to give them any other functionality
such as restoring a database. Is there a tool, 3rd party or otherwise,
that would suitable for this?
Any help much appreciated.
Joeit would be very easy to slap together a simple script using dmo/smo that
your users could plug in a server and database name and location and have it
perform a backup.
--
TheSQLGuru
President
Indicium Resources, Inc.
"joe" <joelocker@.gmail.com> wrote in message
news:1186999278.638852.239050@.57g2000hsv.googlegroups.com...
> Hi there,
> We have several users that require a tool to make ad hoc backups. Fo
> obvious reasons we don't want to give them any other functionality
> such as restoring a database. Is there a tool, 3rd party or otherwise,
> that would suitable for this?
> Any help much appreciated.
> Joe
>|||I would be extremely careful of allowing this unless you have bagloads
of disk space available. it is impossible to manage the number of
backups that could be created which could lead to rapid disk space
usage. if you haven't given much thoguht to your server configuration
and have backups on the same disk space as your databases, you could
very quickly run into the situation where your databases will not have
any available space left to write to.
You may want to instead create a maintenance plan that kept only a
certain number of backups (or certain number of days) and then create
the script to run the maintenance plan to put some more controls in
place on disk space usage.
I will not list specific examples, but you should really consider the
disk space usage and also consider why the users need to backup
databases themselves.|||I wouldn't allow them to do backups on the server - only on their local
machine or a file server that it is ok if they fill up. :-)
--
TheSQLGuru
President
Indicium Resources, Inc.
"Joe Mama" <Les.Barkhouse@.gmail.com> wrote in message
news:1187100581.123220.126500@.19g2000hsx.googlegroups.com...
>I would be extremely careful of allowing this unless you have bagloads
> of disk space available. it is impossible to manage the number of
> backups that could be created which could lead to rapid disk space
> usage. if you haven't given much thoguht to your server configuration
> and have backups on the same disk space as your databases, you could
> very quickly run into the situation where your databases will not have
> any available space left to write to.
> You may want to instead create a maintenance plan that kept only a
> certain number of backups (or certain number of days) and then create
> the script to run the maintenance plan to put some more controls in
> place on disk space usage.
> I will not list specific examples, but you should really consider the
> disk space usage and also consider why the users need to backup
> databases themselves.
>
We have several users that require a tool to make ad hoc backups. Fo
obvious reasons we don't want to give them any other functionality
such as restoring a database. Is there a tool, 3rd party or otherwise,
that would suitable for this?
Any help much appreciated.
Joeit would be very easy to slap together a simple script using dmo/smo that
your users could plug in a server and database name and location and have it
perform a backup.
--
TheSQLGuru
President
Indicium Resources, Inc.
"joe" <joelocker@.gmail.com> wrote in message
news:1186999278.638852.239050@.57g2000hsv.googlegroups.com...
> Hi there,
> We have several users that require a tool to make ad hoc backups. Fo
> obvious reasons we don't want to give them any other functionality
> such as restoring a database. Is there a tool, 3rd party or otherwise,
> that would suitable for this?
> Any help much appreciated.
> Joe
>|||I would be extremely careful of allowing this unless you have bagloads
of disk space available. it is impossible to manage the number of
backups that could be created which could lead to rapid disk space
usage. if you haven't given much thoguht to your server configuration
and have backups on the same disk space as your databases, you could
very quickly run into the situation where your databases will not have
any available space left to write to.
You may want to instead create a maintenance plan that kept only a
certain number of backups (or certain number of days) and then create
the script to run the maintenance plan to put some more controls in
place on disk space usage.
I will not list specific examples, but you should really consider the
disk space usage and also consider why the users need to backup
databases themselves.|||I wouldn't allow them to do backups on the server - only on their local
machine or a file server that it is ok if they fill up. :-)
--
TheSQLGuru
President
Indicium Resources, Inc.
"Joe Mama" <Les.Barkhouse@.gmail.com> wrote in message
news:1187100581.123220.126500@.19g2000hsx.googlegroups.com...
>I would be extremely careful of allowing this unless you have bagloads
> of disk space available. it is impossible to manage the number of
> backups that could be created which could lead to rapid disk space
> usage. if you haven't given much thoguht to your server configuration
> and have backups on the same disk space as your databases, you could
> very quickly run into the situation where your databases will not have
> any available space left to write to.
> You may want to instead create a maintenance plan that kept only a
> certain number of backups (or certain number of days) and then create
> the script to run the maintenance plan to put some more controls in
> place on disk space usage.
> I will not list specific examples, but you should really consider the
> disk space usage and also consider why the users need to backup
> databases themselves.
>
Saturday, February 25, 2012
Backup of SQL Database using VB 6.0
hi all
Please help me
I want to know how can I take the backup of my database which I've made in SQL Server by using VB as a front end tool.
If any 1 of u can please mail me, I would be thankful :). My email address is love1best@.yahoo.com
JamalJanYour VB could send an SQL script containing the BACKUP command.
blindman|||Originally posted by blindman
Your VB could send an SQL script containing the BACKUP command.
blindman
how ? :(
Pls Explain. If anyone can tell me the codes, I'll be really thankful.
Thanking in Advance.
JamalJan
[love1best@.yahoo.com]|||From ASP:
set execommand = Server.CreateObject("ADODB.Command")
execommand.CommandText = "backup database test_db to disk='f:\backup\test_db.bak'"
execommand.execute
set rs=nothing
set execommand=nothing
For VB it is almost the same...|||Originally posted by snail
From ASP:
set execommand = Server.CreateObject("ADODB.Command")
execommand.CommandText = "backup database test_db to disk='f:\backup\test_db.bak'"
execommand.execute
set rs=nothing
set execommand=nothing
For VB it is almost the same...
thanks :)
Jani
Please help me
I want to know how can I take the backup of my database which I've made in SQL Server by using VB as a front end tool.
If any 1 of u can please mail me, I would be thankful :). My email address is love1best@.yahoo.com
JamalJanYour VB could send an SQL script containing the BACKUP command.
blindman|||Originally posted by blindman
Your VB could send an SQL script containing the BACKUP command.
blindman
how ? :(
Pls Explain. If anyone can tell me the codes, I'll be really thankful.
Thanking in Advance.
JamalJan
[love1best@.yahoo.com]|||From ASP:
set execommand = Server.CreateObject("ADODB.Command")
execommand.CommandText = "backup database test_db to disk='f:\backup\test_db.bak'"
execommand.execute
set rs=nothing
set execommand=nothing
For VB it is almost the same...|||Originally posted by snail
From ASP:
set execommand = Server.CreateObject("ADODB.Command")
execommand.CommandText = "backup database test_db to disk='f:\backup\test_db.bak'"
execommand.execute
set rs=nothing
set execommand=nothing
For VB it is almost the same...
thanks :)
Jani
Friday, February 24, 2012
Backup MS SQL server database to sql script
I'm searching a tool to make backup of MS SQL SERver 2000 Database to sql
script (with inserts).
Do yoy know any tool to it ?
Enterprise Manager can script the database objects for you (right-click
the database, select All Tasks > Generate SQL Script).
For simple INSERT scripts, try the following:
http://vyaskn.tripod.com/code/generate_inserts.txt
You may want something more sophisticated than the above in which case
you'll want to purchase some software such as:
http://www.red-gate.com/products/index.htm
David Portas
SQL Server MVP
|||... and some other options...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1127400591.364448.197150@.g47g2000cwa.googlegr oups.com...
> Enterprise Manager can script the database objects for you (right-click
> the database, select All Tasks > Generate SQL Script).
> For simple INSERT scripts, try the following:
> http://vyaskn.tripod.com/code/generate_inserts.txt
> You may want something more sophisticated than the above in which case
> you'll want to purchase some software such as:
> http://www.red-gate.com/products/index.htm
> --
> David Portas
> SQL Server MVP
> --
>
script (with inserts).
Do yoy know any tool to it ?
Enterprise Manager can script the database objects for you (right-click
the database, select All Tasks > Generate SQL Script).
For simple INSERT scripts, try the following:
http://vyaskn.tripod.com/code/generate_inserts.txt
You may want something more sophisticated than the above in which case
you'll want to purchase some software such as:
http://www.red-gate.com/products/index.htm
David Portas
SQL Server MVP
|||... and some other options...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1127400591.364448.197150@.g47g2000cwa.googlegr oups.com...
> Enterprise Manager can script the database objects for you (right-click
> the database, select All Tasks > Generate SQL Script).
> For simple INSERT scripts, try the following:
> http://vyaskn.tripod.com/code/generate_inserts.txt
> You may want something more sophisticated than the above in which case
> you'll want to purchase some software such as:
> http://www.red-gate.com/products/index.htm
> --
> David Portas
> SQL Server MVP
> --
>
Backup MS SQL server database to sql script
I'm searching a tool to make backup of MS SQL SERver 2000 Database to sql
script (with inserts).
Do yoy know any tool to it ?Enterprise Manager can script the database objects for you (right-click
the database, select All Tasks > Generate SQL Script).
For simple INSERT scripts, try the following:
http://vyaskn.tripod.com/code/generate_inserts.txt
You may want something more sophisticated than the above in which case
you'll want to purchase some software such as:
http://www.red-gate.com/products/index.htm
David Portas
SQL Server MVP
--|||... and some other options...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1127400591.364448.197150@.g47g2000cwa.googlegroups.com...
> Enterprise Manager can script the database objects for you (right-click
> the database, select All Tasks > Generate SQL Script).
> For simple INSERT scripts, try the following:
> http://vyaskn.tripod.com/code/generate_inserts.txt
> You may want something more sophisticated than the above in which case
> you'll want to purchase some software such as:
> http://www.red-gate.com/products/index.htm
> --
> David Portas
> SQL Server MVP
> --
>
script (with inserts).
Do yoy know any tool to it ?Enterprise Manager can script the database objects for you (right-click
the database, select All Tasks > Generate SQL Script).
For simple INSERT scripts, try the following:
http://vyaskn.tripod.com/code/generate_inserts.txt
You may want something more sophisticated than the above in which case
you'll want to purchase some software such as:
http://www.red-gate.com/products/index.htm
David Portas
SQL Server MVP
--|||... and some other options...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1127400591.364448.197150@.g47g2000cwa.googlegroups.com...
> Enterprise Manager can script the database objects for you (right-click
> the database, select All Tasks > Generate SQL Script).
> For simple INSERT scripts, try the following:
> http://vyaskn.tripod.com/code/generate_inserts.txt
> You may want something more sophisticated than the above in which case
> you'll want to purchase some software such as:
> http://www.red-gate.com/products/index.htm
> --
> David Portas
> SQL Server MVP
> --
>
Backup MS SQL server database to sql script
I'm searching a tool to make backup of MS SQL SERver 2000 Database to sql
script (with inserts).
Do yoy know any tool to it ?Enterprise Manager can script the database objects for you (right-click
the database, select All Tasks > Generate SQL Script).
For simple INSERT scripts, try the following:
http://vyaskn.tripod.com/code/generate_inserts.txt
You may want something more sophisticated than the above in which case
you'll want to purchase some software such as:
http://www.red-gate.com/products/index.htm
--
David Portas
SQL Server MVP
--|||... and some other options...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1127400591.364448.197150@.g47g2000cwa.googlegroups.com...
> Enterprise Manager can script the database objects for you (right-click
> the database, select All Tasks > Generate SQL Script).
> For simple INSERT scripts, try the following:
> http://vyaskn.tripod.com/code/generate_inserts.txt
> You may want something more sophisticated than the above in which case
> you'll want to purchase some software such as:
> http://www.red-gate.com/products/index.htm
> --
> David Portas
> SQL Server MVP
> --
>
script (with inserts).
Do yoy know any tool to it ?Enterprise Manager can script the database objects for you (right-click
the database, select All Tasks > Generate SQL Script).
For simple INSERT scripts, try the following:
http://vyaskn.tripod.com/code/generate_inserts.txt
You may want something more sophisticated than the above in which case
you'll want to purchase some software such as:
http://www.red-gate.com/products/index.htm
--
David Portas
SQL Server MVP
--|||... and some other options...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1127400591.364448.197150@.g47g2000cwa.googlegroups.com...
> Enterprise Manager can script the database objects for you (right-click
> the database, select All Tasks > Generate SQL Script).
> For simple INSERT scripts, try the following:
> http://vyaskn.tripod.com/code/generate_inserts.txt
> You may want something more sophisticated than the above in which case
> you'll want to purchase some software such as:
> http://www.red-gate.com/products/index.htm
> --
> David Portas
> SQL Server MVP
> --
>
Subscribe to:
Posts (Atom)