Create a Striped Backup and restore the DB with T-SQL



 
 

BACKUP DATABASE MyTestDB
 TO DISK = 'C:\MSSQL\bak\MyTestDB_20150219_stripe1_of_2.bak'
  ,DISK = 'E:\MSSQL\bak\MyTestDB_20150219_stripe2_of_2.bak'
   WITH FORMAT,COMPRESSION


   ----Restore stripped backup
RESTORE DATABASE MyTestDB2 
FROM  
DISK='C:\MSSQL\bak\MyTestDB_20150219_stripe1_of_2.bak', 
DISK='E:\MSSQL\bak\MyTestDB_20150219_stripe2_of_2.bak'
WITH
MOVE 'MyTestDB' TO 'c:\mssql\bak\MyTestDBCopy_Data.mdf', 
MOVE 'MyTestDB_Log' TO 'c:\mssql\bak\MyTestDBCopy_Log.ldf', 
RECOVERY, REPLACE, STATS = 10;
  
GO



 

http://www.sqlservercentral.com/articles/dba+skills/122679/

http://sqlserverzest.com/2013/09/03/sql-server-how-to-perform-striped-database-backup-restore-using-t-sql-command/

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s