Showing posts with label differenent. Show all posts
Showing posts with label differenent. Show all posts
Wednesday, March 28, 2012
Restore using SQLDMO
I am using SQLDMO for restoring database from back up file . If the back up file version(SQL2000) is differenent than database version(SQL Express) I am trying to restore, does SQLDMO performs upgrade if the backup files are an earlier version. if no how can i handle that situation?It should restore the database on the server, but set it to compatability level 80, so the SQL 2000 functionality will still be there.
Subscribe to:
Posts (Atom)