Hello all,
I have been seeing problems in restoring database to SQL Server 2005. The source is a .bak file backuped from SQL 2000. Everything in the process went well and at last the restore window told me the resotre has been successfully complete. But in management studio, it keeps telling me the database is restoring, I can not access it or open the property page. I tried the process many times already.
This occured several times in my Sep CTP platform so I removed it and installed the released version, but no good.
My environment: win xp sp2, SQL 2005
Any ideas?
When you restore the db, make sure you specify WITH NORECOVERY. This keeps the system from attempting to rollback uncommitted transactions.
No comments:
Post a Comment