About TDP for SQL question!

[vincent821]

I'm learning TSM now!
My boss stop "SQL Server (MSSQLSERVER)" and rename the folder C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.bak.
He want me solve this problem to susses restore data!
I use GUI restore data. Get a message "ACO5424E Could not connect to SQL server; SQL server returned: Can't connect to server XXX"
How should I restore the Data folder?

Thanks everyone!

 

[cheffern]

hi -

for MSSQL you have to at least have a base MSSQL install there to be able to restore data.
then the order is specific for the restore -

Reinstall MSSQL to former specs
Rebuild the Master database, using the Rebuildm.exe utility
Start the SQL server in single user mode: sqlservr.exe –m
Start the TDP for SQL GUI, and select the Master database for restore
Next restore the Msdb database using TDP for SQL
Now the system databases are intact, and you can restore the other databases (at the same time)

good luck -
-Chef.

 

[vincent821]

Hi-
Thanks for your answer !
But I can't find "rebuildm.exe".
My MSSQL is 2005.
It's seems that 2005 don't have rebuildm.exe utility.

I'll try to restore data by your step!

Thank you very much.