SAC transfers Memory configurations also from server A to another server B? I doubt it but I got it right just by fluke. So, no complaining about points.

I will try...

This question is mentioned for March 11 and today is feb 12.

I found this link some where in this forum only. Check here sp / patches for all versions.

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

I don't think it's possible.

But back to my original question: A full backup won't do anything to the trans log correct?

Yes. Full backup will...

Thanks David. Really a good resource to keep in...

Hmmmm......just tried after seeing this question. I can execute select statements but when I put the same select statement in a proc and try to execute it, it denies...

It's still not...

EXEC sp_spaceused.

Keep track of database size and unallocated space to calculate growth. And for exact info collect data for reserved, data, index_size and unused columns size in KB every...

S

For system databases you have to give path while installing SQL Server 2005. ...

Easiest way is to modify path in server properties after installation. server properties -> Database Settings -> Database default locations.

You could do this by using DTS package with logins transfer option or else you can do with this store procedure. I had done both ways successfully.

Go through...

BACKUP DATABASE [A B C] TO DISK = N'D:\backup\A B C.bak'

WITH NOFORMAT, NOINIT, NAME = N'A B C-Full Database Backup',

SKIP, NOREWIND, NOUNLOAD, STATS = 10

GO

RESTORE...

No matter if reindex job happens in night. It would not grow that big. I don't think any one would do any dml transaction on " msdb " database.

madhu.arda (1/12/2009)

---

My concern is why MSDB log is grown to 17 GB overnight? what are things do I need to check to know what is the reason to increase log...