sql4gnt (1/13/2014)

---

I have a question to add to this...would separating a database into multiple files on the same storage group have much of an impact? (Not considering SAN caching...

you'll need to use linked table manager to relink the tables

check connections in the sql server.

Rename the backend Access db 😀

😉

What?

Identitfy the Live tables that require obfuscating (there's likely only a few). Build...

PearlJammer1 (1/15/2014)

---

Hi

I have sized my 2 tempdb files at 20Gb each because I saw sql monitor returning a lot of sort warning and hash warning alerts - so I figured...

download the cum13 update and extract it to disk, then run the msi from the extracted folder

See my 3 part guide on this site at the following links

Create virtual cluster Part1[/url]

Create virtual cluster Part2[/url]

Create virtual cluster...

No, that's complete twaddle :Whistling:

smallmoney (1/14/2014)

---

If I created a new File Group, called Group123, I can't...

jamessdba (1/15/2014)

---

Hi folks,

i was told to send the restore DB log report .

i know we can fetch this through MSDB(sysdb)..RestoreHistory table.

Where can we check the log for backup or restore...

Ted, don't forget about the new Dynamic weight quroum configuration in Windows 2012, this can help to maintain quorum during node shutdowns but on a catastrophic would likely be ineffective,...

Ted Zatopek (1/14/2014)

---

I have "corrupted" a SQL named instance and I think I know how I did it. I'm at a loss on how to recover. ...

Doesnt look good for that table, as Gail said do you have a clean backup and unbroken log chain. If not, why not 😉

+1

On many occasions I've been asked by clients to reconfigure a sql server and move the system databases, mainly because a vendor has deployed a server with mal configured local...