var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Noob SQL Server dba
I'm a noob SQL Server dba (though a seasoned IT guy) and I am just learnign the ins and outs of SQL Server (mostly 2005).
One thing I've come across (and I've looked through this forum)
- In a 2005 db I used the maint. plan wizard to create full backups for a SIMPLE mode database (2 actually) and I noticed the option to delete backups older than x option is not there.
Is there a reason for this?
Apurshiate yur help on this.
so the backups don't eat all of your hard drive space?
Seasoned IT Guy?
Is that with salt and pepper
IF...you run out of disk when SQL Server is active, it could corrupt stuff...and that would be bad
Make sure you have backups of master, msdb and model as well
And you should try and not use the maint plans
Ramblings of a DBA - SQL Server - Database Administration
You beat me to it .... I was just searching Tara's blog for the right link :P
Originally Posted by
Get yourself a copy of the
The Holy Book
order has no physical Brett in The meaning of a Kaiser . -database data
I will check this out.
And by "seasoned IT" I don't mean pepper and salt. I have served as a Network Engineer, SQA and TAC agent previsouly to dba...though I do love my salt...
If you don't have 'Maintenance Cleanup Task' as an available option for your maintenance plans, you may want to check your version.
Get Service Pack #3, should fix your problem
How to obtain the latest service pack for SQL Server 2005