MOVE 'DBASE_LOG' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.DBASE\MSSQL\DATA\DBASE_1. MOVE 'DBASE' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.DBASE\MSSQL\DATA\DBASE.MDF', Enter ‘Database name’. Once you will run above Query you will get location of mdf/ldf use it Restore database using query USE MASTER Here is a step by step process to create a database in SQL server management studio: Step 1) Right Click on ‘Database’ from ‘Object Explorer’ window and then select ‘New Database.’ Step 2) Below ‘New Database’ screen will appear. So you need to run Query as below RESTORE FILELISTONLY : Directory lookup for the file "C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\DATA\AdventureWorks.MDF" failed with the operating system error 3(The system cannot find the path specified.). In above Query you need to keep in mind about. bak with SQL server query, for example RESTORE DATABASE AdventureWorks2012 FROM DISK = 'D:\AdventureWorks2012.BAK' Although it is much easier to restore database using SSMS as stated in many answers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |