Yes, I am the administrator of the box.

This is a windows 7 developer box

Thanks all.

Yes that's what I found too, I am using 2008, and it prompts if I want to open rollover files. And I see a Find button that is not...

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