Also check if any alert with the similar subject line is created.

msdb..sp_help_alert

If you found any you can delete with following command:

sp_delete_alert [ @name = ] 'name'

HTH

Good question!!!

How about profiler?

What is the physical design of database MYDB?

For file/filegroup backup both table and indexes should be on the same drive. If not both the filegropu must be backed up together....

The reson which I can think of is:

1. Data in the master/msdb do not change frequently.

2. Objects do not grow much.

3. There are no heavy insert/update/delete.

4. Referenced & used by...

Solution provided by Jeffrey Williams is the best solution.

Why are you looking for another solution?

Elaborate more what is the issue you are facing for further help.

Cheers!

Not only for DBA but in any field getting first break is difficult but not impossible.

So be focused and have patience & faith; do not give up. You will...

You can also create virtual environment by VM Ware or Microsoft Virtual Machine.

HTH

Execute following command to find out orphan users if you found any fix it and than delete.

sp_change_users_login 'report'

Good Luck!

I doubt the possibility of doing it from server role.

Hello Gila,

Thank you for pin-pointing.

Actually I overlook the clean shut down as I have practically done it but fortunate to have clean shut down.

Cheers!

In this situaltion you can use database role "db_backupoperator".

Create user and assign role of db_backupoperator in each database. Also you can create user and assign database role in model database.

HTH

Sourav,

Gila said, "Total west of time and resource" means:

1. When next time you will run the maintenance task log will gain expand.

2. Expansion and Shrink operation of the data/log file...

Hi Gila,

DCM nice post, thank you.

Cheers!!!

It is test server and assume data loss is acceptable.

You can just restart sql server services and it will automatically create new missing log file considering the file is...