Vani (6/5/2009)

---

There was a discussion in my company with one group holding the view that Database Mirroring could not be deployed in production in SQL Server 2005.

Has anybody deployed...

santhosh (6/8/2009)

---

One of my databases is in Recovery pending state. I tried to run an Alter command on the database to set it in Online state but it throws the...

You should check out Allan Hirts Pro SQL Server 2005 high Availability, he beautifully explains Clustering

http://www.amazon.com/Pro-Server-2005-High-Availability/dp/159059780X

A Joy (6/4/2009)

---

Krishna Potlakayala (6/4/2009)

---

ME 🙁 ?? 😀

I ran the index rebuild while the db was in bulk logged mode without...

ME 🙁 ?? 😀

I ran the index rebuild while the db was in bulk logged mode without incident, no TL growth...

A Joy (6/3/2009)

---

Very odd have a relatively large table that needs regular index maintenance.

It has been moved to a sql 2005 x64 Cluster (from SQL 2005 x32 stand alone)

The index...

bhuvnesh.dogra (6/3/2009)

---

Accidently i installed Wrong SQl server Service Pack

Can some body told me How to remove it ?

Do i need to remoce complete Sql server 2005

...

1. Full back of all databases including system databases daily once(at 1:00AM)

2.Differential backup of all databases excluding system databases at every 5 hrs(starting at 6:00 AM and 10:00 AM,3:00 PM,...

You cannot restore master database to a server which has different version. Both versions should be similar. As advised you should be able to upgrade it and then restore it...

homebrew01 (6/2/2009)

---

Ratheesh.K.Nair (6/1/2009)

---

Taking backups wont shrink the log files. that is the reason why they grew.

You have to run the dbcc shrinkfile or shrinkdatabase command to reduce the physical size...

sivark1 (5/31/2009)

---

Hi experts

when i tried to acess databases remotly from server

server is hanging(not able to open that application)

the following details are

OS : 2003 Enterprise Server SP2

Database : SQL server...

klnsuddu (5/21/2009)

---

Hi,

We are using Spot light for Monitoring SQL Server 2005 and we are getting the below error frequently.

What this error referencing to? What is the corrective action to get...

Would be great if you could share the solution please?

Jeffrey Williams (5/22/2009)

---

The requirement, as far as I know, it that you cannot mirror from 2005 to 2008 or 2008 to 2005. As long as the databases are on...

Sadequl Hussain (5/20/2009)

---

Okay, I am posting this again:

Problem:

A database exists in a SQL Server instance with an application regularly posting large volumes of data in it. The database log...