Browse by Tags

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

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

Could not connect because the maximum number of '1' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed."

Published 26 September 7 5:27 AM | SSQA.net

The above error is obvious when you have setup the SQL Server instance to accept only 1 connection. The default setting for number of user connections is '0' which accepts unlimited connections. With similar settings one of my friend have had...

Filed under: sql server, anti-virus, connections, service, recovery, tcp, restart, maximum, sp_configure

Recovery of database 'dbname' (10) is 17% complete (approximately 31602 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.

Published 5 September 7 3:13 AM | SSQA.net

Though the message specifies as an informational message only and no user action is required, you should take some action to avoid current behaviour of databases within your environment. Also check whether you have enabled the AUTO_CLOSE property for...

Filed under: sql server, performance, databases, sqlagent, error log, recovery, suspect, message

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

Data Protection and Disaster Recovery Tips

Published 28 August 7 5:54 AM | SSQA.net

How to protect and secure data in the event of a disaster? It's not possible to anticipate every possible disaster your organization may encounter, but you don't have to. Discover a wealth of information about how to protect and secure your data...

Filed under: sql server, high availability, server, recovery, disaster, tips

Changing database recovery models: FULL to BULK-LOGGED and vice-versa

Published 14 August 7 4:38 AM | SSQA.net

Since SQL Server version 2000 better enhancement of three types of recovery models: simple, full and bulk-logged are fetching long-run support for all kinds of database activies. As you know such recovery models offer varying levels of recovery for restoring...

Filed under: sql server, database, transaction log, recovery, full, bulk-logged, recovery model

SSIS and Disaster Recovery Planning in multi-user environment

Published 25 June 7 4:50 AM | SSQA.net

I have had an interesting discussion in SSP World about how to grant access & privileges to handle SSIS packages in a high availability and Disaster Recovery scenario. As you may be aware that privilege involves having access to Distributed COM components...

Filed under: sql server, ssis, security, ssas, users, recovery, disaster

Disaster Recovery and High Availability with WANSync

Published 19 June 7 1:1 PM | SSQA.net

Learn about a disaster recovery and high availability solution for conscientious IT professionals. Find out how WANsync works to protect data, and how it can ensure the integrity of both the data and the application. Download your free copy today! Read...

Filed under: databases, high availability, recovery, disaster

Transaction Log Guidelines

Published 19 June 7 4:9 AM | SSQA.net

I always see many posts in the forums asking about transaction log backups and their importance. For the point in time recovery they are must in order to provide the data upto date or atleast that are committed. Yet I have seen many articles out there...

Filed under: sql server, data, transaction log, recovery