I'd thought of doing something like that, but the biggest problem with it, is the possibility of data loss.

The application in question is an Electronic Health / Medical Records app,...

Thanks, that answered my question and took a load off my mind!

:w00t:

As for dictating to the clients where to back up to, we don't tell them where or how to...

Well, I did try loading the stand alone SQL Agent on my work PC, to give it a testing. Problem is, the install failed (Win7 x64 Pro)

I did a...

A comment, and a question:

Being a SQL newbie, I've (so far) made surprisingly few of these mistakes. I almost ran into the too many commas, because of copy-and-pasting some...

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...