Are you just changing IP addresses or are you moving domains too?

Have you checked the job schedules?

did you run the query above?????

SQL server will take care of itself.

KcV (1/4/2013)

---

Hi,

I have just shifted my database of sql 2000 to sql 2008 64 bit after running Upgrade adviser.

then i run DBCC DBREINDEX in all tables.

After that when i checked...

OS error 2 means the specified file could not be found, was it purged or deleted maybe?

What are your retention periods on the primary and secondary?

To repair the LS scenario...

If you have role separation in the organisation then the OS and the cluster should be managed by the Windows server team. SQL Server obviously manmaged by the DBAs.

I have...

Follow the original link, it describes exactly what you need to do!!

zi (1/4/2013)

---

Dear friend

Thanks for replying, is creating database also apply this option because I have created a new database by 50,000 MG but it tooks a very long time.

and sory...

jitendra.padhiyar (1/4/2013)

---

Hello Masters,

I have clusters on sql server 2008R2, I am learner for clustering on sql. So can you pls guide me regarding cluster on sql server 2008? I can...

That link is pretty descriptive!!

As the KB says, a rolling upgrade involves upgrading the current mirror, then failing over the databases and upgrading the new mirror (which was previously the...

zi (1/4/2013)

---

Dear friend

I have read and applied the instant file initialization but there is no difference?

first : I deleted the database and restored it -- it tooks 5 minites

second: I...

The HBA queue depth (or...

Are the domains trusted?

You're referring to the older SQL Server 2005 operating modes which were

High Availability (synch)

High Protection (synch)

High Performance (asynch)

The operating modes are...