I've thus far not used either (hey, I still a noob...) But I have run into the exact situation as far as finding answers to problems goes...

I think this...

To some extent it does depend on who asks, but I generally start with:

Server Admin / Network Admin / Database Admin / Senior Support / General Flunky / Slave...

Sort of...

Thanks!

The Logical Name field in question, is in:

Database properties->Files

See the attached JPG, the section in question is in the red box.

I'm going to presume from where I found this, it...

If I win, can I bring my wife, and a curtain?

:ermm:

I may only be an "accidental" DBA, but I'm entering, if only for the chance to go for the ride...

To...

opc.three (10/7/2011)

---

jasona.work (10/7/2011)

---

I have setup something that uses xp_cmdshell, although now that I've improved my knowledge and skills with SQL I can see other ways to do this without xp_cmdshell....

I have setup something that uses xp_cmdshell, although now that I've improved my knowledge and skills with SQL I can see other ways to do this without xp_cmdshell. I...

Never mind, I figured out I could (and how) wrap the restore in a Try / Catch block. Now I just need to set about getting it to loop.

Thanks!

Jason...

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