sgrimard (2/5/2016)

---

I don't think we have activated that policy. And it did not specify if it was the LDF or MDF.

So turn off Auto-Growth on LDF? What would you set...

sgrimard (2/5/2016)

---

Autogrow of file "DB_NAME" in database "DB_NAME" was cancelled by user or timed out after 17152 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value

for this file...

have you enabled the local security policy "perform volume maintenance tasks" for the sql server service account?

We had snapmanager at our last gig Thomas don't you remember

VMware have a BP document on their website, google and you're sure to find it

Either native or via a tool such as Redgate SQLBackup or Dell Litespeed for SQL...

you will almost certainly be expected to justify for spending then money on physical tin, don't forget it's not just the cost of the server but the on-going maintenance costs,...

remove the automatic failover flag where it's...

ok, so space wise you have no worries, as it's SAN presented you can grow the storage at will.

You're planning for a physical server then?

the architecture is detected by the installer, anything else is a futile exercise

the issue is, DB_Owner is an elevated privilege the developer does not require 😉

jcarranza 23978 (2/4/2016)

---

1. Open your Windows FailOver Cluster Manager .

2. Check which node owns the Role (A or B).

3. Pause the Secondary node (so that the Primary knows is down)

4....

is this a clustered instance of SQL Server?

Steve Jones - SSC Editor (2/4/2016)

---

If backup exec writes the backup time before it's finished, that's an issue. Certainly you might not be able to rely on this for restores...

SQL!$@w$0ME (2/4/2016)

---

Hi Guys,

Could you please give some guidance on selecting hardware for a new DB server. This will be a new Operational Data Store setup. Expecting moderate ETL load (SSIS...