February 15, 2005 at 7:21 am
I was wondering if I could perform restore without transaction log. Problem is the log that was backed up was 23 gig and I don't have the space when restoring to development. I have a primary data file and secondary filegroup for Indexes. So really two questions:
1. Can I restore database and shrink log prior to restore
2. Can I restore database without transaction log and recreate log once restored.
Looking for best options.
February 15, 2005 at 10:09 am
In order to get a smaller transaction log for your restore you will have to shrink the original transaction log and do another backup. During a restore transaction logs are created exactly the way they were on the original database and cannot be changed when you do the restore.
February 15, 2005 at 10:13 am
From the file you cannot restore without the transaction log or expecting the same size as when backed up. What you may need to do is restore to another server (other than production and that has enough space), truncate the transaction log, shrink it and the db, backup then restore where you want to as long as you have the room to do so. Even then you could have just restored to the other server do a sp_detach_db and copy the mdb to the dev server and do an sp_attach_single_file_db which will build a new transaction log.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply