Sorry Never Mind, found the text right at the top of the page under how to obtain Cumulative update 7 for SQL 2005 SP3.....:-D

George,

WOW that is exactally what I was looking for, I have a SQL 2005 Server I had to stand up I applied Service...

Have you encountered this on 2000 systems that were not participating in a replication setup? Or was this just a former publisher?

I've done a lot of 2005 to 2008...

If you want to see what the service pack is going to touch or replace, if you do a search on the service pack on google, and go to the...

Hey Paul,

Thanks for the suggestion. Sorry i forgot to post that I had tried that one as well already. I was somewhat hopeful on...

Have you ran an integrity check on the DB?

No is the short answer.

When you create a Windows SQL Cluster there are at least 2 parts (Windows 2003, 3 for Windows 2008)

1. an OS Cluster that controls the...

Hey Guys,

If you are backing up the db nightly, and backing up log files every 15 minutes (except during your backup window), and re-indexing...

I would say it depends on the size of your database, it's structure, and if you have a maintenance window to operate in.

if the DB is a very large DB,...

I hear you, DBA by choice as well. Agreed it doesn't mean 24 hours worth of loss, I have dealt with a lot of clients lately that had been...

24 hours if you are in simple and run one backup.

you comment on Simple mode, and then you talk about bulk logged mode......

kinda like yelling at spock and punching kirk

Go to bulk logged, i'm fine with that

Go to simple it's...

What is your acceptable level of data loss? are you performing log backups? What is your restore strategy?

I would never recommend taking a production system to Simple unless...

I would set it to a % of the size of the database. But it depends on your environment.

I've got about 60 servers with over 100 DBs and little...

I know this a year late, but I found this as I was trouble shooting the same problem.

A windows 2008 server requires the local admin group(provided the person running the...