Browse by Tags

All Tags » sql server » restore » best practices (RSS)
SQL Server data and log files initialization, think multiple files, backup & restore performance!
Published 25 July 8 6:1 AM | SSQA.net
Whenever you perform a database creation, add a data or log file to database, AUTOGROW process is intiated or restore of database will trigger the file initialization if that is created afresh. In addition to this when you talk about files intialization...
Filed under: , , , , , , , , , ,
SQL Server Service Pack or Hotfix patch or Cumulative Update: do not attempt Windows System Restore as a backout plan?
Published 19 May 8 4:28 AM | SSQA.net
To cut the long story short, during a recent implementation of Cumulative Update 6 and 7 on a particular 'application domain' server we have had major application issues due to a mix up of application code & these SQL cumulative update fixes...
Filed under: , , , , , , ,
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: , , , , , , , , , , , , ,
How to find whether backup is performed using SQL native methods or third party tools?
Published 23 October 7 4:59 AM | SSQA.net
Interesting question: how can we know the difference between a native backup and backup taken by third party tool? Say you have started newly in a enterprise wide platform and your task is to find out what methods of BACKUP and RESTORE are followed to...
Filed under: , , , , , ,