数据库的恢复数据语句

最新推荐文章于 2023-06-01 18:00:46 发布

weixin_30764771

最新推荐文章于 2023-06-01 18:00:46 发布

阅读量200

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/w1-y2-q5/p/4885605.html

版权

-- sql server 2008 USE MASTER GO SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE GO ALTER DATABASE MixiguoBizDB SET EMERGENCY GO sp_dboption 'MixiguoBizDB', 'single user', 'true' GO DBCC CHECKDB('MixiguoBizDB','REPAIR_ALLOW_DATA_LOSS') GO ALTER DATABASE MixiguoBizDB SET ONLINE GO sp_configure 'allow updates', 0 reconfigure with override GO sp_dboption 'MixiguoBizDB', 'single user', 'false' GO

-- sql server 2012 USE MASTER GO SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE GO ALTER DATABASE Tfs_DefaultCollection SET EMERGENCY GO alter database Tfs_DefaultCollection set SINGLE_USER with ROLLBACK IMMEDIATE --sp_dboption 'Tfs_DefaultCollection', 'single user', 'true' GO DBCC CHECKDB('Tfs_DefaultCollection','REPAIR_ALLOW_DATA_LOSS') GO ALTER DATABASE Tfs_DefaultCollection SET ONLINE GO sp_configure 'allow updates', 0 reconfigure with override GO --sp_dboption 'Tfs_DefaultCollection', 'single user', 'false' alter database Tfs_DefaultCollection set MULTI_USER with ROLLBACK IMMEDIATE GO

转载于:https://www.cnblogs.com/w1-y2-q5/p/4885605.html