ALTER DATABASE YourDB SET EMERGENCY; ALTER DATABASE YourDB SET SINGLE_USER; ALTER DATABASE YourDB REBUILD LOG ON (NAME=YourDB_log, FILENAME='E:\Logs\YourDB_log.ldf'); ALTER DATABASE YourDB SET MULTI_USER; If you have a recent full backup + log backups:
ALTER DATABASE YourDB SET EMERGENCY; ALTER DATABASE YourDB SET SINGLE_USER; DBCC CHECKDB (YourDB, REPAIR_ALLOW_DATA_LOSS); ALTER DATABASE YourDB SET MULTI_USER; ⚠️ REPAIR_ALLOW_DATA_LOSS may delete some data. Use only as last resort. If data file is intact but log is gone/corrupt: database in recovery pending
ALTER DATABASE YourDB SET EMERGENCY; ALTER DATABASE YourDB SET SINGLE_USER; DBCC CHECKDB (YourDB, REPAIR_ALLOW_DATA_LOSS); -- SQL Server will rebuild a new log automatically ALTER DATABASE YourDB SET MULTI_USER; Alternative for clean log rebuild (no data loss attempt): ALTER DATABASE YourDB SET EMERGENCY; ALTER DATABASE YourDB
Copyright © 2013 LGDM. All Rights Reserved. All other trademarks and copyrights are the property of their respective holders. The reviews and comments expressed at or through this website are the opinions of the individual author and do not reflect the opinions or views of LGDM. LGDM is not responsible for the accuracy of any of the information supplied here.
