Browse by Tags

Best Practices: Upgrading Cluster SQL Server from 2000 to 2005 version - are you worried?

Published 16 November 7 4:53 AM | SSQA.net

I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out...

Filed under: sql server, restore, high availability, backup, security, upgrade, best practices, cluster, 2000, 2005, detach, attach, data files, logins

Automation of Analysis Services database backup

Published 26 September 7 5:19 AM | SSQA.net

You may be well versed with scheduling the database backups using SQL Serve Agent --> Jobs with Enterprise Manager or Management Studio. So how about creating a automation job for SQL Server 2005 analysis services database backup every night. Simple...

Filed under: sql server, databases, backup, security, reporting, sqlagent, Analysis Services, xmla