I seem to recall that sometimes I am able to restore a backup of a SQL 7
database to SQL 2K, and other times I am not. There are a couple of other
alternatives that I have used, both of which utilize DTS.
1. Try the Copy Database Wizard - I seem to recall using this, and it copied
over everything, including sps, users and logins.
2. Try the DTS Import or DTS Export wizard, and tell it that you want to
copy database objects.
Feel free to ask if you have any more specific questions.
Bob
-----Original Message-----
From: info [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 09, 2001 8:32 PM
To: CF-Server
Subject: SQL Server 2000
Hi All,
Has anyone faced any problems in restoring a MS SQL 7.0 database to MS SQL
2000? Any pointers would be greatly appreciated.
Regards,
Pragnesh
Systems Development Consultant
The Learning Group Pty Ltd
ABN 68 060 255 576
_______________________
This email is confidential and may contain copyrighted material. If you
are not the intended recipient, you must not disclose or use the
information contained in it. If you have received this email in error,
please tell us immediately by return email and delete the document. The
Learning Group Pty Ltd is not responsible for any changes made to a
document other than those made by The Learning Group, or for the effect of
the changes on the document's meaning.
Sydney Office
Level 3, 346 - 348 Kent Street
Sydney NSW 2000
Tel: 02 9279 3353
Fax: 02 9279 3383
Melbourne Office
Suite 418, 370 St. Kilda Road
Melbourne NSW 3004
Tel: 03 9699 8822
Fax: 02 9699 8833
Email: [EMAIL PROTECTED]
Web: www.learngroup.com.au
----------------------------------------------------------------------------
--
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
