Community archive

Ask something
Discussion Locked

Restoring Database

0 helpful
1 reply

by ajaygiri

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

My NT on which I had a SQL 7.0 crashed. So I had to re install NT. I renamed the MSSQL7 folder and reloaded SQL Server 7.0 again. Now I want to attach the database from the previous MSSQL folder in the newly installed SQL Server. Now the problem is that I do not have any info on the previous Unicode/Character Set and Sort Order. And every time I use the attachdb command it throws up some error regarding the Unicode/character Set/ Sort Order. How to orvercome this problem and restore the DB.

I thank any body in advance for any help.

--Ajay

1 reply

by hclarius

Back up everything first!
Do you have a good back up of your old database?

Yes.
Copy the backup from the old MSSQL7.0 backup sub-dir to the new backup sub-dir and create new backup device (which is just a file name ending in bak) in your backupsub-dir, select this "new device" (backup file) you copied and restore to new DB.

No.
Back up old DB. Copy the BAK file to new
back up sub dir and follow above.

Email me if other problems, will try to answer.

This discussion is closed to new replies.