I do not have enough space to have a situation where a Littepeed up to me to adjust my MDF and LDF files I did
I have come here with the following sproc.
Executive master.dbo.xp_restore_database @database = 'OSiteDB', @filename = 'L: \ OSiteDB_2009_01_07_Wed_LiteSpeed_Full.BKP', = @with 'trick' O1_SITEDB "" S: \ OSiteDB_Data. Mdf "', @with =' move 'o1_SITEDB_Log" to "some god idle space ??"
Is there any way that I can specify the LDF location at some null location? I do not want LDF, Alternatively, is there any way I can not bring LDF at all?
You need to LDF and restore the MDF is an integral part of the log database: it Understanding RDBMS is not a "database".
As an emergency, you must reinstall the plug in an external drive or NTFS compressed folder. After that, however, you can shorten the database files, it is only a quick fix and so you're going to have to do it properly.
Comments
Post a Comment