There are various methods of doing this. One of them is explained in this KB

Hi Robert,

You have used the correct commands to verify the backup integrity. From the error message, it looks like the backup file is corrupt.

Did you mean minimum databases required to start SQL Server service? If so, then the following system databases...

Little bit of Googling will surely help. However see this link.

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...

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.