SQL: set database off from mirroring
August 21, 2009 at 12:52 am | In SQL 2005 & 2008 | Leave a CommentTags: SQL
alter database databasename set partner off
SQL: switch database from restoring to normal mode
August 21, 2009 at 12:35 am | In SQL 2005 & 2008 | Leave a CommentTags: SQL
RESTORE DATABASE databasename WITH RECOVERY
Command uninstall or remove Internet Explorer 8
August 6, 2009 at 11:41 am | In Vista, Windows 2008 | Leave a CommentFORFILES /P %WINDIR%\servicing\Packages /M Microsoft-Windows-InternetExplorer-8*.mum /c “cmd /c echo Uninstalling package @fname && start /w pkgmgr /up:@fname /norestart”
SQL 2008: path of the database files
August 5, 2009 at 4:35 am | In SQL 2005 & 2008 | Leave a CommentSelect name, physical_name from sys.master_files
Move DHCP database
July 1, 2009 at 11:51 pm | In Windows 2003, Windows 2008 | Leave a CommentTags: DHCP
From old DHCP server: netsh dhcp server export C:\dhcp.txt all
To new DHCP server: netsh dhcp server import c:\dhcp.txt all
Blog at WordPress.com. | Theme: Pool by Borja Fernandez.
Entries and comments feeds.
