no log backups?

if it adds to a thread and completes it by providing a solution I cannot see a problem, might help someone in trouble in the future who comes across the...

found out about undocumented store procedure sp_objectfilegroup as well. Though perhaps that's a bad thing 🙂

I had never heard black friday referred to before now, but ever since this question its been popping up everywhere as british retailers jump on this american tradition to try...

you are missing a transaction log backup. If you can find it restore it manually then carry on, else you will need to start again from a full backup, or...

if the database is being set to read only there would be no need for another backup, nothing will change.

if you want to save time:

full backup to file

restore to new...

you should start your own thread please for future queries.

you have the same problem as shenkar, a transaction log backup is missing. If you cannot find it and apply it...

see http://support.microsoft.com/kb/958734

you have given the game away tom!

learnt something about american culture anyway

no problem

I got this right this because I knew it was impossible to shrink to less than 2 VLFs.

As the URL referred to in Hanys post hints at, if creating a...

Are you trying to recreate the logshipping jobs without removing the logshipping setup first? If so that explains your error, dropping the destination database is not enough.

You do not need...

presuming they are held in msdb, copy them off to the file system. this script will do that for all DTS packages if there are a lot, else it can...

The only way I have found to enable a group of people to manage each others jobs without sysadmin is basically as the URL Lowell refers to describes.

A SQL account...

if the history of the job shows it is succeeding it probably means there are no logs for it to restore, which suggests a missing log file.

run these queries to...