hi, at first i had used sqlserver2005 and i created datbase named vb.mdb. at he time time of formatting the system i had taken the back up,it has turned into vb.bak file. now later on i installed sqlserver2000 in my system, now i need to restore this databse into this sqlserver2000. my sqlserver2000 is nativeclient, i have server in my oofice and sqlserver2000 is there in that system, so we r connecting to that. can u tell me the procedure to restore my database.
You can not restore a Backup made with SQL2005 in SQL2000.
You will have to create a script from the SQL2005 database, use that to create a database in SQL2000 (having removed any SQL2005-specific features that you may have used), and then transfer the data - e.g. using DTS (you will have to resolve any databases not supported under SQL200, if you have used any)
problem with .bak file
Posted - 01/12/2007 : 00:15:57
