According to this thread, you have a corrupted backup

http://social.msdn.microsoft.com/forums/en-US/sqldisasterrecovery/thread/f31fb497-ebb6-4c84-a824-0966390ad5c6/

Welcome to the club. I've been a member for a while ! 😀

I think that if you disable the jobs so that they don't run during the file move, you should be ok. I haven't used replication in a while, so maybe...

laddu4700 (1/11/2010)

---

If shrinking datbase/logfile causes index fragmentation and poor performance. Then why that option is there in SQL Sever.

If you don't shrink logfile, lets say logfile grows rapidly and...

You may need to contact your Network Admin.

Search on Shrink Database and you will get lots of information about why NOT to shrink your database.

If it's a production environment, I would think that the data is increasing regularly, thus making your backup size increase. Normal & expected.

Shrinking the data file will not help your...

I created a new Maint Plan when I tried it just now. Perhaps there's a quirk in your existing plan if it was created on an earlier SP ? ...

I think the suggested method is:

Log on to the server

Configuration Tools

Go to SQL Configuration Manager

Go to SQL 2005 Service

Choose the Service -> Properties and change the account

Then you will need...

If there are large databases, you might want to do a FULL backup at night, then a Differential every 3 hours and transaction log backups more frequently, such as...

And how will you know which one you are accessing ? Magic ?

You have a...

No, Mine were still checked. Are you up to date with service packs ?

Shrink file has an effect of causing fragmentation, and is not recommended except special situations.

From Books Online

"A shrink operation does not preserve the fragmentation state of indexes in the database,...

At a minimum, the DBA can ensure that code is clearly written, with appropriate comments & descriptions and follows company standards. And when revisions are made, a revision # is...

The link doesn't work because of a trailing blank. But paste the address, and it takes you to lots of information.

Edit: I retract my statement 🙂