Hey! I too am looking into using SCCM to deploy Service Pack 2 and Cumulative update #4 for SQL Server 2008 R2. Normally I just batch script...

merodach;

Kudos to you, you grand-super-DBA you. Wish I had some imaginary internet points to give you right now. Why? Well, for not only posting the details of...

I love this script. I've wrote a set of RevGen Security scripts a few months ago and have been using them to "save" security of dev/test databases pre-refresh. ...

Excellent script, Rudy. Thanks a mint for sharing it.

While I'm not aware of a RMAN-like option in SQL Server, we have used Archserve's SQL Server agent to backup directly to disk in the past.  Though I stopped doing...

Thanks Michelle!  I too have a weekly job that rebuilds all indexes in that database after switching the database to BULK_LOGGED first, then back to FULL after the job was finished.  That would...

The total size of the transaction log, free space and used, is 3.3 gigabytes.  The total size of the transaction log backup onto disk was 7.83 gigabytes.

Thanks; T. Johnson

Transaction log backups write a new file, unique, file for each time the backup job is run.  This is to make the restore to a distinct point in time, that...

Thanks for the replies everyone. I ended up resolving the problem myself, but I thought that I'd post the details here incase someone else ran across this.

PROBLEM:

ArchServ kicked off...

Excellent, I wasn't aware of that one. Thanks for the tip, Allen. That is one handy command.

Finally heard back from the vendor and found out that they had restored the copy of our database to a SQL Server 2000 instance and applied their upgrades. The...

The main problem would be memory usage. Terminal Server user sessions can use a good bit of memory depending upon what applications are being run. I personally have...

quote:

---

Yes indeed Trea, as crazy as it sounds it is illegal to pump your own gas in the state of Oregon. I...

quote:

---

Another irritant is gas station attendents. It use to be in the old days that they would come to your window, greet...

quote:

---

Anyway my main peeve at the moment is the total lack of junior dba positions, do companies expect good experienced dba's to...