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

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...