Langsung ke konten utama

Postingan

Menampilkan postingan dengan label SQL Server 2012

How Produce Yous Restore A Database From Its Backup?

Influenza A virus subtype H5N1 backup of Northwind database was obtained from the SQL Server Management Studio (v 17.1) . You should live on able to restore using the SQL Server Management Studio installed when you lot installed the SQL Server 2012 Database engine. Follow these steps to restore the Northwind database to an illustration of SQL Server 2012 (x86) installed on the same computer. Step 1. Start SQL Server Management Studio v17.1 (Run every bit administrator) The SSMS is version 17.1 in addition to Hodentek9\PCATT is a SQL Server 2012 Express Step 2. Right click the Databases node highlighted inwards the PCATT isntnace every bit shown. RestoreDB_01 Step 3: Click Restore Database... Restore Database window is displayed every bit shown. RestoreDB_02 Step 4: The Default Source is Database and it is greyed out every bit shown. Chnage it to Device . The Restore Database gets changed every bit shown. RestoreDB_03 Step 5: Click the ellipsis push ...