Thanks all.

This is a production database of a sharepoint work collabration site.

It's setup as full recovery mode. and we do have transaciton backup every 3 hours. Transaction log is not...

Is there a phone number or forum on internet that I can ask microsoft license related questions?

Thanks

Thanks, does one license only allow one user?

So if it is a testing SQL server for 10 developers and testers to use for testing purpose, is developer version...

So, if shrinking files are not a good option, then what should I do?

Just watch it getting bigger every day?

For collation, if I install SQL server using whatever the default collation is, even the vendor product database is different collation, it will work, correct?

Thanks

Thanks .

I do need a way to figure out how fast the database grow.

I will give a try of the script.

Also is the database full backup file size pretty...

Thank you both.

This is a database and query someone else setup before - that uses case sensitive collations. (I don't know why, it's a database for network system managment)....

Thanks, that is helpful.

I also found we have a discovery software used by our network group, which I can use some queries to pull from to get SQL server lists.

How about browsing website articles like msdn library of Sql servers, and this webiste of SQL server central.

Thanks

Thanks, I will take a look at the linked site.

But any one has sql 2008 reporting installed, can anyone tell me below:

when I connect to SQL 2008 reporting service...

I should say when I connect to SQL 2008 reporting service in ssms, the first node I can see is a Job folder, instead, in sql 2005 it's a home...

Thanks!

Thanks.

when you say, When you restore a database, it goes to the mode it was in at the time of the last backup you applied.

Does this mean: if the backup...

I also did a profiler, and by filtering out large amounts of connection and other data, I found out there is one person is running ssis package on that machine...

Thank you, Warren, I will give it a try.