If you have any non-cluster aware components installed, you have to run the service pack on each node where they are installed.

For instance, SSIS and SSRS will not be updated...

Brian Tabios (1/6/2010)

---

I would not change the timing of your log backups at all - keep running them every hour. Think about how you would recover your system to...

And fragment all of those nicely defragmented indexes - so, basically a waste of time. To save some space in your data file, you can try using the SORT_IN_TEMPDB...

I would not change the timing of your log backups at all - keep running them every hour. ...

david.ostrander (1/5/2010)

---

Hi Shawn -

Thank you for the response. How would you suggest I create the the backup for the SQL 2000 DB using the SSMS 08? I new...

BSavoie (1/5/2010)

---

Thanks John.

My logic here is that I have a 100GB DB that probably only needs to be 20GB at the most. That's quite a waste of resources. I...

Investigate using a third-party backup utility like redgates SQL backup tool, Quest's SQL Litespeed, Idera's backup utility or Hyperbac (compression only).

FWIW - I was managing a system at more than...

This kind of issue is generally caused by using client tools that are at a lower version than the system you are connecting to.

Verify the version of the client tools...

Yes, absolutely use a separate file for each log backup also. I have seen people use devices and initialize the device right after they backup their system - without...

Really? I read through the posts and see that the OP stated it was...

The error is stating that you are not restoring the correct transaction log backup. After restoring your differential backup, you can only restore transaction log backups that follow that...

rmechaber (1/1/2010)

---

I'm trying to have a rolling 2 days' worth of backups on the backup HD (with nightly copies off to tape, but it's nice to have the files available...

Gift Peddie (12/31/2009)

---

Don't know what to tell you - I've installed SQL Server on Windows Vista, Windows 7, Windows 2003, Windows 2008 - in standard Windows clusters and even in...

Okay - that is going to happen when the package was created using a version that is at a higher patch level than your system. So, your system is...

Gift Peddie (12/31/2009)

---

And I am telling you I don't have them and I have searched my system for all accounts because it took me almost one week to install DNN...