Geeks With Blogs
Jim Lahman's Blog Fortitude|Endurance|Faith|Teamwork June 2011 Entries
Disaster Recovery Plan–Rebuild System Disk (Dell Server 2900 with PERC RAID controller)
Goal: Since the system disk is a RAID 1 mirrored set, we can rebuild the shadow set by replacing one of the good sets with a blank disk Steps Shutdown and power down server Remove the disk from bay 9, which is part of the system shadow set. Put this disk on the shelf Insert blank/old disk into the empty bay Label the new disk before inserting it into the empty bay Power up server During the booting process, the following message appears: “Some configured disks have been removed from your system…” ......

Posted On Tuesday, June 21, 2011 2:29 PM

Move SQL Server transaction log to another disk
When restoring a database backup, by default, SQL Server places the database files in the master database file directory. In this example, that location is in L:\MSSQL10.CHTL\MSSQL\DATA as shown by the issuance of sp_helpfile Hence, the restored files for the database CHTL_L2_DB are in the same directory Per SQL Server best practices, the log file should be on its own disk drive so that the database and log file can operate in a sequential manner and perform optimally. The steps to move the log file ......

Posted On Monday, June 20, 2011 4:52 PM

The answer to the unfathomable question: what is meaning of error value 2147943645?
I scheduled a task to perform a windows backup of a single disk on the my server. When I tested it, the task ran successfully – no problems, no errors; just as I expected. However, when the task ran as scheduled, it failed with error value 2147943645. I wondered was this the answer to life, the universe and everything in it? No. That is 42. After doing some research and reviewing the task configuration, I realize that the task will only run if the user of logged on: So, this was the answer!! I have ......

Posted On Monday, June 20, 2011 10:47 AM

SystemState backup fails with ‘Enumeration of files failed’ error
According the the Windows documentation, a backup of the system state can be created by using the command wbadmin start systemstatebackup. In a cluster environment, this can only be performed on the secondary node, not the primary node. Having a Windows 2008 failover cluster, this presents a conundrum in that I have services installed whose underlying executables are stored on the shareable SANS device. This means that as the secondary node, the system state knows about the location of these files ......

Posted On Friday, June 3, 2011 4:49 PM

Uninstall a service
Rebuilding a windows cluster left behind some services I no longer needed. These services are listed as part of the local services: To uninstall these services, use the sc delete [servicename] command from the Administrator control prompt ......

Posted On Friday, June 3, 2011 4:08 PM

Copyright © Jim Lahman | Powered by: