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 |
|
SQLFAN
Starting Member
7 Posts |
 Posted - 2004-09-02 : 08:12:40
|
| Hi,Trying to import from a SQL7 DB to a SQL 2000 Server. I have copied over the .bak file and .trn from the SQL7 box to the Backup folder on the SQL 2K box. I then created a blank database and ran restore database wizard. At this point on the general tab I fill out the database I want to restore as. Use the From Device option and specify the .bak file. When I run it I get a long error message saying:-device activation error. The physical file name D:\.... may be incorrect. Use WITH MOVE to identify a valid location for the file. Now the d:\ drive was where the sql7 stored its backups, but my new sql2k box only has a C drive. How do change this so sql2k can find the file to restore?Thanks. |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-09-02 : 08:26:23
|
| You need to go to the Options tab and overwrite the 'Restore As' values which contain the physical path names for the data and log files.Raymond |
 |
|
|
SQLFAN
Starting Member
7 Posts |
Posted - 2004-09-02 : 09:14:24
|
quote:
Originally posted by raymondpeacock
You need to go to the Options tab and overwrite the 'Restore As' values which contain the physical path names for the data and log files.Raymond
Thank you for that. Worked fine. Can't believe I didn't see that! |
|
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-09-02 : 09:16:32
|
| No problem. We've all been through that kind of experience!Raymond |
|
|
|
SQLFAN
Starting Member
7 Posts |
Posted - 2004-09-02 : 11:36:22
|
| A couple of my databases that are part of my maintenance plan don't appear to produce a .trn file. They only have .bak files. I've checked the maintenance plan and it is the same for all dbs.So when I try and restore just the .bak file in 2k it references the .mdf and .ldf file location on the sql7 box (c:\mssql7\dataI also have one database that has both a .bak and .trn but when I try to restore in 2k it makes reference to the .mdf and .ldf on the c:\mssql7\dataAny ideas why these could be different from the ones that came over fine? |
|
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-09-02 : 11:44:40
|
| I think the .trn you are referring to is a transaction log backup? If so, whether or not a database has these is dependant on it's recovery mode. In SQL 2000 this Simple, Bulk-Logged or Full. In SQL 7 I think it depended on the checked options for Truncate Log on Checkpoint and Select Into/Bulk-copy. These options are database specific and therefore you might have .trn for one database but not another.Regardless of that, the pointers to c:\mssql7\data will be because that's were the data files were for those databases. It's not a feature of them having transaction log backups.Raymond |
|
|
|
SQLFAN
Starting Member
7 Posts |
Posted - 2004-09-07 : 04:55:50
|
| Thank you for the clarification. So is it going to be possible to restore these dbs in SQL2k? And if so how do I do it. Thanks in advance. |
|
|
|
|
|
|
Importing a SQL7 db into SQL2000