Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jonasggg
Starting Member
4 Posts |
 Posted - 2011-07-08 : 11:49:26
|
| 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 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-08 : 12:38:54
|
| If you didn't get a backup, then there's nothing to restore.You can use sp_attach_db if you copy the data and log files to a new machine running SQL Server.You'll have to find the files yourself, but by default, they will be in C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA or something close to that on your drive. |
 |
|
|
|
|
|
Restore Database manually