Viewing 15 posts - 1,126 through 1,140 (of 1,179 total)
For T-log check the size of your log backup file for 4 hrs. if it's big than increase the frequency of T-log backup to 1 hr.
Now the advantages of 30...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 14, 2008 at 5:30 am
Check the new feature of SQL Server Snapshot Isolation; if that can help.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 13, 2008 at 7:35 am
In addtiontion to Gail & Steve;
Shrink database is resource consuming hence use cautiously on the production server.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 11, 2008 at 4:48 am
Major difference is Cost; Cluster is expensive as it require identical hardware and expensive storeage SAN/SCSI.
Mirror is configured on database level while Cluster is set up on Instance/Server level.
If your...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 11, 2008 at 1:18 am
Oops.... 😛 by mistake wrong link has been posted:
here is correct one:-
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 11, 2008 at 12:44 am
It's purely depend on how application is design and what kind of activity is running on the server.
Check the following link for more detail:
http://www.sqlservercentral.com/Forums/Post.aspx?SessionID=yazjum55xw4k3y55heaxpc45
Hope this will help.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 11, 2008 at 12:41 am
You can use profiler and put filter on perticular Object on which you would like to monitor activity.
Hope this will help.
Cheers!!!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 8, 2008 at 6:57 am
CREATE stored procedure for DBCC CHECKDB and export the output of result to the text file. You can use other than sql server programme to read the error from the...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 8, 2008 at 4:54 am
Just check Distributed Transaction (MS DTC) can help you. You can also look topic two-phase commit (2PC).
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 7, 2008 at 6:36 am
MODEL database is used for Templet.
When the user will create the new database it will use the templet of MODEL database to create new database and all setting will be...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 7, 2008 at 6:13 am
Make sure user is there is master database and execute following command. Replace login with user_name without quote.
use master
go
grant exec on xp_cmdshell to user_name
go
Hope this is what you are looking...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 7, 2008 at 6:00 am
C2 auditing is resource consuming as it's capturing all the database activity hence need to use only when high security is concern.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 5, 2008 at 6:28 am
As per your environment you need to set the parameters of sp_configure. In case if you are not sure use the default settings. Refer BOL and microsoft sites for more...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 5, 2008 at 4:17 am
While running backup execute sp_who2 active for any blocking and deeply monitor server activity from which you may get some clue. Also check sql server and window error log if...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 31, 2008 at 4:05 am
SSIS might be expensive. Here is the simple way; create job and write following T-SQL command:
xp_cmdshell "copy c:\myfolder\myfile.txt d:\yourfolder\yourfile.txt"
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 31, 2008 at 12:48 am
Viewing 15 posts - 1,126 through 1,140 (of 1,179 total)