Prev: will shrinkfile with emptyfile cause fragmentation
Next: Clustered SQL server 2005 x64 ENT- jobs keep failing after upgradeto SP3 with CU5
From: SQL Programmer on 19 Dec 2009 15:52
Hello:

In SQL 2000, how do yoou delete backup history? I need to reduce the size
of our msdb database, and my research is showing that in order to do so I
need to delete backup history.

Thanks!

SQL Programmer (it's just a name)
From: B.Edwards on 19 Dec 2009 20:56
sp_delete_backuphistory

or write custom code:

http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1704.aspx

"SQL Programmer" <SQLProgrammer(a)discussions.microsoft.com> wrote in message
news:4A5CC089-D933-4BF4-85B0-7C3F35E46C1C(a)microsoft.com...
> Hello:
>
> In SQL 2000, how do yoou delete backup history? I need to reduce the size
> of our msdb database, and my research is showing that in order to do so I
> need to delete backup history.
>
> Thanks!
>
> SQL Programmer (it's just a name)


From: Uri Dimant on 20 Dec 2009 01:55
Also read Geoff's post
http://weblogs.sqlteam.com/geoffh/archive/2008/01/21/MSDB-Performance-Tuning.aspx



"SQL Programmer" <SQLProgrammer(a)discussions.microsoft.com> wrote in message
news:4A5CC089-D933-4BF4-85B0-7C3F35E46C1C(a)microsoft.com...
> Hello:
>
> In SQL 2000, how do yoou delete backup history? I need to reduce the size
> of our msdb database, and my research is showing that in order to do so I
> need to delete backup history.
>
> Thanks!
>
> SQL Programmer (it's just a name)


 | 
Pages: 1
Prev: will shrinkfile with emptyfile cause fragmentation
Next: Clustered SQL server 2005 x64 ENT- jobs keep failing after upgradeto SP3 with CU5