Your cleanup task should not include the period in the file type. use 'BAK' not '.BAK'

turnerpe (1/12/2010)

---

[font="Times New Roman"]Many thanks for all your responses, unfortunately I don't think my question has been answered.

All the replies seem to steer me toward using T-SQL scripts. So,...

When making changes with the GUI (table changes, backup, restore, jobs ...), before you click the final "OK", you can script out the change that's about to be made. That...

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 ?