Whoops. Sorry about that.

Thanks for the reply, [Jeffrey]

I also forgot to mention RedGate SQL Backup has some really handy features for file management and aging out old backups. I'd highly recommend it.

Sorry for the delay in replying.

Re: appending

Run the following:

BACKUP DATABASE junk TO DISK = 'C:\junk.bak' WITH INIT

BACKUP TRAN junk TO DISK = 'C:\junk.bak'

Then do...

Definitely TLogs are the way to go for you. Depending on how much you trust your hardware, you might want to consider backing up to a network location, then...

Sorry - the point of my post is that the developers should see the structure of the database and 'placeholder' data but there's no reason they should see live data....

When starting at a new job, I was appalled to find that the vendor (large, name you'd recognize) of a key software package dealing with HIPAA data provided a 'masking'...

<LOL>

I didn't see the entire second page of replies.

My apologies to Jeff and the group.

I tinkered with this for a little while today and came up with something that just dealt with business [hours]. If anybody wants to goof around with it a...

I work in the healthcare industry currently (the grey in the beard = many different industries) and I've found that healthcare software is pathetic. We have a package from...

That would be really handy for replacing end-of-life hardware as well. Gather query info on the old system, replay it on the new box and see what shakes loose....

A few thoughts from a simple-minded DBA with near fatal deficiencies of caffeine at the moment.

1. Anybody that purchases an application accepts a software licensing agreement, which typically includes...

Thank heaven for this forum. Hearing things like "dBASE dot prompt" etc. makes me glad I'm not the only DBA flashing back on SQL 4.21 days...

I learned...

I shared a cube wall with a person that didn't necessarily type as much as play the keyboard like a set of bongos - I swear it sounded like they...

I've been earning a paycheck to do database stuff since 1987. I've paid my dues to get my foot in the door, kept up with the latest technology to...

I think the only hesitation for some to relocate to work in a remote opportunity is the lack of a 'Plan B' if the company folds. Finding yourself owning...