{"id":1156,"date":"2007-10-10T01:35:32","date_gmt":"2007-10-10T01:35:32","guid":{"rendered":"\/blogs\/paul\/post\/Search-Engine-QA-7-Restoring-from-a-backup-file-containing-multiple-database-backups.aspx"},"modified":"2017-04-13T09:52:06","modified_gmt":"2017-04-13T16:52:06","slug":"search-engine-qa-7-restoring-from-a-backup-file-containing-multiple-database-backups","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-7-restoring-from-a-backup-file-containing-multiple-database-backups\/","title":{"rendered":"Search Engine Q&A #7: Restoring from a backup file containing multiple database backups"},"content":{"rendered":"


\n

This is another question that came up on the Disaster Recovery forum<\/a> on MSDN. Paraphrasing – ‘ I have a backup file containing full backups for 45 databases. How can I restore them all using a script?’<\/P>
\n

The answer is pretty straightforward. Let’s create the situation described, using 3 databases for clarity rather than 45:<\/P>
\n


\n

BACKUP<\/FONT> <\/FONT>DATABASE<\/FONT> tinylogtest <\/FONT>TO<\/FONT> <\/FONT>DISK<\/FONT> <\/FONT>=<\/FONT> <\/FONT>‘c:\\sqlskills\\mixedbackups.bck’<\/FONT> <\/FONT>WITH<\/FONT> <\/FONT>NAME<\/FONT> <\/FONT>=<\/FONT> <\/FONT>‘tinylogtest 10\/09\/07’<\/FONT>,<\/FONT> <\/FONT>INIT<\/FONT>;<\/P><\/FONT>
\n

BACKUP<\/FONT> <\/FONT>DATABASE<\/FONT> pagesplittest <\/FONT>TO<\/FONT> <\/FONT>DISK<\/FONT> <\/FONT>=<\/FONT> <\/FONT>‘c:\\sqlskills\\mixedbackups.bck’<\/FONT> <\/FONT>WITH<\/FONT> <\/FONT>NAME<\/FONT> <\/FONT>=<\/FONT> <\/FONT>‘pagesplittest 10\/09\/07’<\/FONT>;<\/P><\/FONT>
\n

BACKUP<\/FONT> <\/FONT>DATABASE<\/FONT> ghostrecordtest <\/FONT>TO<\/FONT> <\/FONT>DISK<\/FONT> <\/FONT>=<\/FONT> <\/FONT>‘c:\\sqlskills\\mixedbackups.bck’<\/FONT> <\/FONT>WITH<\/FONT> <\/FONT>NAME<\/FONT> <\/FONT>=<\/FONT> <\/FONT>‘ghostrecordtest 10\/09\/07’<\/FONT>;<\/P><\/FONT>
\n

GO<\/FONT><\/FONT><\/FONT><\/P><\/BLOCKQUOTE>
\n

You now can’t do a regular restore from that backup file for any database except the first one in the file:<\/FONT><\/P>
\n


\n

RESTORE<\/FONT><\/FONT> <\/FONT>DATABASE<\/FONT> pagesplittest <\/FONT>FROM<\/FONT> <\/FONT>DISK<\/FONT> <\/FONT>=<\/FONT> <\/FONT>‘c:\\sqlskills\\mixedbackups.bck’ <\/FONT>WITH<\/FONT> <\/FONT>REPLACE<\/FONT>;<\/P><\/FONT><\/FONT>
\n

GO<\/FONT><\/P><\/BLOCKQUOTE><\/FONT><\/FONT>
\n


\n

Msg 1834, Level 16, State 1, Line 1<\/FONT><\/P>
\n

The file ‘c:\\tinylogtest\\tinylogtest.mdf’ cannot be overwritten. It is being used by database ‘tinylogtest’.<\/FONT><\/P>
\n

Msg 3156, Level 16, State 4, Line 1<\/FONT><\/P>
\n

File ‘fgt_mdf’ cannot be restored to ‘c:\\tinylogtest\\tinylogtest.mdf’. Use WITH MOVE to identify a valid location for the file.<\/FONT><\/P>
\n

Msg 1834, Level 16, State 1, Line 1<\/FONT><\/P>
\n

The file ‘c:\\tinylogtest\\tinylogtest.ldf’ cannot be overwritten. It is being used by database ‘tinylogtest’.<\/FONT><\/P>
\n

Msg 3156, Level 16, State 4, Line 1<\/FONT><\/P>
\n

File ‘fgt_log’ cannot be restored to ‘c:\\tinylogtest\\tinylogtest.ldf’. Use WITH MOVE to identify a valid location for the file.<\/FONT><\/P>
\n

Msg 3119, Level 16, State 1, Line 1<\/FONT><\/P>
\n

Problems were identified while planning for the RESTORE statement. Previous messages provide details.<\/FONT><\/P>
\n

Msg 3013, Level 16, State 1, Line 1<\/FONT><\/P>
\n

RESTORE DATABASE is terminating abnormally.<\/FONT><\/P><\/BLOCKQUOTE><\/FONT><\/FONT><\/FONT>
\n

So how to restore the other databases apart from the first one? The answer is that you need to specify which of the backups within the file you’re after. You can find the positions using the RESTORE HEADERONLY<\/FONT> command:<\/FONT><\/P>
\n


\n

RESTORE<\/FONT><\/FONT> <\/FONT>HEADERONLY<\/FONT> <\/FONT>FROM<\/FONT> <\/FONT>DISK<\/FONT> <\/FONT>=<\/FONT> <\/FONT>‘c:\\sqlskills\\mixedbackups.bck’<\/FONT>;<\/P><\/FONT><\/FONT>
\n

GO<\/FONT><\/P><\/BLOCKQUOTE>
\n

This returns lots of information:<\/P>
\n

<\/FONT><\/FONT><\/P>
\n

and then a whole bunch more columns and then ending with:<\/P>
\n

<\/P>
\n

For our purposes, the interesting things to note are the Position<\/FONT>, DatabaseName<\/FONT>, and BackupTypeDescription<\/FONT>. In our simple example we have 3 full backups. To restore the pagesplittest database as we tried to do above, we have to specifiy the position within the file of the backup we want to restore – just the database name isn’t enough.<\/P>
\n


\n

RESTORE<\/FONT><\/FONT> <\/FONT>DATABASE<\/FONT> pagesplittest <\/FONT>FROM<\/FONT> <\/FONT>DISK<\/FONT> <\/FONT>=<\/FONT> <\/FONT>‘c:\\sqlskills\\mixedbackups.bck’ <\/FONT>WITH<\/FONT> <\/FONT>REPLACE<\/FONT>,<\/FONT> <\/FONT>FILE<\/FONT> <\/FONT>=<\/FONT> 2<\/FONT>;<\/P><\/FONT><\/FONT>
\n

GO<\/FONT><\/P><\/BLOCKQUOTE>
\n

And it works. So the question asked how to do this, plus how to do it in a script. Below is a script I’ve adapted from the example I wrote for the Books Online for DBCC SHOWCONTIG<\/FONT> back in 1999 when I rewrote DBCC SHOWCONTIG<\/FONT> for SQL Server 2000.<\/P>
\n

Enjoy!<\/P>
\n


\n

— Create a temporary table to hold the output from RESTORE HEADERONLY<\/P>
\n

<\/FONT>CREATE<\/FONT><\/FONT> <\/FONT>TABLE<\/FONT> master<\/FONT>.<\/FONT>dbo<\/FONT>.<\/FONT>restoreheaderonly <\/FONT>(<\/P><\/FONT><\/FONT>
\n


\n

BackupName <\/FONT><\/FONT>NVARCHAR<\/FONT> <\/FONT>(<\/FONT>128<\/FONT>),<\/FONT> BackupDescription <\/FONT>NVARCHAR<\/FONT> <\/FONT>(<\/FONT>255<\/FONT>),<\/FONT> BackupType <\/FONT>SMALLINT<\/FONT>, <\/FONT><\/FONT>ExpirationDate <\/FONT><\/FONT>DATETIME<\/FONT>,<\/FONT><\/FONT><\/P>
\n

Compressed <\/FONT>TINYINT<\/FONT>,<\/FONT> Position <\/FONT>SMALLINT<\/FONT>,<\/FONT> DeviceType <\/FONT>TINYINT<\/FONT>, <\/FONT><\/FONT>UserName <\/FONT><\/FONT>NVARCHAR<\/FONT> <\/FONT>(<\/FONT>128<\/FONT>),<\/FONT> ServerName <\/FONT>NVARCHAR<\/FONT> <\/FONT>(<\/FONT>128<\/FONT>),<\/FONT><\/FONT><\/P>
\n

DatabaseName <\/FONT>NVARCHAR<\/FONT> <\/FONT>(<\/FONT>128<\/FONT>),<\/FONT> DatabaseVersion <\/FONT>INT<\/FONT>, <\/FONT><\/FONT>DatabaseCreationDate <\/FONT><\/FONT>DATETIME<\/FONT>,<\/FONT> BackupSize <\/FONT>NUMERIC<\/FONT> <\/FONT>(<\/FONT>20<\/FONT>,<\/FONT> 0<\/FONT>),<\/FONT><\/FONT><\/P>
\n

FirstLSN <\/FONT>NUMERIC<\/FONT> <\/FONT>(<\/FONT>25<\/FONT>,<\/FONT> 0<\/FONT>), <\/FONT><\/FONT>LastLSN <\/FONT><\/FONT>NUMERIC<\/FONT> <\/FONT>(<\/FONT>25<\/FONT>,<\/FONT>0<\/FONT>),<\/FONT> CheckpointLSN <\/FONT>NUMERIC<\/FONT> <\/FONT>(<\/FONT>25<\/FONT>,<\/FONT>0<\/FONT>),<\/FONT> DatabaseBackupLSN <\/FONT>NUMERIC<\/FONT> <\/FONT>(<\/FONT>25<\/FONT>,<\/FONT> 0<\/FONT>),<\/P><\/FONT><\/FONT>
\n

BackupStartDate <\/FONT><\/FONT>DATETIME<\/FONT>,<\/FONT> BackupFinishDate <\/FONT>DATETIME<\/FONT>,<\/FONT> SortOrder <\/FONT>SMALLINT<\/FONT>,<\/FONT> <\/FONT>CodePage<\/FONT> <\/FONT>SMALLINT<\/FONT>, <\/FONT><\/FONT>UnicodeLocaleId <\/FONT><\/FONT>INT<\/FONT>,<\/FONT><\/FONT><\/P>
\n

UnicodeComparisonStyle <\/FONT>INT<\/FONT>,<\/FONT> CompatibilityLevel <\/FONT>TINYINT<\/FONT>,<\/FONT> SoftwareVendorId <\/FONT>INT<\/FONT>, <\/FONT><\/FONT>SoftwareVersionMajor <\/FONT><\/FONT>INT<\/FONT>,<\/FONT><\/FONT><\/P>
\n

SoftwareVersionMinor <\/FONT>INT<\/FONT>,<\/FONT> SoftwareVersionBuild <\/FONT>INT<\/FONT>,<\/FONT> MachineName <\/FONT>NVARCHAR<\/FONT> <\/FONT>(<\/FONT>128<\/FONT>), <\/FONT><\/FONT>Flags <\/FONT><\/FONT>INT<\/FONT>,<\/FONT> BindingID <\/FONT>UNIQUEIDENTIFIER<\/FONT>,<\/FONT><\/FONT><\/P>
\n

RecoveryForkID <\/FONT>UNIQUEIDENTIFIER<\/FONT>,<\/FONT> Collation <\/FONT>NVARCHAR<\/FONT> <\/FONT>(<\/FONT>128<\/FONT>), <\/FONT><\/FONT>FamilyGUID <\/FONT><\/FONT>UNIQUEIDENTIFIER<\/FONT>,<\/FONT> HasBulkLoggedData <\/FONT>BIT<\/FONT>,<\/FONT><\/FONT><\/P>
\n

IsSnapshot <\/FONT>BIT<\/FONT>,<\/FONT> IsReadOnly <\/FONT>BIT<\/FONT>,<\/FONT> IsSingleUser <\/FONT>BIT<\/FONT>, <\/FONT><\/FONT>HasBackupChecksums <\/FONT><\/FONT>BIT<\/FONT>,<\/FONT> IsDamaged <\/FONT>BIT<\/FONT>,<\/FONT> BeginsLogChain <\/FONT>BIT<\/FONT>,<\/FONT><\/FONT><\/P>
\n

HasIncompleteMetaData <\/FONT>BIT<\/FONT>,<\/FONT> IsForceOffline <\/FONT>BIT<\/FONT>, <\/FONT><\/FONT>IsCopyOnly <\/FONT><\/FONT>BIT<\/FONT>,<\/FONT> FirstRecoveryForkID <\/FONT>UNIQUEIDENTIFIER<\/FONT>,<\/FONT><\/FONT><\/P>
\n

ForkPointLSN <\/FONT>NUMERIC<\/FONT> <\/FONT>(<\/FONT>25<\/FONT>,<\/FONT> 0<\/FONT>)<\/FONT> <\/FONT>NULL, <\/FONT><\/FONT>RecoveryModel <\/FONT><\/FONT>NVARCHAR<\/FONT> <\/FONT>(<\/FONT>60<\/FONT>),<\/FONT> DifferentialBaseLSN <\/FONT>NUMERIC<\/FONT> <\/FONT>(<\/FONT>25<\/FONT>,<\/FONT> 0<\/FONT>)<\/FONT> <\/FONT>NULL,<\/FONT><\/FONT><\/P>
\n

DifferentialBaseGUID <\/FONT>UNIQUEIDENTIFIER<\/FONT>, <\/FONT><\/FONT>BackupTypeDescription <\/FONT><\/FONT>NVARCHAR<\/FONT> <\/FONT>(<\/FONT>60<\/FONT>),<\/FONT> BackupSetGUID <\/FONT>UNIQUEIDENTIFIER<\/FONT> <\/FONT>NULL);<\/P><\/BLOCKQUOTE><\/FONT><\/FONT>
\n

GO<\/P>
\n

 <\/P><\/FONT>
\n

— Populate the table<\/P>
\n

<\/FONT>INSERT<\/FONT><\/FONT> <\/FONT>INTO<\/FONT> master<\/FONT>.<\/FONT>dbo<\/FONT>.<\/FONT><\/FONT>restoreheaderonly <\/FONT><\/FONT>EXEC<\/FONT> <\/FONT>(<\/FONT>‘RESTORE HEADERONLY FROM DISK = ”C:\\sqlskills\\mixedbackups.bck”’<\/FONT>)<\/FONT> <\/FONT>;<\/P><\/FONT><\/FONT>
\n

GO<\/P>
\n

 <\/P><\/FONT>
\n

DECLARE<\/FONT><\/FONT> @Position <\/FONT>SMALLINT<\/FONT>;<\/P><\/FONT><\/FONT>
\n

DECLARE<\/FONT><\/FONT> @DatabaseName <\/FONT>NVARCHAR<\/FONT> <\/FONT>(<\/FONT>128<\/FONT>);<\/P><\/FONT><\/FONT>
\n

DECLARE<\/FONT><\/FONT> @ExecString <\/FONT>NVARCHAR<\/FONT> <\/FONT>(<\/FONT>255<\/FONT>);<\/FONT><\/FONT><\/P>
\n

 <\/P><\/FONT><\/FONT>
\n

— Declare a cursor to iterate over the results<\/P>
\n

<\/FONT>DECLARE<\/FONT><\/FONT> databases <\/FONT>CURSOR<\/FONT> <\/FONT>FOR<\/P><\/FONT><\/FONT>
\n


\n

<\/FONT>SELECT<\/FONT> Position<\/FONT>,<\/FONT><\/FONT> DatabaseName <\/FONT><\/FONT>FROM<\/FONT> master<\/FONT>.<\/FONT>dbo<\/FONT>.<\/FONT><\/FONT>restoreheaderonly <\/FONT><\/FONT>WHERE<\/FONT> BackupTypeDescription <\/FONT>=<\/FONT> <\/FONT>‘Database’<\/FONT>;<\/FONT><\/FONT><\/P><\/BLOCKQUOTE>
\n

 <\/P><\/FONT><\/FONT>
\n

— Open the cursor.<\/P><\/FONT>
\n

OPEN<\/FONT><\/FONT> databases<\/FONT>;<\/FONT><\/FONT><\/P>
\n

 <\/P><\/FONT><\/FONT>
\n

— Loop through the databases.<\/P><\/FONT>
\n

FETCH<\/FONT><\/FONT> <\/FONT>NEXT<\/FONT> <\/FONT>FROM<\/FONT> databases <\/FONT>INTO<\/FONT> @Position<\/FONT>,<\/FONT> @DatabaseName<\/FONT>;<\/P><\/FONT><\/FONT>
\n

WHILE<\/FONT><\/FONT> <\/FONT>@@FETCH_STATUS<\/FONT> <\/FONT>=<\/FONT> 0<\/FONT><\/P><\/FONT><\/FONT>
\n

BEGIN<\/P><\/FONT>
\n


\n

<\/FONT>SELECT<\/FONT> @ExecString <\/FONT>=<\/FONT> <\/FONT>‘RESTORE DATABASE ‘<\/FONT> <\/FONT>+<\/FONT> <\/FONT>RTRIM<\/FONT> <\/FONT>(<\/FONT>@DatabaseName<\/FONT>)<\/FONT> <\/FONT>+<\/P><\/FONT><\/FONT>
\n


\n

<\/FONT>‘ FROM DISK = ”C:\\sqlskills\\mixedbackups.bck”’<\/FONT> <\/FONT>+<\/P><\/FONT><\/FONT>
\n

<\/FONT>‘ WITH REPLACE, FILE = ‘<\/FONT> <\/FONT>+<\/FONT> <\/FONT>RTRIM<\/FONT> <\/FONT>(<\/FONT>CONVERT<\/FONT> <\/FONT>(<\/FONT>VARCHAR<\/FONT> <\/FONT>(<\/FONT>10<\/FONT>),<\/FONT> @Position<\/FONT>));<\/P><\/BLOCKQUOTE><\/FONT><\/FONT>
\n

<\/FONT>SELECT<\/FONT> <\/FONT>‘Restoring database ‘<\/FONT> <\/FONT>+<\/FONT> <\/FONT>RTRIM<\/FONT> <\/FONT>(<\/FONT>@DatabaseName<\/FONT>);<\/P><\/FONT><\/FONT>
\n

<\/FONT>EXEC<\/FONT> <\/FONT>(<\/FONT>@ExecString<\/FONT>);<\/P><\/FONT><\/FONT>
\n

<\/FONT>FETCH<\/FONT> <\/FONT>NEXT<\/FONT> <\/FONT>FROM<\/FONT> databases <\/FONT>INTO<\/FONT> @Position<\/FONT>,<\/FONT> @DatabaseName<\/FONT>;<\/P><\/BLOCKQUOTE><\/FONT><\/FONT>
\n

END<\/FONT><\/FONT>;<\/FONT><\/FONT><\/P>
\n

<\/FONT> <\/P><\/FONT>
\n

— Close and deallocate the cursor.<\/P><\/FONT>
\n

CLOSE<\/FONT><\/FONT> databases<\/FONT>;<\/P><\/FONT><\/FONT>
\n

DEALLOCATE<\/FONT><\/FONT> databases<\/FONT>;<\/FONT><\/FONT><\/P>
\n

 <\/P><\/FONT><\/FONT>
\n

— Delete the temporary table.<\/P><\/FONT>
\n

DROP<\/FONT><\/FONT> <\/FONT>TABLE<\/FONT> master<\/FONT>.<\/FONT>dbo<\/FONT>.<\/FONT>restoreheaderonly<\/FONT>;<\/P><\/FONT><\/FONT>
\n

GO<\/P><\/FONT><\/BLOCKQUOTE><\/FONT><\/FONT><\/p>\n","protected":false},"excerpt":{"rendered":"

This is another question that came up on the Disaster Recovery forum on MSDN. Paraphrasing – ‘ I have a backup file containing full backups for 45 databases. How can I restore them all using a script?’ The answer is pretty straightforward. Let’s create the situation described, using 3 databases for clarity rather than 45: […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,35,38,78],"tags":[],"class_list":["post-1156","post","type-post","status-publish","format-standard","hentry","category-backuprestore","category-disaster-recovery","category-example-scripts","category-search-engine-q-and-a"],"yoast_head":"\nSearch Engine Q&A #7: Restoring from a backup file containing multiple database backups - Paul S. Randal<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-7-restoring-from-a-backup-file-containing-multiple-database-backups\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Search Engine Q&A #7: Restoring from a backup file containing multiple database backups - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"This is another question that came up on the Disaster Recovery forum on MSDN. Paraphrasing – ‘ I have a backup file containing full backups for 45 databases. How can I restore them all using a script?’ The answer is pretty straightforward. Let’s create the situation described, using 3 databases for clarity rather than 45: […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-7-restoring-from-a-backup-file-containing-multiple-database-backups\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2007-10-10T01:35:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T16:52:06+00:00\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-7-restoring-from-a-backup-file-containing-multiple-database-backups\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-7-restoring-from-a-backup-file-containing-multiple-database-backups\/\",\"name\":\"Search Engine Q&A #7: Restoring from a backup file containing multiple database backups - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2007-10-10T01:35:32+00:00\",\"dateModified\":\"2017-04-13T16:52:06+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-7-restoring-from-a-backup-file-containing-multiple-database-backups\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-7-restoring-from-a-backup-file-containing-multiple-database-backups\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-7-restoring-from-a-backup-file-containing-multiple-database-backups\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Search Engine Q&A #7: Restoring from a backup file containing multiple database backups\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Search Engine Q&A #7: Restoring from a backup file containing multiple database backups - Paul S. Randal","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-7-restoring-from-a-backup-file-containing-multiple-database-backups\/","og_locale":"en_US","og_type":"article","og_title":"Search Engine Q&A #7: Restoring from a backup file containing multiple database backups - Paul S. Randal","og_description":"This is another question that came up on the Disaster Recovery forum on MSDN. Paraphrasing – ‘ I have a backup file containing full backups for 45 databases. How can I restore them all using a script?’ The answer is pretty straightforward. Let’s create the situation described, using 3 databases for clarity rather than 45: […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-7-restoring-from-a-backup-file-containing-multiple-database-backups\/","og_site_name":"Paul S. Randal","article_published_time":"2007-10-10T01:35:32+00:00","article_modified_time":"2017-04-13T16:52:06+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-7-restoring-from-a-backup-file-containing-multiple-database-backups\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-7-restoring-from-a-backup-file-containing-multiple-database-backups\/","name":"Search Engine Q&A #7: Restoring from a backup file containing multiple database backups - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2007-10-10T01:35:32+00:00","dateModified":"2017-04-13T16:52:06+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-7-restoring-from-a-backup-file-containing-multiple-database-backups\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-7-restoring-from-a-backup-file-containing-multiple-database-backups\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/search-engine-qa-7-restoring-from-a-backup-file-containing-multiple-database-backups\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"Search Engine Q&A #7: Restoring from a backup file containing multiple database backups"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/1156","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=1156"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/1156\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=1156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=1156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=1156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}