[thelist] restoring a sql db from bak file

[Keith Shaffer]

If I try to do an import it chokes saying it cannot find the selected row
delimeter.  If I try to restore it through a query I get:"Cannot open backup
device 'c:\ipartner_db_200205150203.BAK'. Device error or device off-line."

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Joshua Olson
Sent: Tuesday, May 21, 2002 11:11 AM
To: thelist at lists.evolt.org
Subject: Re: [thelist] restoring a sql db from bak file


----- Original Message -----
From: "Keith Shaffer" <keith at geonetric.com>
Sent: Tuesday, May 21, 2002 10:45 AM
Subject: [thelist] restoring a sql db from bak file


> Can anyone assist in the best way to take a .bak file created in SQL 7.0
and
> I need to get it into SQL 2000.  It is a file from a different server so
it
> is not in any backup device/tape.

What happens when you try an import with MSSQL 2k?

-joshua


--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !