Hi,

See if this KB helps.

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

You can right click the "Operator" and select "Delete" ?

You may want to do the following.

1. Create an Operator

2. Specify the Email ID for the Operator

3. Select the appropriate options under "Notifications" tab of the Jobs, for which you...

You can find information about SQL Server certifications here

There is useful command line utility called "SC". With this you can query the service status as below.

Hope this helps.

Cheers,

Pradeep

There are several ways to do this. Some of them are as below.

Backup and Restore

Use DTS

Copy Database Wizard

Log shipping.

Please refer BOL for more information.

Use the restore query and put it in a job or run directly from Query Analyzer..

RESTORE DATABASE [DBNAME] FROM DISK='\\....'

Hi,

This is a very generic question. If this issue occurs occassionally check any query/job is causing this.

If the CPU usage is always spiking, try checking your hardware configuration.

Thanks a lot for your response.

I know that to restore this master backup, the version has to be

SP3a + Hotfix (http://support.microsoft.com/kb/890942).

My problem is that I am not...

Best practice would be to use a Dedicated User account for starting the SQL Services. If the sysadmin wants more security, he may disable the "Allow Interactive Logon" for this...

Yes Kevin you are right. You can only create triggers for INSERT, UPDATE, DELETE statements.

Looks like authentication issue. Please verify that you have access to the FTP path. Try it from the browser.

I think it is not possible as the DB Owner has full access on the database.

The best way would be to put the database in Single User Mode using sp_dboptions (which would not allow further connections) and kill the existing ones.

Please go to Start --> Run

Type cmd

Click Go

Then go to the directory in which the batch file exists (e.g. CD C:\WINDOWS)

Then type batch file namd and press enter.