Thanks all.

For default trace, there is one active trace file, is it overwritten whenever server is restarted?

I see you can track autogrowth of files in the default trace, but it...

We don't shrink transaction log . But just for this case model database, thought its transaction log shouldn't grow.

If the full db really makes it full, then I guess we...

thanks, I do them, but here we are talking about model database only and the transaction log issue.

I guess I will just do the fullbackup, and monitor it, if transaction...

MyDoggieJessie (1/22/2013)

---

When you right click and view the DB size it includes the log file and is a rounded number (which you know). The space shown in the properties...

It sounds to exclude it from full backup is a good idea, and do a full backup whenever there is a change.

One thing I need to change though, when I...

I did a search find another article:

http://shaunjstuart.com/archive/2011/02/the-mystery-of-the-model-database-transaction-log-growth/

So the solution may be either change the recovery mode to simple or do transaction log backup or exclude it from full backup.

for the...

Thanks, that certainly helps.

Now I understand the difference, one more thing I would like to verify,

there is not a way to export the central management info from 2008 to 2012,...

Thanks all, those are good ideas

Thanks much, it works.

Adi Cohn-120898 (1/20/2013)

---

The automatic checkpoint that SQL Server issues is not the only mechanism that writes the data into the disk. If you issue manual checkpoint command, it will...

ALZDBA (1/20/2013)

---

it will write tempdb stuff to disk all right, it's just not at checkpoint time, like with regular db.

Why: tempdb is re-created every time SQLServer is started, so there...

The thing I found on a dev server, the database developer has all the rights on the box

and when he runs the build script sometimes, it accidently goes to the...

found it.

It is in x86 directory

Thanks, that works for SQL 2008. But it seems you cannnot export that from sql 2008 to SQL 2012.

Also can anyone explain what is the difference about local server groups...

Can you share your powershell script?

Thanks,