Langsung ke konten utama

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 along 'Device' inwards the inwards a higher house image.

Select backup devices window shows on exceed of Restore Database window every bit shown.


 RestoreDB_04

Step 6: Click Add push inwards Select backup devices window.
Locate Backup File window gets displayed every bit shown.


RestoreDB_05

Usually the 'backup files amongst extension .bak' are establish inwards the next directory inwards the illustration of x32 chip SQL Server.
C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.PCATT\MSSQL\Backup

 However, for this practice it is stored inwards a unlike location.

Step 7: Now browse to that place in addition to highlight the Northwind.bak (A backup file which came from a Microsoft site) every bit shown.


RestoreDB_06

Step 8: Click OK. The file path is entered inwards the Select backup devices window every bit shown.


 RestoreDB_07.png

Step 9: Click OK
You are returned to the Restore Database - Northwind every bit shown.


RestoreDB_08.png

Step 10: Click OK inwards the above.

Microsoft SQL Server Managment Studio message reports that the database
'Northwind' restored successfully.


RestoreDB_09.png

Step 11: Click OK to the message. Verify that Northwind database is inwards the SQL Server 2012 illustration Hodentek9\PCATT


RestoreDB_10.png


Bye




Label:

Komentar

Posting Komentar

Postingan populer dari blog ini

What Happenned To My Restore Points Inward Windows 10?

They disappeared because in that place was an automatic update of the operating system. One creates organisation restore points to become dorsum inward representative in that place is a problem. Typically when you lot run into around rpoblem you lot would desire to become dorsum to a restore indicate you lot accept created. The restore indicate would notwithstanding last available to you lot were it non for the automatic Windows Updates. It would last squeamish if in that place is a agency of having OS on ane drive that does non update (so restore points are available) as well as OS on the other that tin update as well as install the better(?) code.
Posting Komentar
Baca selengkapnya

Download As Well As Install Written Report Builder For Sql Server 2016

Report Builder is a highly productive, stand-alone tool for authoring reports as well as deploying them on configured Microsoft Reporting services study servers. It tin purpose information from dissimilar kinds of information sources to produce  a multifariousness of reports, from difficult copies to spider web based reporting. Report Builder three Details: -------------- Version: 14.0.344.82 File Name: ReportBuilder3.msi Date Published: 3/9/2017 File Size: 22.6 MB ----------------- You require Microsoft .NET Framework 4.5 . The retentiveness as well as CPU requirements are average. This is supported on  the next OSs: Windows 10 , Windows 7, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2 download from here: https://www.microsoft.com/en-us/download/confirmation.aspx?id=53613 Please review the before versions of Report builder inwards 2 of my published books here: The minute ma...
Posting Komentar
Baca selengkapnya

What Version Of Sql Server Information Tools Tin Forcefulness Out Endure Used Amongst Visual Studio Community?

The recommended version of VS Community to purpose the latest SSDT is Visual Studio 2015. The version of SSDT amongst Visual Studio 2015 Update iii is  14.0.60519.0 . With this version of SSDT you lot tin usage the next types of Business Intelligence projects for which you lot tin discovery the templates inwards the New Project Menu shown here: Analysis Services Project templates: Integration Services Project templates:   Reporting Services Project templates I am non certain if at that spot are templates online for Business Intelligence projects. I tried too did non discovery any.
Posting Komentar
Baca selengkapnya