September 6, 2011 at 3:07 pm
Can we Backup the Database on multiple location at time using SQL 2000???
I know SQL 2005 and later version has this functionality but by chance is there any way in SQL 2000??
Thanks in advance for your help.
September 6, 2011 at 4:01 pm
Do you mean to backup the database to multiple files?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 6, 2011 at 5:04 pm
From SQL Server 2008 Books Online:
"BACKUP (Transact-SQL)
...
MIRROR TO <backup_device> [ ,...n ]
Specifies a set of one or more backup devices that will mirror the backups devices specified in the TO clause. The MIRROR TO clause must be specify the same type and number of the backup devices as the TO clause. The maximum number of MIRROR TO clauses is three.
This option is available only in SQL Server 2005 Enterprise Edition and later versions...."
September 6, 2011 at 5:05 pm
I don't mean multiple file. I mean multiple location like we have functionality in SQL 2005 and later version called mirror backup.
September 6, 2011 at 5:07 pm
Jinu43 (9/6/2011)
I don't mean multiple file. I mean multiple location like we have functionality in SQL 2005 and later version called mirror backup.
Nope - see note from Michael.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply