Hi
I am trying to restore an old database may be done in SQL 6.5 into 7.0 or 2000. I dont know what is the database name given at that time or the backup device name used earlier. I just have this .BAK file through which I must restore the database. Is there anyway in which I can restore the database
If anybody can help I would greatful
Thanks
Srinivas RaoYou cannot restore 6.5 backups into SQL Server 7.0 or 2000. You should first
restore this into 6.5 and then use BCP or DTS to move the data from 6.5 to
7.0/2000.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Srinivas Rao" <asraogoud@.yahoo.com> wrote in message
news:E9BE3713-3E91-4419-8167-EC2F244E0CF8@.microsoft.com...
Hi,
I am trying to restore an old database may be done in SQL 6.5 into 7.0 or
2000. I dont know what is the database name given at that time or the backup
device name used earlier. I just have this .BAK file through which I must
restore the database. Is there anyway in which I can restore the database?
If anybody can help I would greatful.
Thanks.
Srinivas Rao|||Hi Srinivas,
You cannot restore the database backups /files of SQL
Server 6.5 to SQL Server 7.0/2000. I would suggest you to
install SQL Server 6.5 ( if you dont have it)on a test
server, restore the .BAK file, then upgrade 6.5 to SQL
Server 7.0/2000 , take a backup and restore on the real
server.
Also You cannot restore a SQL Server 2000 database backup
to a SQL Server 7.0 server.
The following KB's are for ur reference.
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://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.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
Regards
Thirumal Reddy M.
System Administrator
www.sstil.com
>--Original Message--
>Hi,
>I am trying to restore an old database may be done in SQL
6.5 into 7.0 or 2000. I dont know what is the database
name given at that time or the backup device name used
earlier. I just have this .BAK file through which I must
restore the database. Is there anyway in which I can
restore the database?
>If anybody can help I would greatful.
>
>Thanks.
>Srinivas Rao
>.
>|||Hi,
SQL 6.5 backup file can not be restored to SQL 7 or SQL 2000. You have to
use Upgrade wizard to upgrade the database from SQL 6.5 to SQL 7/2000. For
that you should have SQL 6.5 database up.
If it is SQL 7/2000 then use the below statement in query analyzer to get
file info,
Restore filelistonly from disk='driveletter\folder\dbname.bak'
After that you can use any database name to restore the backup file. Execute
the below statement to restore the database.
Restore database dbname from disk='driveletter\folder\dbname.bak' with
stas=10 ,
move 'logical_datafilename' to 'physical_dataname',
move 'logical_logfilename' to 'physical_logname'
Thanks
Hari
MCDBA
"Srinivas Rao" <asraogoud@.yahoo.com> wrote in message
news:E9BE3713-3E91-4419-8167-EC2F244E0CF8@.microsoft.com...
> Hi,
> I am trying to restore an old database may be done in SQL 6.5 into 7.0 or
2000. I dont know what is the database name given at that time or the backup
device name used earlier. I just have this .BAK file through which I must
restore the database. Is there anyway in which I can restore the database?
> If anybody can help I would greatful.
>
> Thanks.
> Srinivas Rao
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment