Restoring sql7 db to sql 2000

Hi all,
I have a cd with a backup of an sql server 7 database - I need to restore it
onto my sqlserver 2000 as a new database.
How do I do this - or can it be done ?
Andy (newbie)
Yes, you can use the regular RESTORE DATABASE command to restore a SQL 7
backup into a SQL 2000 Server.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Andy Muir" <andy@.ForMeToKnow.au> wrote in message
news:%23gbcHHp1EHA.804@.TK2MSFTNGP12.phx.gbl...
> Hi all,
> I have a cd with a backup of an sql server 7 database - I need to restore
> it onto my sqlserver 2000 as a new database.
> How do I do this - or can it be done ?
> Andy (newbie)
>
sql

restoring SQL7 database to SQL2000

Hi all
just a quick question for you. has anyone had any problems restoring a SQL7 database to a SQL server 2000?
is there anything special you have to do to get it working?

thanks for your time.
Andrew.it's ok i have had it all sorted. if the admins want to delete this thread it's ok by me :)

Restoring SQL databases

We often build databases on behalf of our clients and we're still using SQL
7 as a base level as we can generate .BAK files which can be restored to SQL
7 and SQL 2000.
I assume that if we upgraded to SQL 2005 on our production server that we
will be *unable* to restore .BAK files generated on that version onto an
older server running SQL 2000 or SQL 7.
If so, how to developers normally distribute their database? Note: we can't
use DTS and we're restoring to a server on a completely separate network.
Thanks, Rob.Rob Nicholson (rob.nicholson@.nospam_unforgettable.com) writes:
> We often build databases on behalf of our clients and we're still using
> SQL 7 as a base level as we can generate .BAK files which can be
> restored to SQL 7 and SQL 2000.
> I assume that if we upgraded to SQL 2005 on our production server that we
> will be *unable* to restore .BAK files generated on that version onto an
> older server running SQL 2000 or SQL 7.
Yes, you cannot restore a backup on SQL 2005 on SQL 2000 or SQL 7.

> If so, how to developers normally distribute their database? Note: we
> can't use DTS and we're restoring to a server on a completely separate
> network.
We build our databases from scripts using our own load tool, which we
then but into an install kit. Distributing a shrink-wrapped database is good
for the first installation, but it does not fly with upgrades. So in the
end, you need an ability do to scripts.
But of course, for a first installation, attaching a complete database
makes that installation faster. For us this is not an issue, as we work
with an expensive product with a small customer base, so we upgrade
far more often that we build a new databse.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||> But of course, for a first installation, attaching a complete database
> makes that installation faster. For us this is not an issue, as we work
> with an expensive product with a small customer base, so we upgrade
> far more often that we build a new databse.
Sounds a similar scenario to our app - small user base, niche product. We
typically build and configure the system locally and then take the BAK file
to the customer for pilot installation.
Is it possible to DTS a database from SQL 2005 -> SQL 2000? It so, that
might be an option. We can set-up a SQL 2000 server in development, DTS to
there and take the BAK from that environment.
We'll not be using any SQL 2005 specific functions but I'm looking at our
strategy for 2006 which is including major upgrades of all production
servers like SQL.
Cheers, Rob.|||Rob Nicholson (rob.nicholson@.nospam_unforgettable.com) writes:
> Is it possible to DTS a database from SQL 2005 -> SQL 2000? It so, that
> might be an option. We can set-up a SQL 2000 server in development, DTS to
> there and take the BAK from that environment.
There isn't even a DTS in SQL 2005, it's called SQL Server Integration
Services. Maybe there is a way to export from SQL 2005 to SQL 2000, but
I actually tried to use the Copy Database Wizard (which uses SSIS) in that
direction the other w, but I was told to that it was not supported.
(Not that I would recommend the Copy Database Wizard anyway. I filed a
number of bugs for it during the beta programme, and not all are fixed
in the RTM version.)
If you want to look at what we use, our toolset is available as freeware
from http://www.abaris.se/abaperls/. It's fairly complex, and not easy to
get started with, but it might give you some inspiration.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Restoring Master DB or transfering logins etc

Hi there, I'm hoping you can help a SQL novice......
i need to move the SQL installs for a couple of our SQL7 servers (and sadly
no, they cant be upgraded).
i've restored the DB's no problems but i'm having problems with the master
DB and/ or its contents. i want to get all the logins, agents jobs etc from
the old servers to the new ones. restoring the master DB would do this, but
unfortunately, the drive structure on the new servers doesn match that of the
old and so the locations of the other SQL built in DB's (model, MSDB, tempdb)
is now different. if i restore the Master DB (in single user mode obviously)
the services fail to then re-start because they cant locate these DB's.
so my question.... is there any way to restart SQL service post a master
restore, without it looking for these DB's so i can then modify the file
location properties of these DB?
OR
is there any way to get stuff like the security logins, SQL agent jobs etc
from one server to another without restoring the Master DB?
many thanks for you help and advice.
Hi
There are lots discussion about such issues , try to search on.
It's my way how I do it
1) Backup all user and system databases on the old server
2) Script out all logins (MS has provide two SP to script it out)
3) Script all jobs/dts packages
4) Restore all user databases
5) Run the output of two MS store procedures on destination server
6) Run the output of jobs script.
7) Re-create all dts packages
"J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
news:990A6094-3F08-4731-BF71-EAD9D0B343AF@.microsoft.com...
> Hi there, I'm hoping you can help a SQL novice......
> i need to move the SQL installs for a couple of our SQL7 servers (and
sadly
> no, they cant be upgraded).
> i've restored the DB's no problems but i'm having problems with the master
> DB and/ or its contents. i want to get all the logins, agents jobs etc
from
> the old servers to the new ones. restoring the master DB would do this,
but
> unfortunately, the drive structure on the new servers doesn match that of
the
> old and so the locations of the other SQL built in DB's (model, MSDB,
tempdb)
> is now different. if i restore the Master DB (in single user mode
obviously)
> the services fail to then re-start because they cant locate these DB's.
> so my question.... is there any way to restart SQL service post a master
> restore, without it looking for these DB's so i can then modify the file
> location properties of these DB?
> OR
> is there any way to get stuff like the security logins, SQL agent jobs etc
> from one server to another without restoring the Master DB?
> many thanks for you help and advice.
|||http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
news:990A6094-3F08-4731-BF71-EAD9D0B343AF@.microsoft.com...
> Hi there, I'm hoping you can help a SQL novice......
> i need to move the SQL installs for a couple of our SQL7 servers (and
> sadly
> no, they cant be upgraded).
> i've restored the DB's no problems but i'm having problems with the master
> DB and/ or its contents. i want to get all the logins, agents jobs etc
> from
> the old servers to the new ones. restoring the master DB would do this,
> but
> unfortunately, the drive structure on the new servers doesn match that of
> the
> old and so the locations of the other SQL built in DB's (model, MSDB,
> tempdb)
> is now different. if i restore the Master DB (in single user mode
> obviously)
> the services fail to then re-start because they cant locate these DB's.
> so my question.... is there any way to restart SQL service post a master
> restore, without it looking for these DB's so i can then modify the file
> location properties of these DB?
> OR
> is there any way to get stuff like the security logins, SQL agent jobs etc
> from one server to another without restoring the Master DB?
> many thanks for you help and advice.
|||thankyou Uri and Andrew, you've both given me plenty to work with.
many thanks
"Andrew J. Kelly" wrote:

> http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
> http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
> http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
> to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 Using WITH MOVE in a
> Restore
> http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
> Restore
> http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scri...p?scriptid=599
> Restoring a .mdf
> http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
> for SQL Server
>
> --
> Andrew J. Kelly SQL MVP
>
> "J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
> news:990A6094-3F08-4731-BF71-EAD9D0B343AF@.microsoft.com...
>
>

Restoring Master DB or transfering logins etc

Hi there, I'm hoping you can help a SQL novice......
i need to move the SQL installs for a couple of our SQL7 servers (and sadly
no, they cant be upgraded).
i've restored the DB's no problems but i'm having problems with the master
DB and/ or its contents. i want to get all the logins, agents jobs etc from
the old servers to the new ones. restoring the master DB would do this, but
unfortunately, the drive structure on the new servers doesn match that of th
e
old and so the locations of the other SQL built in DB's (model, MSDB, tempdb
)
is now different. if i restore the Master DB (in single user mode obviously)
the services fail to then re-start because they cant locate these DB's.
so my question.... is there any way to restart SQL service post a master
restore, without it looking for these DB's so i can then modify the file
location properties of these DB?
OR
is there any way to get stuff like the security logins, SQL agent jobs etc
from one server to another without restoring the Master DB?
many thanks for you help and advice.Hi
There are lots discussion about such issues , try to search on.
It's my way how I do it
1) Backup all user and system databases on the old server
2) Script out all logins (MS has provide two SP to script it out)
3) Script all jobs/dts packages
4) Restore all user databases
5) Run the output of two MS store procedures on destination server
6) Run the output of jobs script.
7) Re-create all dts packages
"J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
news:990A6094-3F08-4731-BF71-EAD9D0B343AF@.microsoft.com...
> Hi there, I'm hoping you can help a SQL novice......
> i need to move the SQL installs for a couple of our SQL7 servers (and
sadly
> no, they cant be upgraded).
> i've restored the DB's no problems but i'm having problems with the master
> DB and/ or its contents. i want to get all the logins, agents jobs etc
from
> the old servers to the new ones. restoring the master DB would do this,
but
> unfortunately, the drive structure on the new servers doesn match that of
the
> old and so the locations of the other SQL built in DB's (model, MSDB,
tempdb)
> is now different. if i restore the Master DB (in single user mode
obviously)
> the services fail to then re-start because they cant locate these DB's.
> so my question.... is there any way to restart SQL service post a master
> restore, without it looking for these DB's so i can then modify the file
> location properties of these DB?
> OR
> is there any way to get stuff like the security logins, SQL agent jobs etc
> from one server to another without restoring the Master DB?
> many thanks for you help and advice.|||http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
news:990A6094-3F08-4731-BF71-EAD9D0B343AF@.microsoft.com...
> Hi there, I'm hoping you can help a SQL novice......
> i need to move the SQL installs for a couple of our SQL7 servers (and
> sadly
> no, they cant be upgraded).
> i've restored the DB's no problems but i'm having problems with the master
> DB and/ or its contents. i want to get all the logins, agents jobs etc
> from
> the old servers to the new ones. restoring the master DB would do this,
> but
> unfortunately, the drive structure on the new servers doesn match that of
> the
> old and so the locations of the other SQL built in DB's (model, MSDB,
> tempdb)
> is now different. if i restore the Master DB (in single user mode
> obviously)
> the services fail to then re-start because they cant locate these DB's.
> so my question.... is there any way to restart SQL service post a master
> restore, without it looking for these DB's so i can then modify the file
> location properties of these DB?
> OR
> is there any way to get stuff like the security logins, SQL agent jobs etc
> from one server to another without restoring the Master DB?
> many thanks for you help and advice.|||thankyou Uri and Andrew, you've both given me plenty to work with.
many thanks
"Andrew J. Kelly" wrote:

> http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
> http://www.support.microsoft.com/?id=314546 Moving DB's between Server
s
> http://www.support.microsoft.com/?id=224071 Moving SQL Server Database
s
> to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 Using WITH MOVE in a
> Restore
> http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
a
> Restore
> http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 User Logon and/or Permissi
on
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scr...sp?scriptid=599
> Restoring a .mdf
> http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
> for SQL Server
>
> --
> Andrew J. Kelly SQL MVP
>
> "J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
> news:990A6094-3F08-4731-BF71-EAD9D0B343AF@.microsoft.com...
>
>

Restoring Master DB or transfering logins etc

Hi there, I'm hoping you can help a SQL novice......
i need to move the SQL installs for a couple of our SQL7 servers (and sadly
no, they cant be upgraded).
i've restored the DB's no problems but i'm having problems with the master
DB and/ or its contents. i want to get all the logins, agents jobs etc from
the old servers to the new ones. restoring the master DB would do this, but
unfortunately, the drive structure on the new servers doesn match that of the
old and so the locations of the other SQL built in DB's (model, MSDB, tempdb)
is now different. if i restore the Master DB (in single user mode obviously)
the services fail to then re-start because they cant locate these DB's.
so my question.... is there any way to restart SQL service post a master
restore, without it looking for these DB's so i can then modify the file
location properties of these DB?
OR
is there any way to get stuff like the security logins, SQL agent jobs etc
from one server to another without restoring the Master DB?
many thanks for you help and advice.Hi
There are lots discussion about such issues , try to search on.
It's my way how I do it
1) Backup all user and system databases on the old server
2) Script out all logins (MS has provide two SP to script it out)
3) Script all jobs/dts packages
4) Restore all user databases
5) Run the output of two MS store procedures on destination server
6) Run the output of jobs script.
7) Re-create all dts packages
"J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
news:990A6094-3F08-4731-BF71-EAD9D0B343AF@.microsoft.com...
> Hi there, I'm hoping you can help a SQL novice......
> i need to move the SQL installs for a couple of our SQL7 servers (and
sadly
> no, they cant be upgraded).
> i've restored the DB's no problems but i'm having problems with the master
> DB and/ or its contents. i want to get all the logins, agents jobs etc
from
> the old servers to the new ones. restoring the master DB would do this,
but
> unfortunately, the drive structure on the new servers doesn match that of
the
> old and so the locations of the other SQL built in DB's (model, MSDB,
tempdb)
> is now different. if i restore the Master DB (in single user mode
obviously)
> the services fail to then re-start because they cant locate these DB's.
> so my question.... is there any way to restart SQL service post a master
> restore, without it looking for these DB's so i can then modify the file
> location properties of these DB?
> OR
> is there any way to get stuff like the security logins, SQL agent jobs etc
> from one server to another without restoring the Master DB?
> many thanks for you help and advice.|||http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
news:990A6094-3F08-4731-BF71-EAD9D0B343AF@.microsoft.com...
> Hi there, I'm hoping you can help a SQL novice......
> i need to move the SQL installs for a couple of our SQL7 servers (and
> sadly
> no, they cant be upgraded).
> i've restored the DB's no problems but i'm having problems with the master
> DB and/ or its contents. i want to get all the logins, agents jobs etc
> from
> the old servers to the new ones. restoring the master DB would do this,
> but
> unfortunately, the drive structure on the new servers doesn match that of
> the
> old and so the locations of the other SQL built in DB's (model, MSDB,
> tempdb)
> is now different. if i restore the Master DB (in single user mode
> obviously)
> the services fail to then re-start because they cant locate these DB's.
> so my question.... is there any way to restart SQL service post a master
> restore, without it looking for these DB's so i can then modify the file
> location properties of these DB?
> OR
> is there any way to get stuff like the security logins, SQL agent jobs etc
> from one server to another without restoring the Master DB?
> many thanks for you help and advice.|||thankyou Uri and Andrew, you've both given me plenty to work with.
many thanks
"Andrew J. Kelly" wrote:
> http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
> http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
> http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
> to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 Using WITH MOVE in a
> Restore
> http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
> Restore
> http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
> Restoring a .mdf
> http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
> for SQL Server
>
> --
> Andrew J. Kelly SQL MVP
>
> "J Hotch" <jonathan.hotchkiss-remove-@.tesco.net> wrote in message
> news:990A6094-3F08-4731-BF71-EAD9D0B343AF@.microsoft.com...
> > Hi there, I'm hoping you can help a SQL novice......
> >
> > i need to move the SQL installs for a couple of our SQL7 servers (and
> > sadly
> > no, they cant be upgraded).
> >
> > i've restored the DB's no problems but i'm having problems with the master
> > DB and/ or its contents. i want to get all the logins, agents jobs etc
> > from
> > the old servers to the new ones. restoring the master DB would do this,
> > but
> > unfortunately, the drive structure on the new servers doesn match that of
> > the
> > old and so the locations of the other SQL built in DB's (model, MSDB,
> > tempdb)
> > is now different. if i restore the Master DB (in single user mode
> > obviously)
> > the services fail to then re-start because they cant locate these DB's.
> >
> > so my question.... is there any way to restart SQL service post a master
> > restore, without it looking for these DB's so i can then modify the file
> > location properties of these DB?
> > OR
> > is there any way to get stuff like the security logins, SQL agent jobs etc
> > from one server to another without restoring the Master DB?
> >
> > many thanks for you help and advice.
>
>

restoring from 7 to 2000

When doing a restore from Sql 7 to Sql2000 the sysusers seems to reflect
sql7, and sa looses it rights to the database, how do you fix thisYou might be interested in these stored procedures:
sp_change_users_login
sp_changedbowner
--
Keith
"sd" <susan.dunn@.ncsl.org> wrote in message
news:%23vu0YbkLFHA.1476@.TK2MSFTNGP09.phx.gbl...
> When doing a restore from Sql 7 to Sql2000 the sysusers seems to reflect
> sql7, and sa looses it rights to the database, how do you fix this
>

Restoring DB

Hi all,

I have a very old MSSQL data backup file.
I do not even remember that it was created in SQL7 or 2000.
Anyway, I'm trying to recreate DB from this backup.
Is it possible to create DB from backup file?

I tried restore from that file and SQL server complaining.
"The file on device '***' is not valid Microsoft tape format backup set."
Thanks
-JayKev (nospam@.msu.edu) writes:
> I have a very old MSSQL data backup file.
> I do not even remember that it was created in SQL7 or 2000.
> Anyway, I'm trying to recreate DB from this backup.
> Is it possible to create DB from backup file?
> I tried restore from that file and SQL server complaining.
> "The file on device '***' is not valid Microsoft tape format backup set."

Maybe it is so old that it is from SQL 6.5? In that case, you need SQL 6.5
to read it.

If you are using SQL 2000, you should be able to restore the database,
no matter if the backup was taken on SQL7 or SQL2000.

Does the error message actually say ***, or is that something you put
in?

The actual command, and the actual error message could give a clue if
you are happening to do something wrong.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Yes, It might be 6.5.
'***' was name of my file.

Thank you.

"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns944872A36966Yazorman@.127.0.0.1...
> Kev (nospam@.msu.edu) writes:
> > I have a very old MSSQL data backup file.
> > I do not even remember that it was created in SQL7 or 2000.
> > Anyway, I'm trying to recreate DB from this backup.
> > Is it possible to create DB from backup file?
> > I tried restore from that file and SQL server complaining.
> > "The file on device '***' is not valid Microsoft tape format backup
set."
> Maybe it is so old that it is from SQL 6.5? In that case, you need SQL 6.5
> to read it.
> If you are using SQL 2000, you should be able to restore the database,
> no matter if the backup was taken on SQL7 or SQL2000.
> Does the error message actually say ***, or is that something you put
> in?
> The actual command, and the actual error message could give a clue if
> you are happening to do something wrong.
>
> --
> Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp