SqlServer-QA.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 RecoveryMicrosoft SQL Server’s own backup and restore facilities are probably some of the most robust in the industry. So why consider purchasing a third-party ...

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 costs of restoring lost data.This web seminar will explore SAN copy and replication methodologies, in ...

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 issues and called me for a help, as the setup was SQL Server 2005 for use with ASP.NET 2.0 WebParts. ...

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 any of the databases on that SQL Server instance, on the down side it is not ...

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

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 in the event of a disaster. You may not be able to predict the exact details of a disaster, but you ...

HI, Don't you have latest backup of the database, if not please schedule backup accordingly so that this situation doesn't recurre. \What if you create create a a database with same name on the same machine at exact location of this database, then detach it and re-attach with newly created .ldf file; may be this will trick!! 

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 your databases from your backups, overall if there is a bulk data update ...

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 as well including MsDtsServer. Few points you need to consider ...

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!