You can attach the query result in "attach_query_result_as_file " parameter.

Example from BOL:

===================

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'AdventureWorks2008R2 Administrator',

@recipients = 'danw@Adventure-Works.com',

@query...

Which env you want to sync...

I think sturner had replied the same above.

SQL Girl (9/15/2010)

---

Link no longer works so I ask, what????? I installed just like I have in the past, serveral times. I am not new at this? Help...:unsure:

TITLE: Microsoft SQL...

did you dropped the table? If yes, the If you have full backup then take...

use the sys.partitions view

for detail can be found in http://www.sqlservercentral.com/articles/partition/64740/

You will find plenty of white papers on net.

download.microsoft.com/.../SQLServer2008FailoverCluster.docx

d.qureshi (9/15/2010)

---

Hi ALZDBA,

Thank you for your reponse. The link you provided requires the database to be offilne.

What I am looking for is a way to move or copy all...

We have setup weekly full backup with daily diff. backup on the primary server. You can try the same.

Recovery flow chart depend on the Backup / Restore strategy you have setup.

and also depend on the recovery model you have.

Let me first know what is the backup...

http://support.microsoft.com/kb/323135

Check the Total and Target memory counters?

As said SQL will not release memory until OS is under pressure. are you sure queries sre performing bad due to memory issue?

Did...

Change the growth option of the log file to in MBS instead of in percentage.

Check if there is any BULK operation is going you can change the reciovery model...

What changed have you made to the server?

Check if the job owner have suifiicient privilleges?

We have similar setup, backup to the network shared location and restored the same backup to a diff test server for QA testing.