Restore a Database With Transaction Log

[glennfishwick]

Does anyone know if it is possible to restore a database without its Transaction Log file. Like when you can do an attach_db without specifying a transaction log and a empty one is created.

Our problem is that an unmanaged site has sent us a database with a massive transaction log that is too big to fit on our database server so we can't get at it to shrink it.

 

[tlbroadbent]

Try sp_attach_single_file_db. It can attach just the MDF file and create a new LDF. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[glennfishwick]

Unfortunately the file that I have is in backup format so that will not work.

 

[devnull69]

Try this:

Restore Database DataBaseName From File = 'FileName' With Recovery

After this the database is online and consistent again although you might have lost some data.