Browse by Tags

All Tags » backup (RSS)
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 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 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 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: , , , , , , , , , , , ,
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 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: , , , , , , , , , , ,
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: , , , , , , ,
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 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: , , , , , , , , ,
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: , , , , , , , , , ,
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: , , , , , , , ,
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: , , , , , ,
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: , , , , , ,
Your Disaster Recovery plan is only as good as the backup systems at its foundation?
Published 27 September 7 4:34 AM | SSQA.net
So how does your DR plan look like when it comes to reality? And you know the stats aren't pretty when it comes to business success rates after a disaster has hit. Make sure your data backup and DR plans are in check to avoid becoming a statistic...
Filed under: , , , , , ,
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: , , , , , , ,
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 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 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: , , , , , , ,
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: , , ,
More Posts Next page »