I have SQL Server 7.0 and I am going to update to SQL Server 2000, Can I import the database? Can I make a backup from SQL Server 7.0 and then to restore with SQL Server 2000. (I have tape backup).
Thanks and Best Regards,
hi jose,
yes, you can restored backup file of SQL 7 database to SQL Server 2000. SQL 2000 will upgrade
the SQL 7 database during the restore process. Once restore process is over run update
statistics on all tables, ideally WITH FULLSCAN.
Vishal Parkar
vgparkar@.yahoo.co.in
|||Please refer to these links that will provide you all the information that
you would possibly need to perform the upgrade:
How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000
http://www.microsoft.com/technet/pro...y/sqlugrd.mspx
Upgrading from SQL 7 to SQL 2000
http://msdn.microsoft.com/library/de...us/instsql/in_
upgrade_5jw3.asp
This link will give you all about SQL installation
http://msdn.microsoft.com/library/de...us/howtosql/ht
_install_5vsj.asp
FAQs to know before you plan the upgrade
http://support.microsoft.com/default...b;en-us;261334
Hope this helps.
Sanchan [MSFT]
sanchans@.online.microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment