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-04-08 : 09:48:02
|
| Nathan writes "How on earth do I restore a database backed up in SQL Server 2000 into SQl Server 7.0?SQL Server 2000 is standard on our desktops here at work but the hosting provider uses SQL Server 7.0.On a recent job, all I had to do was add a column to a table and modify one simple stored procedure.The support staff at the hosting company have stated that they will only take *.bak files and use these to restore the database. I understand that this has serious implications for data concurrency but fortunately (and so far this is the only fortunate point) the data hasnt changes in three months.When they try and restore the database backup I have supplied they get some kind of version error.Is there anyway I can output a .bak file so SQL Server 7.0 will behave?Or do I start throwing darts at the hosting companies logo?Nath" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-08 : 09:56:14
|
Get the darts ready, you cannot restore a SQL2K backup to a 7.0 database.Since all you're doing is adding a column and modifying a procedure, you can generate a script for both and send the host the script and have them execute it (actually, you just need the ALTER TABLE part that adds the column) Normally I'd be really skeptical that a hosting company could DO that  but they seem to know how to do a RESTORE, so that should be OK. |
 |
|
|
sqlxpert
Starting Member
11 Posts |
Posted - 2002-04-08 : 18:18:28
|
| If you want to send a *.bak file than you can create a empty db on sql 7.0 , pupulate it using DTS or script+bcp and then send the backup of this. There is no way that you can restore a sql 2000 db to sql 7.0AB |
|
|
|
|
|
|
Restoring a SQL 2000 database into SQL 7.0