Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Towards the innovative SQL ideas
Browse by Tags · View All
sql server 125
sql 124
ms sql server 119
ms sql 118
database 109
tsql 81
#SQL Server 78
t-sql 75
#sql 71
sql server general 67

Archive · View All
April 2011 14
July 2011 12
May 2011 12
August 2011 11
June 2011 10
September 2011 8
December 2011 6
November 2011 6
September 2013 5
June 2013 5

SQL Server - Restore database from multiple full backup files

Feb 29 2012 12:00AM by Paresh Prajapati   

As I know database restoration is a best practice on periodically to check and verify database backup copies and issues while restoration due to some stuffs. I have wrote for the database backups as how can we perform full database backup completely and split in to multiple files to reduce IO and time. As we have performed full database backups into split multiples files, Same way we will perform restoration from those complete and split multiple files.

First we will see to restore full database complete backup and tried for from multiple files.

#1. Using TSQL
Let us run the below script first and get the logical names for database data and log files
RESTORE FILELISTONLY FROM DISK = 'D:\DBBackups\ReportServer\ReportServer.bak'     
After collection and putting logical file names in below script , it will restore the database from complete backup.
RESTORE DATABASE ReportServerComplteCopy FROM 
DISK = 'D:\DBBackups\ReportServer\ReportServer.bak'
WITH REPLACE ,
MOVE 'ReportServer' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER11\MSSQL\DATA\ReportServerComplteCopy.mdf',
MOVE 'ReportServer_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER11\MSSQL\DATA\ReportServerComplteCopy_log.ldf'
 
 
 
 
 
 
As above we can restore database from multiple files as following,
RESTORE DATABASE ReportServerSplitCopy FROM 
 DISK = 'D:\DBBackups\ReportServer\ReportServer_Split1.bak'
,DISK = 'D:\DBBackups\ReportServer\ReportServer_Split2.bak'
,DISK = 'D:\DBBackups\ReportServer\ReportServer_Split3.bak'
WITH REPLACE ,
MOVE 'ReportServer' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER11\MSSQL\DATA\ReportServerSplitCopy.mdf',
MOVE 'ReportServer_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER11\MSSQL\DATA\ReportServerSplitCopy_log.ldf'
 





#2. From Management Studio. 
We can also perform restoration from SSMS by adding those multiple backups as per shot below.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


 You can see over here after adding those files it will shown as single backup set. 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Hope this help you.

Tags: #sql, #sql Server, database, Maintenance, ms sql, ms sql server, Performance, query, restore, SQL, SQL Scripts, SQL Server General, t-sql, tsql, backup


Paresh Prajapati
6 · 23% · 7475
5
 
0
Lifesaver
 
 
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL Server - Restore database from multiple full backup files" rated 5 out of 5 by 5 readers
SQL Server - Restore database from multiple full backup files , 5.0 out of 5 based on 5 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]