Wednesday, March 21, 2012

Restore SQL 7 Database to SQL 2000 (urgent)

I have a 225Gb SQL 7 database on an NT 4 server that I need to restore to a
Win2k Server running SQL 2000. Is it possible to restore a SQL 7 database
onto a SQL 2000 server?
Gav
Hi,
You can backup the SQL 7 database and restore it in SQL 2000. Do a update
statistics after the restore to get the effective performance.
Thanks
Hari
MCDBA
"Gavin Metcalfe" <gavin.metcalfe@.btinternet.com> wrote in message
news:c6t40b$s74$1@.titan.btinternet.com...
> I have a 225Gb SQL 7 database on an NT 4 server that I need to restore to
a
> Win2k Server running SQL 2000. Is it possible to restore a SQL 7 database
> onto a SQL 2000 server?
> Gav
>
|||thanks for that. :o)
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:OF$DsLpLEHA.2500@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Hi,
> You can backup the SQL 7 database and restore it in SQL 2000. Do a update
> statistics after the restore to get the effective performance.
> Thanks
> Hari
> MCDBA
> "Gavin Metcalfe" <gavin.metcalfe@.btinternet.com> wrote in message
> news:c6t40b$s74$1@.titan.btinternet.com...
to[vbcol=seagreen]
> a
database
>

No comments:

Post a Comment