Good question and I got it right

I have never used this loginproperty, until I saw your question... New learning every day 🙂

What is the max memory setting for SQL Server? and the total ram on the server? is it 64bit or 32?

What error you are getting?

As far as I remember, Express edition do include BIDS package. But I think there will be some limitations...

use this link to compare it with different editions..

http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx

You will not be able to schedule SQL Server agent jobs in Express edition as SQL Server agent is not supported.... Just incase you have plans to schedule jobs later...

Nice Question Moinu.... But I got it wrong 🙁

To do it easy way, I think you have to create multiple jobs for each set of recipients and schedule the job for specific day and in sp_send_dbmail you can...

Got it correct...

good one

Good question.... Thanks

Back to basics... good:-) question

create a job on your test server with following steps:-

1) Copy backup file from prod to test server. you may use command like

xp_cmdshell "copy source destination"

where source will be...

You are right 🙂

Sorry, I missed this point..

I believe this database is in full recovery mode. If you are not able to shrink the database log files then you can try changing the recovery mode to simple...