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. |
---|---|---|---|
10.0.0.0/8 | Class A | 10.0.0.1 | 10.255.255.254 |
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 |
Based on recommendations and best practices from Microsoft, and information I found here, I compiled a FSMO placement scenario for 2 domain controllers:
DC1 | DC2 |
PDC Emulator RID Master Infrastructure Master | Schema Master Domain Naming Master Global Catalog |
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:
Clear Cache for Google Chrome is a browser extension for Google Chrome which adds a clear cache button on the address bar. This configurable button allows to quickly and without prompting clear browser data, such as cache, cookies, history, and more.
HTML5 Character Entity Reference Chart:
It may be useful to know whether your Mac has a 32-bit or 64-bit EFI. This can be done by running the following command from an OSX Terminal (can run from the installer or recovery partition):
ioreg -l -p IODeviceTree | grep firmware-abi
This should return something like the following:
• For 32-bit EFI: | | | "firmware-abi" = <"EFI32"> |
• For 64-bit EFI: | | | "firmware-abi" = <"EFI64"> |
MacPostFactor 1.0.1 has been officially released:
MacPostFactor is a tool to install Mac OSX 10.8+ on older (Intel) Macbooks that only support up to OSX 10.7 (Lion). It works through a combination of a highly customized installer, a replaced set of drivers and various frameworks, and the original install app from the App Store. The installation can be done directly on a Macbook already running OSX Lion (so no USB disk required), or on an USB media for installation on another system.
Recent models of Mac boot up with a black boot screen and white Apple logo, instead of the old gray and dark gray boot screen. DarkBoot enables older Mac systems to get the black boot screen as well. For newer Macs, the app can also change the boot screen back to the traditional gray color.
Known to work with OSX 10.10 and 10.11 DP.
MacPostFactor 1.0 has been officially released:
MacPostFactor is a tool to install Mac OSX 10.8+ on older (Intel) Macbooks that only support up to OSX 10.7 (Lion). It works through a combination of a highly customized installer, a replaced set of drivers and various frameworks, and the original install app from the App Store. The installation can be done directly on a Macbook already running OSX Lion (so no USB disk required), or on an USB media for installation on another system.
« ‹ | November 2024 | › » | ||||
Sun | Mon | Tue | Wed | Thu | Fri | Sat |
1 | 2 | |||||
3 | 4 | 5 | 6 | 7 | 8 | 9 |
10 | 11 | 12 | 13 | 14 | 15 | 16 |
17 | 18 | 19 | 20 | 21 | 22 | 23 |
24 | 25 | 26 | 27 | 28 | 29 | 30 |