Viewing 15 posts - 661 through 675 (of 1,179 total)
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
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 17, 2011 at 12:59 am
Good question!!!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 12, 2011 at 11:51 pm
How about profiler?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 12, 2011 at 4:14 am
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....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 12, 2011 at 12:15 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 12, 2011 at 12:07 am
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!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 11, 2011 at 11:41 pm
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 11, 2011 at 11:30 pm
You can also create virtual environment by VM Ware or Microsoft Virtual Machine.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 11, 2011 at 11:10 pm
Execute following command to find out orphan users if you found any fix it and than delete.
sp_change_users_login 'report'
Good Luck!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 10, 2011 at 3:52 am
I doubt the possibility of doing it from server role.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 9, 2011 at 4:45 am
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!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 9, 2011 at 4:10 am
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
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 9, 2011 at 2:03 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 9, 2011 at 1:57 am
Hi Gila,
DCM nice post, thank you.
Cheers!!!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 9, 2011 at 1:38 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 9, 2011 at 12:09 am
Viewing 15 posts - 661 through 675 (of 1,179 total)