Since the sequence is Backup and then log. And next cycle is the same..u would need to apply the last backup and the last log if u are trying to...

When u configure more then what sql can take , there should be no errors. I had done the same for SQL 7.0 ENT version, but the system was able...

Was looking for the same solution. Thanks.

The issue is we have cross database triggers. Since we are moving couple of databases to the other server, we need to be able to have the triggers working. Replication...

Do   sp_who active

and kill any users that are active

Just run sp_who to see sleeping process and kill them to take the db offline.

There is a stored proc in the...

try to get hold of sams publication of sql 7 or 2000 "unleashed". its got lot of info and examples.

use SET QUOTED_IDENTIFIERS ON/OFF and try.

Why don't you turn Audit on that box and then have triggers or other tools suggested by others. So that u have data to comapre who logged in and what...

U can have a job to shrink tempdb...

DBCC SHRINKDATABASE ([tempdb])

and schedule it to run twice a day or as required.

U can as well use FTP the file over network on to the other server and restore it. Let me know if you require the script to do that.

even before u run a query, check if you are able to connect to the oracle server and try connecting thro' oracle client from the sql box.

u need to provide 2 credentials for VPN which i don't think sql will recognise, unless there is any third party software for that purpose. VPN has pretty secure firewalls...

check to see if that alert exists as a predefined dropdown item in the list.

Seems to be the files gets hung...why don't you try to backup the same db to to the path defined in the maint plan just to verify. If it does...

I not sure about the reoccurence emails, but you have proc that will pick the errors from the log and send mails on a periodic basis, i mean every 10...