DBCC memorystatus but good luck with that. 🙂

The 58Gb is just Buffer cache. On top of that you have such things as proc cache, memory for locks, user connections........

How do you know it wasn't the...

peter Vramby (7/5/2011)

---

So no proper way of restoring the model database without having to copy over a clean one from another existing instance. I better start making a filebackup of...

just add a file to the filegroup. SQL will automatically start writing to the new file. It writes in a round robin proportional fill basis., i.e it writes more to...

You don't say if the new server will have the same name?

unless you have a large number of SSIS packages stored in msdb and scheduled as jobs, recreating logins, jobs,...

bear in mind that as model is used a s the template for database creation, if you change the model database to simple recovery model all new databases will be...

related to an SSIS job by any chance?

Our resolution for this after speaking to MS was to disable the TCP chimney on the SQL server and any clients initiating the...

if you are running this process from a remote machine using SSIS TCP chimney needs to be disabled on that machine as well.

Interesting. I have certainly never come across any technical information that alludes to this behaviour. To my mind the documentation leads you to think the restore of model would be...

GilaMonster (7/25/2011)

---

george sibbald (7/25/2011)

---

I don't believe that will work...

I don't believe that will work Gail. Only the...

A failed backup will not break the log chain.

But why are you trying to force on your clients where they backup to? Let them decide for themselves, which would normally...

OS error code 5 means access denied. This is a permissions error.

Make sure the account you are using has access to the directory and to the file itself

The question does specifically say SQL208 and for sa.

For any SQL authenticated account I get 1900-01-01, for windows accounts I get NULL