Monday, 4 December 2017

Create LDF file (.ldf) in sql server if mdf file is exists

/////////////////// sql query

Alter Database TestDB Set Emergency; Go Alter Database TestDB Rebuild Log On (Name = N'TestDB_log', FileName = N'L:\Path\To\LogFile\TestDB_log.ldf') Go Alter Database TestDB Set Online, Multi_user;
et Online, Multi_user;

No comments:

Post a Comment

How to highlight selected text in notepad++

  –> To highlight a block of code in Notepad++, please do the following steps step-1  :- Select the required text. step-2  :- Right click...