Once you add the new disks you must add them as a dependency to the SQL Server service cluster resource, this will require a restart of the clustered service

bpc0n335 (1/24/2014)

---

Hi AllenMWhite,

I realize this was an ancient post, but I also noticed that the last login date associated with your profile here on SQLServerCentral is fairly recent, so I...

Just about all the mainstream 3rd party backup products (SQLBackup, Litespeed, etc) offer backup encryption and can be used in conjunction with compression. Something which is currently limited natively.

Given the...

IgorMi (1/27/2014)

---

Hi All

I'm making a change of the database properties, so enabling ALLOW_SNAPSHOT_ISOLATION to ON. I'm doing this only once, i.e. I'm checking for the property snapshot_isolation_state in sys.databases.

Than within...

squeekz01 (1/26/2014)

---

Hi guys,

I am looking for help with writing what some may find as a basic query... I need to be able to scan all tables in my database for...

bugg (1/26/2014)

---

My question is though if I have logs backing up ever 20-30 mins or so on the principal do I have to stop this?

To allow the current log to...

Firstly, DONT TYPE IN CAPS, its extremely rude 😉

To shrink the log file the first step you have accomplished, setting recovery to simple. Next issue the following

DBCC SHRINKFILE (Logfilename,...

IT researcher (1/22/2014)

---

I have already asked some questions about Autogrowth and shrink. But I have some doubts related to it.

1)I have a database which grows about 300 MB every...

You need to specify a suitable offline time to run the Sqlio comands,

Mani-584606 (1/24/2014)

---

We have Vmware VM machines. As per Systems team, if we wanted to use Quorum as a Shared drive, then they need to create RTM drive And if they...

why are you backing up the system databases?

will the disk drives\paths be the same between the machines?

Will the new server have the same name and IP address, will the SQL...

The best practice is at the cluster level not the app, that's what i'm trying to point out. The nodes undoubtedly have access to shared storage as the OP is...

praneethydba (1/24/2014)

---

HI,

I have to migrate 15 MSSql server 2008 R2 database residing on VM to Physical machine of same version of SQL Server..

I have prepared a procedre..

1. Backup of both...

Maddave (1/24/2014)

---

I initially thought I could do the following:

Stop the log shipping backup job.

Set the database to simple recovery.

Perform the index creation.

Set the database back to full recovery.

Take a differential...