Found this page very useful when I had to compile some stuff for a Geode LX:
Note: this original post was from May 2007 but someone pointed out to me that the link no longer worked, in an attempt to sell me some web hosting... So... Thanks, but I'm sticking with my current hosting company.
When restoring a database, you usually start with restoring a full backup, then any differentials, and finally the transaction logs. You set the database restore mode to WITH NORECOVERY, which allows you to perform these additional restores.
But what if you find out that there's nothing more to restore, leaving you with a database stuck in Restoring mode? Then you only need to run a single T-SQL statement:
RESTORE DATABASE [db_name] WITH RECOVERY
Replace db_name with the name of your database.
Follow the chart below to successfully perform a rolling upgrade of your HA SQL Server cluster.
No_Light means there's no link on the port. Usually this indicates a problem with the physical wiring, either a faulty cable, or the TX/RX have been swapped.
No_Sync means there's a link on the port (so technically, wiring is okay), but there's a problem with the actual communication. The most common problem is a mismatch in speed on the switch port and the HBA on the other side. Your best bet would be to set the port's speed (temporarily) to auto-negotiate and see what speed is selected. If this does not work, try manually setting the port fixed to lower speeds.
RFC1918 states the following blocks of IPv4 addresses that can be used in a Local Area Network. These are "private" address ranges that do not overlap with public IP addresses.
|Network/mask||Class||First usable addr.||Last usable addr.|
|172.16.0.0/12||Class B (x16)||172.16.0.1||172.31.255.254|
|192.168.0.0||Class C (x256)||192.168.0.1||192.168.255.254|
Domain Naming Master
Also, if your domain is top-level in the AD forest, configure DC1 to sync with external time sources.
To safely remove a node from a Windows 2003 Fail-Over Cluster, follow these steps: