Browse by Tags

How to drop all tables, all views, and all stored procedures from a SQL Server 2005 Database?

Published 20 May 8 3:12 AM | SSQA.net

It may not be a hardcore requirement on day-to-day basis to drop all tables, views and stored procedures from a SQL Server database within your environment, but it will be handy to have such a code at your end when such task is required. There are 2 ways...

Filed under: sql server, backup, table, drop, stored procedure, tsql, best practice, views

SQL Server databases - checkpoint, cache and I/O request - what you need to know?

Published 22 April 8 1:51 PM | SSQA.net

Have you ever wondered about flushing databases? Well not quite possible to flush it straight away and not a best practice too on the live server, so what it is about and you need to know about transactions state when they occur. Say when the changes...

Filed under: sql server, performance, msdn, backup, blogs, database, transaction log, cache, i/o, flush, monitoring, checkpointl

SQL Server 2005: What percentage of changes happened within the database after the last successful backup?

Published 21 April 8 3:1 AM | SSQA.net

No doubt that the blog subject will be a most wanted requirement on their databases, that is most responsible for a SQL Server database then arguably the most critical task that you absolutely MUST get right is your database backup procedures. Where the...

Filed under: sql server, data, backup, blogs, simple, 2005, full, recovery model, changes

SQL Server Clustering get pre-installation information and choose the best practices for your environment

Published 27 March 8 3:40 AM | SSQA.net

Before installing the SQL Server cluster there must be a checklist in order to ensure you haven't compromised on any hardcore requirement. In this regard Microsoft suggests the hardward that must be listed on this Windows Catalog and Hardware Compatibility...

Filed under: sql server, backup, services, windows, i/o, best practices, cluster, san, raid, setup, hcl, binaries, checklist

Why Backup, Why Recovery? You need a good strategy to save your data!

Published 12 March 8 3:2 AM | SSQA.net

The following context is the one I have received from SQL Server Magazine that talks about a good backup tool in the market, study on: Third-Party Tool Enhances SQL Server Backup and Recovery Microsoft SQL Server’s own backup and restore facilities are...

Filed under: sql server, databases, backup, red-gate, recovery, toolkit, third party, strategy

SQL Server 2005 Partitioned Tables and Indexes - learning curve

Published 12 March 8 3:1 AM | SSQA.net

When do you need data partitioning? The data you see in relational database may need such a strategy if the volume is huge, for instance the data to store event-log information having the schema such as: [Id] INT (make this primary key clustered), [Unit_Id...

Filed under: sql server, performance, indexes, data, backup, bi, database, statistics, partition, monitoring, strategy, data warehouse

Best Practices for Measuring and Managing Today's Complex Messaging Environment

Published 27 February 8 8:26 PM | SSQA.net

Like SQL Server Data, email is also an important aspect of day-to-day business life, more or less it is a business-critical communication tool, and downtime can be disastrous for your company. As like to the Disaster Recovery for your data, is your email...

Filed under: business continuity, sql server, backup, disaster recovery, best practice, communication, email, messaging

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 ETL Performance during Data Load Optimization

Published 20 December 7 8:40 AM | SSQA.net

Do you have a large ETL process to finish on day-to-day basis? Is your ETL process is suffering with performance loss during the BULK insert or export task? Are you using SQL Server 2005? If it is YES for all the above then you can take advantage of SQL...

Filed under: sql server, performance, indexes, backup, etl, disable, bulk insert, slow query, alter index, load

Backup and Restore of Analysis Services Database - gotchas

Published 12 December 7 3:38 AM | SSQA.net

Since the evolution of SQL Server 2000 version the backup and restore methods have been enhanced for better performance to provide a better option for the DBA, as usual the backup and restore operations are an integral part of the Analysis Services infrastructure...

Filed under: sql server, restore, high availability, backup, olap, dimension, cube, rolap, molap, holap, storage mode

Improving Backup and Recovery RTO RPO in a SAN - think on your SQL Server environment

Published 6 December 7 12:47 PM | SSQA.net

Backup and restore practices are at the core of today's best business continuity plans. While backup and restore provides many benefits, it simultaneously presents a variety of challenges with lost data, the time it takes to restore data, and the...

Filed under: sql server, restore, high availability, backup, disk, recovery, san, best practice, hardware

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

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: sql server, restore, high availability, backup, dba, best practices, third party

SQL Server 2005 how to copy database maintenance plans between the servers?

Published 15 October 7 8:54 AM | SSQA.net

How can you copy the database maintenance plans from one SQL Server instance to another SQL Server instance using 2005 version. Using the Database Maintenance plans has been increased since SQL Server 2005 is released, also lot more once Microsoft fixed...

Filed under: sql server, backup, ssis, ssms, maintenance plan, service pack2, management studio

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

TSQL script for deleting backups older than 1 day

Published 10 September 7 4:34 AM | SSQA.net

Common question and ranting about Database maintenance plans in the forums, in this case I always suggest to use another job using TSQL to drop those older backup files. Andrew Kelly, SQL MVP has contributed an excellent script sample that should get...

Filed under: sql server, databases, backup, maintenance plan, drop, tsql, forced, older

SQL 2005 Database Maintenance plan error: Value of 'DD/MM/YYYYHH:MM:SS' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'

Published 9 September 7 3:52 AM | SSQA.net

Here is another common error you will get to see with Database Maintenance plan in SQL Server 2005, though most of it has been resolved with Service Pack 2 and hotfix but still you need to take care few things. Error: Value of 'DD/MM/YYYYHH:MM:SS'...

Filed under: sql server, backup, maintenance plan, database, expiry, reset, value

SQL Server 2005 Maintenance Plan not deleting old backups

Published 7 September 7 3:21 AM | SSQA.net

If you take into account of most Frequently Asked Questions in any SQL community forums, you will get to see problems against database maintenance plans by the users. Personally I don't like them to use (by default) and professionally always depend...

Filed under: sql server, backup, maintenance plan, database, anti-virus, service pack2, directory, exclude

Disaster Recovery - planning FAQ

Published 4 September 7 11:45 AM | SSQA.net

Whether you're still in the planning stages, or you're trying to refine your organization's disaster recovery processes, this recently updated FAQ guide has information that can help. DR-Q&A Read More...

Filed under: sql server, backup, recovery, disaster

The operation has been cancelled. at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)

Published 28 August 7 4:8 AM | SSQA.net

Full error text of above message while performing the backup of a Cube: The operation has been cancelled. at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError) at Microsoft.AnalysisServices...

Filed under: sql server, analysis, backup, error, cube, operation failed, execute