how can I move my sqlserver 2000 database to anthother machine!from SQL Server BOL:
In Microsoft® SQL Server? 2000, the data and transaction log files of a database can be detached and then reattached to another server, or even to the same server. Detaching a database removes the database from SQL Server but leaves the database intact within the data and transaction log files that compose the database. These data and transaction log files can then be used to attach the database to any instance of SQL Server, including the server from which the database was detached. This makes the database available in exactly the same state it was in when it was detached.|||This info is good to know for when I am ready to do this...
Thanks!
Zath
No comments:
Post a Comment