MS SQL Server - Restoring SQL Server 6.5 .DAT file to SQL 2000

Author

Restoring SQL Server 6.5 .DAT file to SQL 2000

Amit

2005-10-12, 11:23 am

All,

My client has give me a 6.5 backup file in a .DAT format.
I want to restore it in SQL2000.

Rick Sawtell

2005-10-12, 11:23 am

"Amit" <Amit@discussions.microsoft.com> wrote in message
news:E15A0D61-F208-4FC8-B7A4- 53A7461B24EA@microso
ft.com...
> All,
>
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>

You cannot restore it to SQL 2k.

You can only restore it (painfully) to a 6.5 system and then perform
upgrades on it.

Rick Sawtell
MCT, MCSD, MCDBA

Geoff N. Hiten

2005-10-12, 11:23 am

No can do. You will have to build a SQL 6.5 server, restore the file, then
convert to 7.0/2000. Without the sysdevices, sysdatabases, and sysusages
information, you cannot restore a SQL 6.5 database. Unlike SQL 7.0 and
higher, SQL 6.5 database backups are not self-describing.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Amit" <Amit@discussions.microsoft.com> wrote in message
news:E15A0D61-F208-4FC8-B7A4- 53A7461B24EA@microso
ft.com...
> All,
>
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>

Hari Prasad

2005-10-12, 11:23 am

Hi,

SQL 6.5 and SQL 2000 architecture is different and since the backup restore
is not allowed. So only possibility is:-

1. Restore the 6.5 backup DAT file into SQL 6.5 machine
2. INstall SQL 2000 and service pack
3. Use Upgrade wizard rto upgrade the SQL 6.5 database to SQL 2000
4. Upgrade wizard will copy all the data / objects to SQL 2000.

Note:-

Execute a DBCC and update statistics before the upgrade

Thanks
Hari
SQL Server MVP

"Amit" <Amit@discussions.microsoft.com> wrote in message
news:E15A0D61-F208-4FC8-B7A4- 53A7461B24EA@microso
ft.com...
> All,
>
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>

Tibor Karaszi

2005-10-12, 11:23 am

In addition to the other posts:

You *might* be able to restore your 6.5 backup on another 6.5 machine even if you don't know the
database fragments (master..sysusages etc). But you will end up with data pages where SQL Server
expects log pages and vice versa. For data pages where SQL Server expects log pages, DBCC NEWALLOG
will return 2558 errors (I believe) and you have to physically move the data. Possibly create script
and transfer all over to a new database. Possibly by rebuilding all indexes. Not to be taken lightly
if you don't have good 6.5 expertise.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

"Amit" <Amit@discussions.microsoft.com> wrote in message
news:E15A0D61-F208-4FC8-B7A4- 53A7461B24EA@microso
ft.com...
> All,
>
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>

Amit

2005-10-17, 1:23 pm

Thanks every one for taking time to reply :-)

Regards
Amit

"Amit" wrote:

> All,
>
> My client has give me a 6.5 backup file in a .DAT format.
> I want to restore it in SQL2000.
>

Sponsored Links