SqlServer-QA.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 must be started using a domain account (normally) so as to have access on both the Principal ...

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 environment performing at its highest level? Do you understand how the components ...

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 in large parts of the Middle East and India following damage to two undersea cables in the ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition  & SQL Server 2005 Standard EditionNotification Contents: New and Major Modifications How to move SQL Server databases to a new location by using Detach and Attach functions in SQL ...

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 of performing Log shipping between 2005 and 2000 instance will not be valid, as in case if ...

Paul Randal 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 on your post before implementation: More from Paul's post - ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise EditionNotification Contents: New and Major Modifications Description of disaster recovery options for Microsoft SQL Serverhttp://support.microsoft.com/kb/822400/en-US

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 projects.  

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 safe. The easiest way around this is to logon to the actual SQL Server NT machine itself as ...

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 disaster recovery. Ranging from loss of telecommunications services, power outages and major ...