SQL Server, Restore a .BKP file into an MDF file but not LDF (no space for it) -


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