slightly crafty steve, but I got it.

Interestingly, MS advise one of the first things you should do on installing an instance is backup the service master key, and this indeed...

whats the value for available memory in perfmon?

Are you suffering from memory pressures?

64 bit?

SQL probably only needs 4GB, and also the OS would use some of the 6GB. you should set a max memory value for SQL or you may starve the...

no probs,

As none of your apps connect with sa there would be no problems with changing the sa password to a known value.

I would not however disable or rename the...

in short - no.

BUT - you don't need to know the sa password to apply a service pack. Just make sure you have sysadmin and the account you run the...

robinrai3 (1/5/2012)

---

Hi Guys,

When you take a backup, i assume it backs up all the data from all the files

into a single bak file and internally it must in some header...

Jayanth_Kurup (1/5/2012)

---

You should have some NFR's about the kind of transactional activity expected for the database . Usually its a good idea to understand the NFR and then Size the...

am I missing something here? whats wrong with sp_help?

you can look at the code in sp_help to see how it's done if you only want a subset of what sp_help...

Richard Moore-400646 (1/4/2012)

---

You'll have to create a new database with just the single data file and export / import the data from the old database to the new one. ...

depending on your RAID level having the multiple files on the same drive is not buying you much anyway performance wise.

arrange some downtime.

BACK THE DATABASE UP! this is your recovery...

No. You just need continuity in the LSN chain in the log backups. Remember you can restore logs right through a full backup without having to restore that full backup.

The...

I am afraid you cannot use backup\restore to change the number of files. All you can do is change where those files are restored to (a single drive from multiple...

you can shrink the log, just don't truncate it by any means other than a log backup, that will break log-shipping.

why is your log file full if you are backing...

Santa traverses the globe, must have been fog somewhere 😉

of course, and my apologies for being tetchy.