Restoring to a Different Database
For development and testing purposes it's often desirable to create an exact copy of a database. This is easily done through the Restore Database dialog box. Select the backup of the database you want to restore, and in the Restore as Database window, type the name of the new database. Click OK and the new database will be created. The file structure of the database will be identical to that of the original, but the filenames will be changed to reflect the name of the database you are creating. If you are restoring to a new database on a different server, the servers must have the same character set, sort order, and Unicode collation. In addition, if the location of the database files is in a different directory ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
