Browse by Tags

All Tags » disaster recovery (RSS)
Justifying Business Continuity and Risk Management - Web Seminar
Published 7 April 8 6:1 PM | SSQA.net
Better enable your users to execute their job functions, regardless of any disastrous event Availability of mission-critical applications to all users at all times is a key component of justifying business continuity and risk management plans. Merging...
Filed under: , , , , , , ,
HA: Where do you start when choosing a high-availability solution?
Published 13 March 8 4:14 PM | SSQA.net
It seems that today is going to be one of those days where I get lost in forums and blogging - I can live with that :-) One of the questions that came up on a forum today was about choosing an HA solution - based solely on the hardware that was running...
Filed under: ,
Setting up Database Mirroring using Local Account
Published 10 March 8 5:43 AM | SSQA.net
We had a need to setup Database Mirroring for a Disaster Recovery Project. We were at time running SQL 2005 Std SP1. i had to start the SQL Server Service with the startup parameter -T1400 to enable Mirroring. For DB Mirriring to work the SQL Server Service...
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: , , , , , , ,
CHECKDB From Every Angle: Example DBCC CHECKDB run-times
Published 12 February 8 2:35 PM | SSQA.net
Almost a year ago to the day I asked a question on my old blog - how long does *your* CHECKDB take to run? Well, I had a bunch of replies but I never got around to posting the results. I was reminded of this recently so threw together some graphs of the...
Filed under: , , ,
Disruption to the internet due to damage in undersea
Published 31 January 8 5:34 AM | SSQA.net
Can you sustain a disruption to your Internet service? I cannot, when I have tried to call one of the mobile service provider got this message that "Severed cables disrupt internet"?? Eventually I found that Internet services have been disrupted...
Filed under: , , , , , , ,
Paul and Kimberly interview on RunAs Radio - What's New in SQL Server 2008?
Published 12 December 7 12:7 PM | SSQA.net
While we were in Barcelona we sat down with Richard Campbell and Greg Hughes from RunAs Radio to record a 1/2 hour interview on SQL Server 2008. We touch on a ton of different features (look at the number of Categories I've tagged this with!) and...
Filed under: , , , , , , , , , , , , , ,
CHECKDB From Every Angle: How long will CHECKDB take to run?
Published 14 November 7 10:22 PM | SSQA.net
This is a subject I posted about last year on my old blog but it came up at SQL Connections last week several times so I want to repost it for those who’ve just started following my blog. There's only one time when you should be trying to work out...
Filed under: , , , , ,
SQL Server 2008: Performance boost for Database Mirroring
Published 10 October 7 7:6 PM | SSQA.net
As I mentioned in a previous post, one of the new features for database mirroring in SQL Server 2008 is log stream compression. There's a good explanation of what this is (along with some example workloads and performance graphs) on the SQL Customer...
Filed under: , , , , ,
How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server
Published 5 October 7 7:29 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to move SQL Server databases to a new...
Filed under: , , , , , ,
Can we do logshipping from sql 2005 to 2000? How it is different between 2 SQL versions?
Published 27 September 7 7:17 AM | SSQA.net
This was the question asked by one of the user in the forums. Precisely the answer is no, as you cannot restore a log or database from SQL 2005 to 2000 version due to the differences in the design. Moreover for the sake of high availability the method...
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: , , , , , ,
Advice and care you need to follow when you get a solution to your quest on SQL Server forums?
Published 15 September 7 5:56 AM | SSQA.net
Paul Randall has highlighted the importance of DBCC statements you execute within your SQL environment and care you need to take care when you get a solution for your question on the forums & newsgroups. Best advice is to test whatever has been specified...
Filed under: , , , , , , ,
Description of disaster recovery options for Microsoft SQL Server
Published 8 September 7 4:16 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications Description of disaster recovery options for Microsoft SQL Server http://support...
Filed under: , , , ,
FAN - File Area Networks
Published 1 September 7 8:51 AM | SSQA.net
Gain control over the growing amount of file data in your enterprise. Learn how File Area Networks (FANs) can help you centralize file consolidation, migration, replication, and failover. Download this eBook and start streamlining your file management...
Filed under: , , , , ,
Disaster Recovery: What to do when the SA account password is lost in SQL Server 2005
Published 24 July 7 6:21 AM | SSQA.net
As a DBA you might have come across this situation where you have forgotten the sa password for SQL Server - so what can you do? If you are experienced with such situation then definetly you might have an alternative solution to keep the passwords in...
Filed under: , , , , , ,
Disaster Recovery for Your Windows-based Applications
Published 12 July 7 11:28 AM | SSQA.net
What happens if your business critical systems are unavailable for hours or even days? Events like recent hurricane seasons, the record tornado outbreaks in the Midwest, and the record rainfall in the West have heightened attention for preparedness and...
Filed under: , , , , ,
Disaster recovery options for SQL Server
Published 25 May 7 6:13 PM | SSQA.net
Have you ever wondered what could be the Disaster Recovery (DR) options available for SQL Server. In the documentation terms: Disaster recovery is a process that you can use to help recover information systems and data, if a disaster occurs. Some examples...
Filed under: , , ,