Have you got this fixed, I have same problem now.

Thanks

Thanks much!

Perry Whittle (12/5/2012)

---

Stopping sql server is a bit like using a sledge hammer to crack a nut. You only need to take the database offline as follows

ALTER DATABASE mydb SET...

Thanks all, that makes sense.

Only month is included is because the backup history we only keep 6 months.

But good point though, I will include year as well, in case there...

Those help.

I didn't see backup size in this query. Do you mean create another query using backupSet to achieve that?

Additionally,

I wonder if a way to check directly the folder or...

Thanks, this is good for tracking database size change. I will give it a try.

Also how about the way to check above 3 directories growth?

Thanks much, that helps

Yes, this is what in that file:

But there is also SQLAGENT.OUT that has the following information:

2012-12-05 04:13:22 - ? [100] Microsoft SQLServerAgent version 10.50.2500.0 (x86 unicode retail build) : Process...

So if a database is set to read only , and by just querying the database, it won't create any log transactions, so no affect on log file, is that...

Thanks, but it seems detach and attach is easier and involves less steps to do.

By the way, what is the difference by take offline, then copy to anther directory , then bring online

with detach the database, copy to another directory, then attach it.

Which is...

Thanks much, will give it a try

Thanks both. that is helpful.

We are trying to install servers for system center management.

it doesnot support dynmic ports.

But it has to have multiple instances.

So following your instruction, I think I...

Thanks,

Can I use dynamic port for the named instance,

When I install the named instance, and check the tcp\ip port, it defaults to blank, with dynamic port set to 0...

Thanks, that will work, I will give it a try