September 3, 2011 at 7:49 am
Hi,
How can I take single database full backup on two drives ? I am not talking about mirror backup. I have tow drives available for backups. Database backup file is quite large I cannot take backup on single drive. I have to use both drive to take single database full backup. How can I proceed ?
Thanks in advance.
September 3, 2011 at 8:30 am
Use the following command
BACKUP DATABASE AdventureWorks TO
DISK = 'F:\MSSQL\Backup\ADV.BAK',
DISK = 'G:\MSSQL\Backup\ADV2.BAK'
WITH INIT
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2011 at 8:38 am
ok, means ADV.BAK and ADV2.BAK of AdventureWorks db contain the full backup. And if any on bak file get corrupted I wont be able to restore the full backup. and while restoring I have to follow the below syntax :
RESTORE DATABASE AdventureWorks FROM
DISK = 'F:\MSSQL\Backup\ADV.BAK',
DISK = 'G:\MSSQL\Backup\ADV2.BAK'
GO;
Thanks in advance.
September 3, 2011 at 10:48 am
beejug1983 (9/3/2011)
ok, means ADV.BAK and ADV2.BAK of AdventureWorks db contain the full backup. And if any on bak file get corrupted I wont be able to restore the full backup.
that is correct.
beejug1983 (9/3/2011)
and while restoring I have to follow the below syntax :RESTORE DATABASE AdventureWorks FROM
DISK = 'F:\MSSQL\Backup\ADV.BAK',
DISK = 'G:\MSSQL\Backup\ADV2.BAK'
GO;
Thanks in advance.
correct again
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2011 at 10:54 am
Thanks for your quick replies Perry. 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply