Browse by Tags

SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans?

Published 29 April 8 5:14 AM | SSQA.net

As a DBA you might be aware that since SQL Server 2005 database maintenace plans have given flexibility in deploying the workflow of tasks required to make sure that your database is optimized, is regularly backed up, and is free of inconsistencies in...

Filed under: sql server, database, dba, blog, best practices, responsibilties, backups, strategy, size

SQL Server Database Mirroring and Sharepoint server - gotchas and problem solutions

Published 18 March 8 6:23 AM | SSQA.net

You may be aware that Database Mirroring is an important High Availability [HA] option available within SQL Server 2005 version. Having this HA option within your Sharepoint farm where the databases are associated to failover, then you must note few issues...

Filed under: sql server, high availability, technet, database, best practices, sharepoint, database mirroring, failover, links

Relation between SQL Server 2005 and Volume Shadow Copy services?

Published 19 February 8 2:45 AM | SSQA.net

Until last month I was not aware about Volume Shadow Copy and what is the relation between that service & SQL Server services, so here I would like to give the information in this regard that will discuss SQL Server connection issues that you may...

Filed under: sql server, backup, database, disk, best practices, vss, configuration, volume shadow, sqlwriter

SQL Server database upgrade - FAQs, How-to, Gotchas, links and blurb

Published 22 January 8 7:55 AM | SSQA.net

Upgrading a SQL Server database should be straight-forward, when you haven't got much of constraints on the application code. In this regard we have blogged previously such as UpgrageTags posts. Here in this post I would like to go with few FAQs that...

Filed under: sql server, database, upgrade, best practices, sa, clustering, database mail, data files, FAQ, gotchas, sqlmail

Calculate size of an index for a new database?

Published 17 October 7 2:6 PM | SSQA.net

How can you calculate size of an index in a database whenever a capacity planning exercise if performed? By default the size allocated for each user objects depends on the user application and on the amount of space that is created by the application...

Filed under: sql server, indexes, database, dba, cache, best practices, tempdb, capacity, calculate