[How-To] What to do when the SA account password is lost in SQL Server

On 27. apríla 2011, in News, by admin

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 …

 

[How-To] Change Server Collation in SQL Server 2008

On 27. apríla 2011, in News, by admin

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
 
 

[How-To] Backup/Restore Sharepoint Site

On 12. apríla 2011, in News, by admin

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 …

 

[How-To] Configure NTP on Windows 2003 Server

On 5. apríla 2011, in News, by admin

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 …

 

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

WordPress主题