For me, the default trace does not have enough information. I set up a server side trace that runs 24/7, and I keep the trace files for about 45 days....

I am very tempted to just quote someone else's query with OVER 😀

Were you sure to run DBCC OPENTRAN in the affected database ? I ask because in another thread I...

How about some code before the view that uses SYNONYM for the variable tables, then select from the view using the synonym name.

Don't use a backupset. Just backup to a new file each time.

Do a search for an articles on database backups

What is the backup command you tried to use ?

What is the backup command you are using ?

clucasi (10/11/2013)

---

The main reason for backing up sequentially is because we are taking a further backup on a tape drive (TSM), if the backups are date based it backs each...

Are you appending backups to existing backup sets ? I much prefer to backup databases to separate .BAK files each time. Much easier to keep track of what you...

I think I tried the GUI version of that already. When I try now I get the error

Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91

An error occurred during...

Did you restore with "NORECOVERY" ?

That would show it "restoring" as it leaves it in a condition for you to restore additional Differentials or transaction logs.

If you do not have...

I don't understand what the current problem is. Did your restore scripts work ?

Are the maint plan & jobs related somehow, or a separate problem ?

" ... I'm not sure how to generate a script? ... "

Open the GUI, get everything set the way you want. Instead of clicking "OK", select "Script" at the...

Have you tried using the GUI to set up the restore, then generate the script to a query window ?

1 level of improvement is to display the job list in the "Object Explorer" pane, highlight all the jobs at once, then "Create to File" and put them all in...