Updating SQL Server 2008

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

I may just do 2 cumulative updates instead of jumping to SP1. Should I still run DB check?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

That is good to know as were are back and forth on whether to go with the SP or the CU, but sounds like the SP is better idea. We are new to this as we never have to touch the SQL server for anything it almost never has issues so any advise will help. I will try to figure out to run the full backups aside from my regular backups.

ASKER

Can I run full backups during regular hours or does everyone need to be out of the DB?

ASKER

Can you roll back the SQL SP if needed?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

If I run the backup with the options you mentioned above do I need to run a database check prior? Or does it do it while backing up?

ASKER

Also after I have run all the backups, I just run the exe from download, I don't have to run within sql correct?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Do I have to update any other components such as .net framework if I do SP1?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Lastly I know I need to backup the system databases, but should I also do a full on my actual database with data and tables or are the system ones fine?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.