freshfordian
asked on
Question on Microsoft SQL -Restoring a Database
Hi Experts.
I have a backup of a Windows SBS 2011. I can mount the drive and view the files. I have an MSSQL database called My_Clients. Outside of the existng server backup, there is no mssql backup of this DB. I cannot restore the server immediately.
Can I find the physical location of this DB, copy it to another SQL instance to access the tables? Can I restore this alone? What are your suggestions? Thank you
I have a backup of a Windows SBS 2011. I can mount the drive and view the files. I have an MSSQL database called My_Clients. Outside of the existng server backup, there is no mssql backup of this DB. I cannot restore the server immediately.
Can I find the physical location of this DB, copy it to another SQL instance to access the tables? Can I restore this alone? What are your suggestions? Thank you
Well, you can copy the My_Clients.mdf and My_Clients.ldf files to a new location and attach it to a new SQL Server instance. Do this in SSMS with the T-SQL method as show in the BOL article.
ASKER
Forgive me. Relatively new to this. What is SSMS t-sql , BOL article? Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have downloaded Microsoft SQL EXPRESS 2008 with the management tools and this is now running on my windows 7 pc. I have also copied over the mdf and ldf files as youc advised. Am I ok thus far?
Yup. Copy the files in the default folders. This should be C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\ MSSQL\DATA . Then use the attach command from the linked article.
ASKER
Thank you. That worked a treat. One final question. Is it possible to view records from within Management Studio?
ASKER
Forget last question. I ran a query that answers the question. Thank you again for your help
ASKER