Hi,

Is it possible that you have the SQLAgent down which wont allow you to view jobs in SSMS ?

In such a case you will be able to create Maintenance Plan...

Thanks Cath !!

will keep the tip in mind 🙂

Hi,

hey will removing the "@updateusage = N'TRUE'" make difference ?

I tried without it and the results were same ...

Hi,

You can query sp_helpdb databasename for each DB on your SQL instance. This will list out the filenames (Primary, secondary) and the log file associated with the DB.

PS.- Its difficult...

Came across a white paper available about working with PBM in SQL 2008

http://msdn.microsoft.com/en-us/library/dd938891(v=sql.100).aspx

looks interesting ...

Thanks,

Ninad

Hi,

In 2008 you can register the server names on one SSMS instance and form a server group. Once the server group is formed right click and then you can write...

Hi,

I hope you find this useful ..

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31929/

Regards.

My bad ...

didn't check the "Backup set expiry" setting before posting the question. This was set to "1 day", so naturally at 12:00AM the last backup becomes invalid ...

to...