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:
Post Comments (Atom)
No comments:
Post a Comment