SQL 2005 Failing over to secondary DB

The following process must be followed in the event that the Primary SQL 2005 server fails. This is a manual process. This information is also available on the Microsoft site: http://msdn.microsoft.com/en-us/library/ms190016.aspx Assumptions: The...

Sunday, 14 March 2010 | 519 hits | Read more

Move Citrix DB from SQL 2000 to 2005

Create SQL 2005 Database Open "SQL Server Management Studio" Right-click "Database Folders" - "New Database" Enter the name of the database Enter the size of the initial database files to be created. To avoid database fragmentation, it is...

Sunday, 14 March 2010 | 636 hits | Read more