You might not have unistalled the client componenet. Try accessing the same client componenet there is not much different in 2008 and 2008 R2 client componenet.

Is this manual or automatic failover?

I dont think if this manual failover then one database failover to mirrored will support for all you need to manually need to failover the...

Create luns and vloume of the new san disk then try to move the database files and other dependecy one by one to the new san disk. Once done with...

After the move and restarting the SQL Service as model db is not available or sql server is not able to find it it is not starting the service.

Check if...

Jeff Moden (3/4/2013)

---

In that case, you might try what SQL Server itself uses for replication if you have the disk space. BCP in native format. Export the table...

Hey CapnHector,

Do agree with you , as a DBA, we all have the same nervous system. Almost each time I will be biting my nails until the server comes up.:w00t:

That...

In theory , If there is no depedencies with log shipping and log shipping uses only the primary Transacton log backup then emtying the second log file and deleting it...

There are many questions as What type of configuration was it high safety mode or high performance mode?

If this is set with high performance mode with winthness server then there...

Thanks Perry and EdVassie,

Yes your input to have separate volume have helped me here. I was able to configure the

Active/ Active cluster. So the current structure is 2 node...

Did you run SQL Server setup on second node with the option add node to the failover cluster and then specify the cluster instance during the setup?

No, only a transaction log backup will truncate the log.

Thanks Perry, for taking this up.

When I select Storage from the failover cluster I could see only 1 disk available with 900 GB in size and if I expand that...

Yes the login should be present in local and as well in the target server and with permission.

My table is huge and get lncremented to 10 - 20 GB in a week so we were planning to partition the table on date range weekly and push the...

Thanks.

I will check the link.

Also Iam trying to using paramter in the datasource but it failed with the following error. Almost broken :w00t: but every run the same...