Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-16 : 09:43:18
|
| Wiktor Torq writes "it should works and it does so but but not exactly as I expectin code (VB, connection through ADO) I call t-sql statement:RESTORE DATABASE mojabaza FROM DISK = 'sciezka' WITH REPLACEbackup copy is then restored but I CAN'T USE IT (connect to it etc.) because server claims that database has wrong version (515) and he tells me to upgrade the database (to version 539)!it's strange because when I call the same statement from Query Analyzer it upgrades database by itself:Processed 768 pages for database 'tSQL', file tSQL' on file 1.Processed 1 pages for database 'tSQL', file 'tSQL_log' on file 1.Converting database 'tSQL' from version 515 to the current version 539.Database 'tSQL' running the upgrade step from version 515 to version 524....Database 'tSQL' running the upgrade step from version 538 to version 539....I would like to allow my customers to migrate to sql 2000 (if they want to). what should I do (to upgrade the db after restoring) in my ado/VB code? why this statement behaves in a different way when launched by ADO vs launched by QAnalyzer?any help would be appreciated" |
|
|
|
|
|
restore MSDE 1.0 backup on SQL 2000