 |
|
| SQL Server Tips: |
|
|
|
DATABASE DEVELOPMENT
Creating standby databases in SQL Server
Krishnan Ramakrishnan
03.13.2002
Rating: --- (out of 5)
|
It is a common practice to create a replica database for server testing -- but this can also be done for backup purposes.
Using DTS with the option to transfer all objects can be very time-consuming. Generating insert scripts would require a special utility so that the dependencies are managed. The easier way is to do the following:
- Query for the Datafiles and Logfiles. You can query the sysfiles table or use the sp_helpfile stored procedure. This will find the location of the files.
- Find out all the newly created users for this database. Script it with drop and create.
- Stop SQL Server with the service manager.
- Copy the files to the desired location. Note: If you are copying to the same data folder under the root directory of SQL Server, then the files have to be renamed.
- Start the SQL Server service.
- Using the sp_attach_db procedure, refer to the files in the location, give the appropriate database name and attach the files.
- Run the user dropping and creation script in the database.
For More Information
- What do you think about this tip? E-mail the Editor at tdichiara@techtarget.com with your feedback.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle tip to offer your fellow DBA's and developers? The best tips submitted will receive a cool prize--submit your tip today!
- Ask your technical Oracle questions--or help out your peers by answering them--in our live discussion forums.
- Check out our Ask the Experts feature: Our SQL, database design, Oracle, SQL Server, DB2, metadata, and data warehousing gurus are waiting to answer your toughest questions.
|
|
Rate this Tip
|
To rate tips, you must be a member of SearchSQLServer.com.
Register now
to start rating these tips. Log in if you are already a member.
|
DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.
|
|
|
|
|
|
|
|
|
|
| TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of . |
|
| |
All Rights Reserved, , TechTarget |
|
|
|
|
|
