You can't copy the encrypted stored procedure. You need to decrypt it, may be using third party, and then copy to other database.

If you just want the copy of database...

SQL Mail and SQLAgentMail establish a MAPI connection with a mail host. Both SQL Mail and SQLAgentMail can connect with Microsoft Exchange Server or a Post Office Protocol 3 (POP3)...

Taking a Transaction Lof will not reduce the Log file size soon. It will prevent from further fast growth atleast. You should setup the Transaction Log process in place.

Reconfiguring the...

Turning the database on Simple recovery model will reduce the size of log file as well as improve the performance a bit.

Also make sure that you are taking the...

You can't run the Transactio Log Truncate for Mirrored database. This will not work.

As your log file is very huge, and it is required to Truncate the log file...

Hi Shyam,

You can find lots of good exampls in Books Online. Some of the URLs are :

http://msdn.microsoft.com/en-us/library/ms162773.aspx

http://msdn.microsoft.com/en-us/library/ms165702.aspx

http://msdn.microsoft.com/en-us/library/ms180944.aspx

List of all command prompt utilities:

http://msdn.microsoft.com/en-us/library/ms162816.aspx

There are many ways to monitor the disk space utilization in SQL Server 2005. You can use the SP_SPACESUSED procedure to get the space used by databases.

You may create...

You can restore the database on other server after moving the backup files.

The command prompt is run like this:

"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\OSQL.EXE" -E

Then write these lines to restore...

I disagree with Stev. We can take the backup to other disk if they are accessible by SQL Server resource list.

This is highly possible in stand alone servers. But yes,...

You can truncate the LOG file just before taking full backup. This will solve the database size issue.

BACKUP LOG maindb WITH TRUNCATE_ONLY

Remember, you should always take the full backup after...

Something like these activities:

Main Checklist for things to do during the initial setup:

1. Automate all possible jobs and maintenance plans on the server for things like...

A backup process does not cause any lost of data or changes. It takes the backup of all the committed changes to the database during the process. Due to load...

Read this for Job notification email setup.

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

To set up SQL Server Agent Mail to use Database Mail

In Object Explorer, expand a server.

Right-click SQL Server Agent, and then click...

Adding to the point, if you can make shared drive on servers which can be accessed by each others, then you can save the Backup files to shared drive by...

Hi Shyam,

Please confirm if the problem is fixed now.