April 24, 2009 at 2:41 am
Hi,
I caught in a strange problem, i have a log backup with size 104 GB on the higher region (STAGING region which has same replica of PRODUCTION server)
Most of the time,we have space issue on STAGING region bcoz we have mirroring set up on it so its very difficult to SHRINK it as we need to break the mirroring , it also need HIGH space, time and CPU-IO usage.
So we are planning to move its backup copy on two different location
so it is possible to divide and move the backup/log file on two different disk/location ?
please help me.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 24, 2009 at 3:01 am
If you want to split a backup over two devices, you can specify 2 (or more) destinations and the backup will be striped across those. Note that you need all of them to restore, if you're missing one the backup is incomplete and won't restore.
An example from Books Online:
BACKUP DATABASE AdventureWorks
TO DISK='X:\SQLServerBackups\AdventureWorks1.bak',
DISK='Y:\SQLServerBackups\AdventureWorks2.bak',
DISK='Z:\SQLServerBackups\AdventureWorks3.bak'
WITH FORMAT,
MEDIANAME = 'AdventureWorksStripedSet0',
MEDIADESCRIPTION = 'Striped media set for AdventureWorks database;
GO
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 24, 2009 at 4:03 am
thansk a lot
but How do i restore it
can u please provide the restoring script?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 24, 2009 at 6:32 am
bhuvnesh.dogra (4/24/2009)
but How do i restore itcan u please provide the restoring script?
Did you check the syntax of the RESTORE command in Books Online? Like backup, there can be multiple files or tapes specified. For backup that where the backup should go. For restore that's where it will read from.
RESTORE DATABASE AdventureWorks
FROM DISK='X:\SQLServerBackups\AdventureWorks1.bak',
DISK='Y:\SQLServerBackups\AdventureWorks2.bak',
DISK='Z:\SQLServerBackups\AdventureWorks3.bak'
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply