Hi all,
I have a database backup file (backup.dat) generated by SQL server 6.0.
Now I want to restore it to a SQl server 7.0.
How can I do it.
Thx.Hi,
No, You cant restore the SQL 6.0 backup file to SQL 7 or SQL 2000. This is
due to architectural changes.
Only way to copy SQL 6.0 daa to SQL 7.0 is upgrade using Upgrade wizard
coming with SQL 7.0, this require SQL 6.0 server to be up and running
Upgrade steps:
1. You'll have to have the SQL 6.0 with the database online
2. Install SQL 7 and the latest SP
3. Once your both servers (6.0 and 7.) are both running
4. Run the upgrade wizard in SQL 7.0 (Coming along with SQL7)
5. This will upgrade sql 6.0 to sql 7.0 and keep the sql 6.0 database safe.
6. Using switch option you can move between sql 6.0 and sql 7.0
Setup the test environment first, this will also give you practice on how to
migrate.
Thanks
Hari
MCDBA
"abc" <abc@.abc.com> wrote in message
news:#6QdkrvEEHA.4080@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I have a database backup file (backup.dat) generated by SQL server 6.0.
> Now I want to restore it to a SQl server 7.0.
> How can I do it.
> Thx.
>|||Thx for your kindly answer.
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uS5Gw6vEEHA.2416@.TK2MSFTNGP12.phx.gbl...
> Hi,
> No, You cant restore the SQL 6.0 backup file to SQL 7 or SQL 2000. This is
> due to architectural changes.
> Only way to copy SQL 6.0 daa to SQL 7.0 is upgrade using Upgrade wizard
> coming with SQL 7.0, this require SQL 6.0 server to be up and running
> Upgrade steps:
> 1. You'll have to have the SQL 6.0 with the database online
> 2. Install SQL 7 and the latest SP
> 3. Once your both servers (6.0 and 7.) are both running
> 4. Run the upgrade wizard in SQL 7.0 (Coming along with SQL7)
> 5. This will upgrade sql 6.0 to sql 7.0 and keep the sql 6.0 database
safe.
> 6. Using switch option you can move between sql 6.0 and sql 7.0
> Setup the test environment first, this will also give you practice on how
to
> migrate.
> Thanks
> Hari
> MCDBA
>
>
> "abc" <abc@.abc.com> wrote in message
> news:#6QdkrvEEHA.4080@.TK2MSFTNGP09.phx.gbl...
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment