1) Stop shrinking the database ... it's causes fragmentation & poor performance including when the database grows back to the size it needs to be.

2) Take frequent log backups,...

I usually run transaction log backups in between index rebuilds.

Read: Why is my transaction...

What service pack are you on ? There were maintenance plan bugs that were fixed in SP3

keepintouch2b (4/11/2011)

---

For SQL Server 2005, use restore to another instance will not work b/c of the LSN error mention on my prior replied post.

For SQL Server 2008 or Denali, I...

Sounds as though you want to use the restore function to manipulate data ... that's the opposite of it's purpose. A restore is designed to bring a database back to...

Step 7 sounds like you want to apply an old transaction log backup to a newer database. That won't work, or am I misunderstanding ?

Probably some other process has a lock on the index. Are you running the maint plan during off-hours ?

Basically, the transaction log contains the database activity that has occured since the previous backup (full, diff or tran log)

Proper explanations & details here:

http://www.sqlservercentral.com/search/?q=gilamonster&t=a

I think the total size of you t-log backups should be about the same. One huge daily backup, or many small 20 minute backups.

And if only have SQL Express, you can use shareware SQLScheduler to create jobs.

Our production transaction logs are backed up every 15-20 minutes.

The frequency is determined by your businesses allowable data loss.

Transaction backups once per day means you have the potential to lose...

Why do you use 2 different accounts on the forum ? I see others do it once in a while .... seems confusing all around.

If it is a production database I would suggest something like:

1) Set to FULL recovery model

2) Take one-time full backup now to re-establish log chain

3) Take full backup daily

4) Schedule...

I assume you checked the obvious that your variable for the database name is long enough ?

The truncated name is 50 characters long.

Are you using proper 4 part name ?

select * from Server1.Database.dbo.table