GSquared (8/30/2011)

GilaMonster (8/30/2011)

Just about...

Games still come with manuals?? Since when? 😉

Seriously, the last game I...

My understanding has always been that RAID-1 can be set up using two or more disks, all mirrored. I think generally most people look at other RAID levels when...

Brandie,

Your comment got me thinking, and caused me to (further) modify the backup batch file I'm creating. It now uses SQLCMD to backup the DB or Transaction log (2...

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