1. Open the Configuration Manager tool from the „SQL Server 2005| Configuration“ menu
2. Stop the SQL Server Instance you need to recover
3. Navigate to the “Advanced” tab, and in the Properties text box add “;–m” to the end of the list in the …
Changing the default collation for an instance of SQL Server can be a complex operation and involves the following steps:
- Make sure you have all the information or scripts needed to re-create your user databases and all the objects in them.
- Export all your data
The best way to backup a SharePoint site is:
Stsadm –o backup –url <SiteURL> -filename <FileName>
And then at a later date you can restore the site using
Stsadm –o restore –url <restoretoURL> -filename <filetorestorefrom>
From the command line:
Backup Farm/Content Databases: STSADM -o …
Setting Domain Time
There a number of time service refinements in Server 2003 but the following will work on 2K as well. For continuity make the PDC Emulator the time server (in a 2003 domain its the time server by default)
First arm yourself with …