How do you restore a database only in a database?

zhaozj2021-02-16  79

1. Build a database 2, modify the server settings: allow multiple system directories to change 3, stop SQL Server4, cover the database file 5 of the newly established library with the original MDF file, restart SQL Server (this time the database should be quenched) 6 , Set the database as an emergency: update master.dbo.sysdatabases set status = 32768 Where name = dbname7, rebuilding log: DBCC Rebulid_log ('dbname', 'logfile')

(Source: http://community.9cbs.net/expert/topic/3159/3159962.xml? Temp = .691662)

转载请注明原文地址:https://www.9cbs.com/read-15487.html

New Post(0)