Pages

Thursday, August 22, 2013

SQL SERVER – Restore Database Backup using SQL Script (T-SQL) | Journey to SQL Authority with Pinal Dave

Database YourDB has full backup YourBaackUpFile.bak. It can be restored using following two steps. Step 1: Retrive the Logical file name of the database from backup. RESTORE FILELISTONLY FROM DISK = 'D:BackUpYourBaackUpFile.bak' GO Step 2: Use the values in the LogicalName Column in following Step. ----Make Database to single user Mode ALTER DATABASE YourDB SET… Continue Reading...

Source: SQL SERVER – Restore Database Backup using SQL Script (T-SQL) | Journey to SQL Authority with Pinal Dave