Monday, March 12, 2012

Restore Problem from an unkown .BAK file

Hi,
I am trying to restore an old database may be done in SQL 6.5 into 7.0 or 20
00. I dont know what is the database name given at that time or the backup d
evice name used earlier. I just have this .BAK file through which I must res
tore 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,
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

No comments:

Post a Comment