July 8, 2011 at 9:50 am
Hello.
The notebook where I installed sql server 2008 is damaged so I pull out the HD in order to open the files in another PC.
I could not do a backup of my DB in sql administrator.
Can you help me to restore manually? or tell me where is my db files located? (the db was created in default location)
Regards,
Jon
July 8, 2011 at 10:45 am
\Program Files\Microsoft SQL Server\MSSQL10.<InstanceID>\
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2011 at 12:46 pm
Thank you for your reply!
So if I copy the files inside \Program Files\Microsoft SQL Server\MSSQL10.<InstanceID>\
and paste it in anoter PC (in the same place) the adminitrator will recognize again as a db ? or do I have to create a database with the same name first and then copy?
regards,
Jon
July 8, 2011 at 12:51 pm
Copy the files from that location to any location you wish. You will then need to attach those files inside of SSMS.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply