OK, this is somewhat off-the-cuff, so TEST before using in production!

@echo off

Set Year=%date:~-4,4%

Set Month=%date:~0,2%

{Appropriate drive letter for backup files}:

cd{appropriate path to backup files}

Forfiles /D +0 /M *.bak /C "cmd /c...

Being an "accidental DBA," I'm working on becoming a "non-accidental DBA." While my employer put in SQL about 6-7 years ago, as the back-end for a time and attendance...

Being very much a SQL Server novice, take this with a grain of salt.

From what I've read here, it seems the consensus would be to license ALL features to all...

Thanks for the idea!

I hadn't thought about setting up multiple instances (there's a reason I consider myself a newbie DBA;-) ) but that may be more "elegant" than my hack...

Thank you! I'd not looked at the History Cleanup task, so I didn't know what it might do (yes, I'm rather new to managing an SQL Server, and don't...

I currently fall into a similar situation at my employer. I learned the hard way, that I am not a "manager" or "supervisor" sort of person, I just don't...

Interesting article, it pointed out to me some areas where I need to do some work, before I can call myself a DBA...

Yes, I'm a novice at this, despite doing...

I'm lucky in that I work for a small company, who's willing to reward hard work and effort. Not necessarily with bonuses, but sometimes with out-of-band pay raises, or...

It wasn't "25" files, but ".25" (point 25) files per core.

Here's one of the places I found the recommendation, look...

Steve Jones - Editor (11/19/2009)

---

SQL Server will not spread out to these files automatically, though if they're in the same filegroup, SQL Server will use the space in a proportional...

The recommendation I saw for TempDB was 1 file per core.

Did I misread?

Thanks,

Jason...

The issue I've got is, I need to backup directly to tape for now, as the backup software that was purchased with the server went south (and the client doesn't...