OK now this tells me how to push the report into table and use SP to send a mail. My problem is that I need to send selecttive data to...

Most probable reason is Hard Disk . Can you check if the disk is working fine. If the disk is OK check if there is enough memory available on server.

And...

This seems like the replication existed earlier also and was not properly removed.

Can you see the same stored procs without _1.

Anurag.

First thing to make sure is that the service Account you are using should have admin privileges.

Try doing the below:

Go to Services in Control Panel -> Administrative Tools and search...

Instead of the stored proc mention can you try creating a Maintenance Plan for taking backups at a scheduled time and see if it works. This will confirm if there...

To elaborate further:

1. Set your databases to be in Full/Bulk recovery mode(ideally Full)

2. Create a maintenance plan which takes regular Full and transaction log backups(example - daily night full backup...

Have you restored the backup of MSDB before the crash?

HI Mark,

Although I donot have the link but I have a doc which I downloaded from some site. This may help you.

Here it isSorry...

Hi, I have also seen this error a couple of times when the data to be replicated was too heavy. The most probable reason for this could be resorce crunch...

Changing the IP address looks fine but take care of below points:

Make sure the application doesnt use hostname for connecting.

The Primary server should be offline

The data and schema on Secondary...

Also, you may want to take a look at below sites for best practices, standards etc.

http://vyaskn.tripod.com/object_naming.htm

http://www.sql-server-performance.com/vk_sql_best_practices.asp

November 21, 2005 at 4:15 am