|
Home > Archive > microsoft.public.sqlserver.server > December 2002 > SS7 Restore
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Elyse Pettiford 2002-12-20, 3:23 pm |
| Hello,
I have a backup file that was created using SS7 but would like to restore it
to a database using SS2K. Can this be done w/o causing data loss or other
problems?
Thanks
Elyse
| |
| Geoff N. Hiten 2002-12-20, 3:23 pm |
| Yes. It is actually a documented feature.
You will need to use sp_change_users_login to match up the users and logins
on the new system, just as with any cross-server restore. You will also
need to update statistics or you will get the goofiest query plans.
--
Geoff N. Hiten
Senior Database Administrator
Careerbuilder.com
"Elyse Pettiford" <elysepettiford@swissfone.net> wrote in message
news:ukasvdGqCHA.2204@TK2MSFTNGP09...
> Hello,
>
> I have a backup file that was created using SS7 but would like to restore
it
> to a database using SS2K. Can this be done w/o causing data loss or other
> problems?
>
> Thanks
> Elyse
>
>
| |
| Geoff N. Hiten 2002-12-20, 3:23 pm |
| Yes. It is actually a documented feature.
You will need to use sp_change_users_login to match up the users and logins
on the new system, just as with any cross-server restore. You will also
need to update statistics or you will get the goofiest query plans.
--
Geoff N. Hiten
Senior Database Administrator
Careerbuilder.com
"Elyse Pettiford" <elysepettiford@swissfone.net> wrote in message
news:ukasvdGqCHA.2204@TK2MSFTNGP09...
> Hello,
>
> I have a backup file that was created using SS7 but would like to restore
it
> to a database using SS2K. Can this be done w/o causing data loss or other
> problems?
>
> Thanks
> Elyse
>
>
| |
| John Fichera 2002-12-20, 3:23 pm |
| Elyse,
Yes this can be done. The restore process for SQL Server 2000 will
automagically update the system catalogs to SQL2K from a SQL 7 backup file.
John
"Elyse Pettiford" <elysepettiford@swissfone.net> wrote in message
news:ukasvdGqCHA.2204@TK2MSFTNGP09...
> Hello,
>
> I have a backup file that was created using SS7 but would like to restore
it
> to a database using SS2K. Can this be done w/o causing data loss or other
> problems?
>
> Thanks
> Elyse
>
>
|
|
|
|
|