A new Developer within our testing environment asked me this question to see whether they can use DETACH/ATTACH method than using ALTER database method. For the user databases it is available such method of DETACH/ATTACH method when moving the databases,
Read More...
Question> Is it possible to restore all the databses from Enterrise Edition to Standard Edition in SQL Server? Answer> Yes and No! Yes is you can restore user databases ( only ) from Standard Edition to Enterprise Edition and vice-versa for further
Read More...
You might get this doubt "How do I move the default log files placed in: C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG to a different location?" This may not be required all the times but say on the partition where these log files are stored
Read More...