I am running SQL-2000 Standard (SP3) and have created a backup job a while
back to back up several databases, and a seperate job to backup transaction
logs. 2 out of the 3 databases are being backed up and the transaction logs
are backing up, but our largest database (almost 5GB) is failing on the
backup. Where can I look to see why it is failing?
How do you run these jobs, and what types are they of. Maint Wiz? SQL Server Agent jobs, TSQL or
CmdExec? Etc...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:%23v8hVlDvEHA.3976@.TK2MSFTNGP09.phx.gbl...
>I am running SQL-2000 Standard (SP3) and have created a backup job a while
> back to back up several databases, and a seperate job to backup transaction
> logs. 2 out of the 3 databases are being backed up and the transaction logs
> are backing up, but our largest database (almost 5GB) is failing on the
> backup. Where can I look to see why it is failing?
|||Tibor Karaszi wrote:
> How do you run these jobs, and what types are they of. Maint Wiz? SQL
> Server Agent jobs, TSQL or CmdExec? Etc...
>
They were created using the Maintenance Wizard and scheduled to run nightly.
|||You may need to look at both the job history (make sure to view step
details) and the MP history.
Andrew J. Kelly SQL MVP
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:%23v8hVlDvEHA.3976@.TK2MSFTNGP09.phx.gbl...
>I am running SQL-2000 Standard (SP3) and have created a backup job a while
> back to back up several databases, and a seperate job to backup
> transaction
> logs. 2 out of the 3 databases are being backed up and the transaction
> logs
> are backing up, but our largest database (almost 5GB) is failing on the
> backup. Where can I look to see why it is failing?
|||In addition to Andrew's answer, I suggest you specify a report file in Main Wiz and look for error
messages in there.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:estbZJEvEHA.3424@.TK2MSFTNGP09.phx.gbl...
> Tibor Karaszi wrote:
>
> They were created using the Maintenance Wizard and scheduled to run nightly.
Showing posts with label seperate. Show all posts
Showing posts with label seperate. Show all posts
Wednesday, March 7, 2012
Backups failing
I am running SQL-2000 Standard (SP3) and have created a backup job a while
back to back up several databases, and a seperate job to backup transaction
logs. 2 out of the 3 databases are being backed up and the transaction logs
are backing up, but our largest database (almost 5GB) is failing on the
backup. Where can I look to see why it is failing?How do you run these jobs, and what types are they of. Maint Wiz? SQL Server Agent jobs, TSQL or
CmdExec? Etc...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:%23v8hVlDvEHA.3976@.TK2MSFTNGP09.phx.gbl...
>I am running SQL-2000 Standard (SP3) and have created a backup job a while
> back to back up several databases, and a seperate job to backup transaction
> logs. 2 out of the 3 databases are being backed up and the transaction logs
> are backing up, but our largest database (almost 5GB) is failing on the
> backup. Where can I look to see why it is failing?|||Tibor Karaszi wrote:
> How do you run these jobs, and what types are they of. Maint Wiz? SQL
> Server Agent jobs, TSQL or CmdExec? Etc...
>
They were created using the Maintenance Wizard and scheduled to run nightly.|||You may need to look at both the job history (make sure to view step
details) and the MP history.
--
Andrew J. Kelly SQL MVP
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:%23v8hVlDvEHA.3976@.TK2MSFTNGP09.phx.gbl...
>I am running SQL-2000 Standard (SP3) and have created a backup job a while
> back to back up several databases, and a seperate job to backup
> transaction
> logs. 2 out of the 3 databases are being backed up and the transaction
> logs
> are backing up, but our largest database (almost 5GB) is failing on the
> backup. Where can I look to see why it is failing?|||In addition to Andrew's answer, I suggest you specify a report file in Main Wiz and look for error
messages in there.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:estbZJEvEHA.3424@.TK2MSFTNGP09.phx.gbl...
> Tibor Karaszi wrote:
>> How do you run these jobs, and what types are they of. Maint Wiz? SQL
>> Server Agent jobs, TSQL or CmdExec? Etc...
>
> They were created using the Maintenance Wizard and scheduled to run nightly.
back to back up several databases, and a seperate job to backup transaction
logs. 2 out of the 3 databases are being backed up and the transaction logs
are backing up, but our largest database (almost 5GB) is failing on the
backup. Where can I look to see why it is failing?How do you run these jobs, and what types are they of. Maint Wiz? SQL Server Agent jobs, TSQL or
CmdExec? Etc...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:%23v8hVlDvEHA.3976@.TK2MSFTNGP09.phx.gbl...
>I am running SQL-2000 Standard (SP3) and have created a backup job a while
> back to back up several databases, and a seperate job to backup transaction
> logs. 2 out of the 3 databases are being backed up and the transaction logs
> are backing up, but our largest database (almost 5GB) is failing on the
> backup. Where can I look to see why it is failing?|||Tibor Karaszi wrote:
> How do you run these jobs, and what types are they of. Maint Wiz? SQL
> Server Agent jobs, TSQL or CmdExec? Etc...
>
They were created using the Maintenance Wizard and scheduled to run nightly.|||You may need to look at both the job history (make sure to view step
details) and the MP history.
--
Andrew J. Kelly SQL MVP
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:%23v8hVlDvEHA.3976@.TK2MSFTNGP09.phx.gbl...
>I am running SQL-2000 Standard (SP3) and have created a backup job a while
> back to back up several databases, and a seperate job to backup
> transaction
> logs. 2 out of the 3 databases are being backed up and the transaction
> logs
> are backing up, but our largest database (almost 5GB) is failing on the
> backup. Where can I look to see why it is failing?|||In addition to Andrew's answer, I suggest you specify a report file in Main Wiz and look for error
messages in there.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:estbZJEvEHA.3424@.TK2MSFTNGP09.phx.gbl...
> Tibor Karaszi wrote:
>> How do you run these jobs, and what types are they of. Maint Wiz? SQL
>> Server Agent jobs, TSQL or CmdExec? Etc...
>
> They were created using the Maintenance Wizard and scheduled to run nightly.
Backups failing
I am running SQL-2000 Standard (SP3) and have created a backup job a while
back to back up several databases, and a seperate job to backup transaction
logs. 2 out of the 3 databases are being backed up and the transaction logs
are backing up, but our largest database (almost 5GB) is failing on the
backup. Where can I look to see why it is failing?How do you run these jobs, and what types are they of. Maint Wiz? SQL Server
Agent jobs, TSQL or
CmdExec? Etc...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:%23v8hVlDvEHA.3976@.TK2MSFTNGP09.phx.gbl...
>I am running SQL-2000 Standard (SP3) and have created a backup job a while
> back to back up several databases, and a seperate job to backup transactio
n
> logs. 2 out of the 3 databases are being backed up and the transaction log
s
> are backing up, but our largest database (almost 5GB) is failing on the
> backup. Where can I look to see why it is failing?|||Tibor Karaszi wrote:
> How do you run these jobs, and what types are they of. Maint Wiz? SQL
> Server Agent jobs, TSQL or CmdExec? Etc...
>
They were created using the Maintenance Wizard and scheduled to run nightly.|||You may need to look at both the job history (make sure to view step
details) and the MP history.
Andrew J. Kelly SQL MVP
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:%23v8hVlDvEHA.3976@.TK2MSFTNGP09.phx.gbl...
>I am running SQL-2000 Standard (SP3) and have created a backup job a while
> back to back up several databases, and a seperate job to backup
> transaction
> logs. 2 out of the 3 databases are being backed up and the transaction
> logs
> are backing up, but our largest database (almost 5GB) is failing on the
> backup. Where can I look to see why it is failing?|||In addition to Andrew's answer, I suggest you specify a report file in Main
Wiz and look for error
messages in there.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:estbZJEvEHA.3424@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Tibor Karaszi wrote:
>
>
> They were created using the Maintenance Wizard and scheduled to run nightly.[/vbco
l]
back to back up several databases, and a seperate job to backup transaction
logs. 2 out of the 3 databases are being backed up and the transaction logs
are backing up, but our largest database (almost 5GB) is failing on the
backup. Where can I look to see why it is failing?How do you run these jobs, and what types are they of. Maint Wiz? SQL Server
Agent jobs, TSQL or
CmdExec? Etc...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:%23v8hVlDvEHA.3976@.TK2MSFTNGP09.phx.gbl...
>I am running SQL-2000 Standard (SP3) and have created a backup job a while
> back to back up several databases, and a seperate job to backup transactio
n
> logs. 2 out of the 3 databases are being backed up and the transaction log
s
> are backing up, but our largest database (almost 5GB) is failing on the
> backup. Where can I look to see why it is failing?|||Tibor Karaszi wrote:
> How do you run these jobs, and what types are they of. Maint Wiz? SQL
> Server Agent jobs, TSQL or CmdExec? Etc...
>
They were created using the Maintenance Wizard and scheduled to run nightly.|||You may need to look at both the job history (make sure to view step
details) and the MP history.
Andrew J. Kelly SQL MVP
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:%23v8hVlDvEHA.3976@.TK2MSFTNGP09.phx.gbl...
>I am running SQL-2000 Standard (SP3) and have created a backup job a while
> back to back up several databases, and a seperate job to backup
> transaction
> logs. 2 out of the 3 databases are being backed up and the transaction
> logs
> are backing up, but our largest database (almost 5GB) is failing on the
> backup. Where can I look to see why it is failing?|||In addition to Andrew's answer, I suggest you specify a report file in Main
Wiz and look for error
messages in there.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Humphrey" <richard@.multicam.com> wrote in message
news:estbZJEvEHA.3424@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Tibor Karaszi wrote:
>
>
> They were created using the Maintenance Wizard and scheduled to run nightly.[/vbco
l]
Sunday, February 12, 2012
backup to two different locations
Is it possible to backup a database to two seperate
locations? Not filegroups or striping, but have two
complete copies of the backup in two seperate locations
using a single "BACKUP DATABASE" command? ThanksI do this with an alert that copies the first backup to a secondary
location. To do this create an alert that is triggered when a backup is
taken. The alert the fires off a job the copies the database backup to
another location.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks|||Not that I am aware of. You could add a job step that copies the file to
the alternate location after the backup step finishes.
--
Keith
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks|||Not in SQL Server 2000, but most likely available in SQL Server 2005
(http://www.microsoft.com/sql/yukon/productinfo/top30features.asp).
<plug> MiniSQLBackup has this feature now, allowing you to make 2 or more
copies of the same backup file using a single BACKUP DATABASE command. All
backup files are created concurrently, not copied off the first backup file.
Download the trial and give it a spin.</plug>
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
locations? Not filegroups or striping, but have two
complete copies of the backup in two seperate locations
using a single "BACKUP DATABASE" command? ThanksI do this with an alert that copies the first backup to a secondary
location. To do this create an alert that is triggered when a backup is
taken. The alert the fires off a job the copies the database backup to
another location.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks|||Not that I am aware of. You could add a job step that copies the file to
the alternate location after the backup step finishes.
--
Keith
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks|||Not in SQL Server 2000, but most likely available in SQL Server 2005
(http://www.microsoft.com/sql/yukon/productinfo/top30features.asp).
<plug> MiniSQLBackup has this feature now, allowing you to make 2 or more
copies of the same backup file using a single BACKUP DATABASE command. All
backup files are created concurrently, not copied off the first backup file.
Download the trial and give it a spin.</plug>
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
backup to two different locations
Is it possible to backup a database to two seperate
locations? Not filegroups or striping, but have two
complete copies of the backup in two seperate locations
using a single "BACKUP DATABASE" command? Thanks
I do this with an alert that copies the first backup to a secondary
location. To do this create an alert that is triggered when a backup is
taken. The alert the fires off a job the copies the database backup to
another location.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
|||Not that I am aware of. You could add a job step that copies the file to
the alternate location after the backup step finishes.
Keith
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
locations? Not filegroups or striping, but have two
complete copies of the backup in two seperate locations
using a single "BACKUP DATABASE" command? Thanks
I do this with an alert that copies the first backup to a secondary
location. To do this create an alert that is triggered when a backup is
taken. The alert the fires off a job the copies the database backup to
another location.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
|||Not that I am aware of. You could add a job step that copies the file to
the alternate location after the backup step finishes.
Keith
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
backup to two different locations
Is it possible to backup a database to two seperate
locations? Not filegroups or striping, but have two
complete copies of the backup in two seperate locations
using a single "BACKUP DATABASE" command? Thanks
I do this with an alert that copies the first backup to a secondary
location. To do this create an alert that is triggered when a backup is
taken. The alert the fires off a job the copies the database backup to
another location.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
|||Not that I am aware of. You could add a job step that copies the file to
the alternate location after the backup step finishes.
Keith
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
|||Not in SQL Server 2000, but most likely available in SQL Server 2005
(http://www.microsoft.com/sql/yukon/p...30features.asp).
<plug> MiniSQLBackup has this feature now, allowing you to make 2 or more
copies of the same backup file using a single BACKUP DATABASE command. All
backup files are created concurrently, not copied off the first backup file.
Download the trial and give it a spin.</plug>
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
locations? Not filegroups or striping, but have two
complete copies of the backup in two seperate locations
using a single "BACKUP DATABASE" command? Thanks
I do this with an alert that copies the first backup to a secondary
location. To do this create an alert that is triggered when a backup is
taken. The alert the fires off a job the copies the database backup to
another location.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
|||Not that I am aware of. You could add a job step that copies the file to
the alternate location after the backup step finishes.
Keith
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
|||Not in SQL Server 2000, but most likely available in SQL Server 2005
(http://www.microsoft.com/sql/yukon/p...30features.asp).
<plug> MiniSQLBackup has this feature now, allowing you to make 2 or more
copies of the same backup file using a single BACKUP DATABASE command. All
backup files are created concurrently, not copied off the first backup file.
Download the trial and give it a spin.</plug>
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
backup to two different locations
Is it possible to backup a database to two seperate
locations? Not filegroups or striping, but have two
complete copies of the backup in two seperate locations
using a single "BACKUP DATABASE" command? ThanksI do this with an alert that copies the first backup to a secondary
location. To do this create an alert that is triggered when a backup is
taken. The alert the fires off a job the copies the database backup to
another location.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx
.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks|||Not that I am aware of. You could add a job step that copies the file to
the alternate location after the backup step finishes.
Keith
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx
.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks|||Not in SQL Server 2000, but most likely available in SQL Server 2005
(http://www.microsoft.com/sql/yukon/...p30features.asp).
<plug> MiniSQLBackup has this feature now, allowing you to make 2 or more
copies of the same backup file using a single BACKUP DATABASE command. All
backup files are created concurrently, not copied off the first backup file.
Download the trial and give it a spin.</plug>
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx
.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
locations? Not filegroups or striping, but have two
complete copies of the backup in two seperate locations
using a single "BACKUP DATABASE" command? ThanksI do this with an alert that copies the first backup to a secondary
location. To do this create an alert that is triggered when a backup is
taken. The alert the fires off a job the copies the database backup to
another location.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx
.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks|||Not that I am aware of. You could add a job step that copies the file to
the alternate location after the backup step finishes.
Keith
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx
.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks|||Not in SQL Server 2000, but most likely available in SQL Server 2005
(http://www.microsoft.com/sql/yukon/...p30features.asp).
<plug> MiniSQLBackup has this feature now, allowing you to make 2 or more
copies of the same backup file using a single BACKUP DATABASE command. All
backup files are created concurrently, not copied off the first backup file.
Download the trial and give it a spin.</plug>
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx
.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
Subscribe to:
Posts (Atom)