TechTalkz.com Logo Ask the Experts!

Go Back   TechTalkz.com Technology & Computer Troubleshooting Forums > Tech Support Archives > Microsoft > Microsoft SQL Server

How to use the .dat file to restore a database on the SQL 6.5?

Microsoft SQL Server

 
 
Thread Tools Display Modes
Unread 05-12-2007, 11:34 AM   #1
Jason Huang
Guest
 
Posts: n/a
How to use the .dat file to restore a database on the SQL 6.5?

Hi,

In the SQL Server 6.5, how do we restore a database through a .dat file?
Is it possible for the SQL 7.0 to use the SQL 6.5's .dat files?
Thanks for help.


Jason


 
Unread 05-12-2007, 12:50 PM   #2
John Bell
Guest
 
Posts: n/a
RE: How to use the .dat file to restore a database on the SQL 6.5?

Hi

SQL 7.0 has a different architecture to SQL 6.5 therefore it will not be
possible to use the devices.

John

"Jason Huang" wrote:

> Hi,
>
> In the SQL Server 6.5, how do we restore a database through a .dat file?
> Is it possible for the SQL 7.0 to use the SQL 6.5's .dat files?
> Thanks for help.
>
>
> Jason
>
>
>

 
Unread 05-12-2007, 08:11 PM   #3
Mohit K. Gupta
Guest
 
Posts: n/a
RE: How to use the .dat file to restore a database on the SQL 6.5?

To add to Johns ...

You can't get 6.5 restored to 7.0 .. but I installed a 6.5 server on virtula
windows xp computer and restored my database on 6.5 and then installed SQL
2000 and used SQL 2000 upgrade advisor and upgraded the database and was able
to do restore to newer version of SQL.

So maybe try the same trick with 7.0 Thanks!

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005


"Jason Huang" wrote:

> Hi,
>
> In the SQL Server 6.5, how do we restore a database through a .dat file?
> Is it possible for the SQL 7.0 to use the SQL 6.5's .dat files?
> Thanks for help.
>
>
> Jason
>
>
>

 
Unread 05-12-2007, 10:36 PM   #4
Mohit K. Gupta
Guest
 
Posts: n/a
RE: How to use the .dat file to restore a database on the SQL 6.5?

To add to Johns ...

You can't get 6.5 restored to 7.0 .. but I installed a 6.5 server on virtula
windows xp computer and restored my database on 6.5 and then installed SQL
2000 and used SQL 2000 upgrade advisor and upgraded the database and was able
to do restore to newer version of SQL.

So maybe try the same trick with 7.0 Thanks!

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005


"Jason Huang" wrote:

> Hi,
>
> In the SQL Server 6.5, how do we restore a database through a .dat file?
> Is it possible for the SQL 7.0 to use the SQL 6.5's .dat files?
> Thanks for help.
>
>
> Jason
>
>
>

 
Unread 07-12-2007, 11:01 PM   #5
John Bell
Guest
 
Posts: n/a
RE: How to use the .dat file to restore a database on the SQL 6.5?

Hi

This sounds like when you installed SQL 2000 you elected to do an in-place
migration of the existing instanceon the VM. This is a very good method to
use.

It's a good idea to practice the upgrade before the actual migration, in
which case make sure that you have a copy of the virtual machine with SQL 6.5
installed so you can easily revert back to that version before doing a live
upgrade or additional practive runs.

Having the upgraded version on a VM gives you the means to test your
applications and processes thoroughly before migrating the live data.

John


"Mohit K. Gupta" wrote:

> To add to Johns ...
>
> You can't get 6.5 restored to 7.0 .. but I installed a 6.5 server on virtula
> windows xp computer and restored my database on 6.5 and then installed SQL
> 2000 and used SQL 2000 upgrade advisor and upgraded the database and was able
> to do restore to newer version of SQL.
>
> So maybe try the same trick with 7.0 Thanks!
>
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
>
> "Jason Huang" wrote:
>
> > Hi,
> >
> > In the SQL Server 6.5, how do we restore a database through a .dat file?
> > Is it possible for the SQL 7.0 to use the SQL 6.5's .dat files?
> > Thanks for help.
> >
> >
> > Jason
> >
> >
> >

 
Unread 08-12-2007, 12:18 AM   #6
John Bell
Guest
 
Posts: n/a
RE: How to use the .dat file to restore a database on the SQL 6.5?

Hi

This sounds like when you installed SQL 2000 you elected to do an in-place
migration of the existing instanceon the VM. This is a very good method to
use.

It's a good idea to practice the upgrade before the actual migration, in
which case make sure that you have a copy of the virtual machine with SQL 6.5
installed so you can easily revert back to that version before doing a live
upgrade or additional practive runs.

Having the upgraded version on a VM gives you the means to test your
applications and processes thoroughly before migrating the live data.

John


"Mohit K. Gupta" wrote:

> To add to Johns ...
>
> You can't get 6.5 restored to 7.0 .. but I installed a 6.5 server on virtula
> windows xp computer and restored my database on 6.5 and then installed SQL
> 2000 and used SQL 2000 upgrade advisor and upgraded the database and was able
> to do restore to newer version of SQL.
>
> So maybe try the same trick with 7.0 Thanks!
>
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
>
> "Jason Huang" wrote:
>
> > Hi,
> >
> > In the SQL Server 6.5, how do we restore a database through a .dat file?
> > Is it possible for the SQL 7.0 to use the SQL 6.5's .dat files?
> > Thanks for help.
> >
> >
> > Jason
> >
> >
> >

 
Unread 08-12-2007, 12:22 AM   #7
John Bell
Guest
 
Posts: n/a
RE: How to use the .dat file to restore a database on the SQL 6.5?

Hi

This sounds like when you installed SQL 2000 you elected to do an in-place
migration of the existing instanceon the VM. This is a very good method to
use.

It's a good idea to practice the upgrade before the actual migration, in
which case make sure that you have a copy of the virtual machine with SQL 6.5
installed so you can easily revert back to that version before doing a live
upgrade or additional practive runs.

Having the upgraded version on a VM gives you the means to test your
applications and processes thoroughly before migrating the live data.

John


"Mohit K. Gupta" wrote:

> To add to Johns ...
>
> You can't get 6.5 restored to 7.0 .. but I installed a 6.5 server on virtula
> windows xp computer and restored my database on 6.5 and then installed SQL
> 2000 and used SQL 2000 upgrade advisor and upgraded the database and was able
> to do restore to newer version of SQL.
>
> So maybe try the same trick with 7.0 Thanks!
>
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
>
> "Jason Huang" wrote:
>
> > Hi,
> >
> > In the SQL Server 6.5, how do we restore a database through a .dat file?
> > Is it possible for the SQL 7.0 to use the SQL 6.5's .dat files?
> > Thanks for help.
> >
> >
> > Jason
> >
> >
> >

 
Unread 08-12-2007, 12:36 AM   #8
John Bell
Guest
 
Posts: n/a
RE: How to use the .dat file to restore a database on the SQL 6.5?

Hi

This sounds like when you installed SQL 2000 you elected to do an in-place
migration of the existing instanceon the VM. This is a very good method to
use.

It's a good idea to practice the upgrade before the actual migration, in
which case make sure that you have a copy of the virtual machine with SQL 6.5
installed so you can easily revert back to that version before doing a live
upgrade or additional practive runs.

Having the upgraded version on a VM gives you the means to test your
applications and processes thoroughly before migrating the live data.

John


"Mohit K. Gupta" wrote:

> To add to Johns ...
>
> You can't get 6.5 restored to 7.0 .. but I installed a 6.5 server on virtula
> windows xp computer and restored my database on 6.5 and then installed SQL
> 2000 and used SQL 2000 upgrade advisor and upgraded the database and was able
> to do restore to newer version of SQL.
>
> So maybe try the same trick with 7.0 Thanks!
>
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
>
> "Jason Huang" wrote:
>
> > Hi,
> >
> > In the SQL Server 6.5, how do we restore a database through a .dat file?
> > Is it possible for the SQL 7.0 to use the SQL 6.5's .dat files?
> > Thanks for help.
> >
> >
> > Jason
> >
> >
> >

 
Unread 08-12-2007, 12:44 AM   #9
John Bell
Guest
 
Posts: n/a
RE: How to use the .dat file to restore a database on the SQL 6.5?

Hi

This sounds like when you installed SQL 2000 you elected to do an in-place
migration of the existing instanceon the VM. This is a very good method to
use.

It's a good idea to practice the upgrade before the actual migration, in
which case make sure that you have a copy of the virtual machine with SQL 6.5
installed so you can easily revert back to that version before doing a live
upgrade or additional practive runs.

Having the upgraded version on a VM gives you the means to test your
applications and processes thoroughly before migrating the live data.

John


"Mohit K. Gupta" wrote:

> To add to Johns ...
>
> You can't get 6.5 restored to 7.0 .. but I installed a 6.5 server on virtula
> windows xp computer and restored my database on 6.5 and then installed SQL
> 2000 and used SQL 2000 upgrade advisor and upgraded the database and was able
> to do restore to newer version of SQL.
>
> So maybe try the same trick with 7.0 Thanks!
>
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
>
> "Jason Huang" wrote:
>
> > Hi,
> >
> > In the SQL Server 6.5, how do we restore a database through a .dat file?
> > Is it possible for the SQL 7.0 to use the SQL 6.5's .dat files?
> > Thanks for help.
> >
> >
> > Jason
> >
> >
> >

 
Unread 08-12-2007, 12:45 AM   #10
John Bell
Guest
 
Posts: n/a
RE: How to use the .dat file to restore a database on the SQL 6.5?

Hi

This sounds like when you installed SQL 2000 you elected to do an in-place
migration of the existing instanceon the VM. This is a very good method to
use.

It's a good idea to practice the upgrade before the actual migration, in
which case make sure that you have a copy of the virtual machine with SQL 6.5
installed so you can easily revert back to that version before doing a live
upgrade or additional practive runs.

Having the upgraded version on a VM gives you the means to test your
applications and processes thoroughly before migrating the live data.

John


"Mohit K. Gupta" wrote:

> To add to Johns ...
>
> You can't get 6.5 restored to 7.0 .. but I installed a 6.5 server on virtula
> windows xp computer and restored my database on 6.5 and then installed SQL
> 2000 and used SQL 2000 upgrade advisor and upgraded the database and was able
> to do restore to newer version of SQL.
>
> So maybe try the same trick with 7.0 Thanks!
>
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
>
> "Jason Huang" wrote:
>
> > Hi,
> >
> > In the SQL Server 6.5, how do we restore a database through a .dat file?
> > Is it possible for the SQL 7.0 to use the SQL 6.5's .dat files?
> > Thanks for help.
> >
> >
> > Jason
> >
> >
> >

 
 

Thread Tools
Display Modes



< Home - Windows Help - MS Office Help - Hardware Support >


New To Site? Need Help?

All times are GMT. The time now is 10:27 PM.


vBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO
Copyright © 2005-2013, TechTalkz.com. All Rights Reserved - Privacy Policy
Valid XHTML 1.0 Transitional