As stated: "invalid drive specification". Has the share been removed or have permissions for OKS-MAR\Administrator to the share changed?

The creation of the DTS package has to be done manually and should be quite simple to do. It can be scheduled to run as often as you'd like, provided...

You can setup alerts via enterprise manager. On the server, drop down to Management->SQL Server Agent and you'll see alerts. Right-click, select new alert and fill in the blanks (either...

Or restored to the same server/same instance using a different database name....

Here is a Googled link that may be helpful, discussing full text catalog (might help):

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1835635&SiteID=1

Is there a lot of historical data in it that can be archived or simply deleted? I think you need to get a better handle on the application and make...

Do you have backups? If not, I believe you may be out of luck. There are some third party tools that can retrieve deleted files from disk but I don't...

I must admit I'm running SQL2K3, 32 bit but I think this will apply. Awe needs to be enabled, /PAE should be in your boot.ini file and the account running...

You will have to update the table sysjobs in msdb. The field is originating_server and should reflect the new server name. I've done this in the past without issue.

Edit -...

Mobasha is right. You can take your full backups at anytime with a minimal performance hit. If your database is set to a recovery mode of "Full", you'll also want...

Sorry, missed the part about it running fine manually:blush:

Here is another link. Also, when I google the error, a lot of the hits point to the SQL7-SQL2K issue the Greg...

Obviously, the specified file is not on the server. Check the location, based on your DTS package, and...

If you have a pre and post backup, couldn't you simply init during each backup (or am I missing something)? That would overlay the latest of each of these backups,...

I've used the same setup for years and never had issues. Recommended, leave 1-1.5 GB for OS and let SQL have the rest, if this is a dedicated SQL server....

Typically, rebuilds should be run when you can have exlcusive use of the database. It will impact the server performance, it will log to the transaction log, use tempdb and,...