What is Dedicated Administrator Connection in sql server
2005?
- 2 Answers
- 4825 Views
- I also Faced
- E-Mail Answers
Answer Posted / phani kiran sai
In the previous versions of MS SQL SERVER, if the server
maxed out the resources due to any of the reasons, it was
practically impossible to connect the server thru remote
desktop. As a result of such situations, the developers /
DBA'S were forced to "reboot". Doing this, many a times, the
SQL SERVER would try to properly shutdown properly by
forcing a CHECK POINT so as to minimize inconsistency, but
there would be instances when such CHECK POINT might not
occur thus screwing up data on the server.
Microsoft addressed this problem with DAC [ DEDICATED
ADMINISTRATOR CONNECTION ] which allows the developers /
DBA'S to connect to the server and perform T-SQL commands to
figure out the problem and perform necessary action accordingly.
syntax:
START -> RUN -> CMD
in dos mode.. enter the following
sqlcmd
[{ { -U login_id [ -P password ] } | –E trusted connection }]
[ -z new password ] [ -Z new password and exit]
[ -S server_name [ \ instance_name ] ] [ -H wksta_name ] [
-d db_name ]
[ -l login time_out ] [ -A dedicated admin connection ]
[ -i input_file ] [ -o output_file ]
[ -f < codepage > | i: < codepage > [ < , o: < codepage > ] ]
[ -u unicode output ] [ -r [ 0 | 1 ] msgs to stderr ]
[ -R use client regional settings ]
[ -q "cmdline query" ] [ -Q "cmdline query" and exit ]
[ -e echo input ] [ -t query time_out ]
[ -I enable Quoted Identifiers ]
[ -v var = "value"...] [ -x disable variable substitution ]
[ -h headers ][ -s col_separator ] [ -w column_width ]
[ -W remove trailing spaces ]
[ -k [ 1 | 2 ] remove[replace] control characters ]
[ -y display_width ] [-Y display_width ]
[ -b on error batch abort ] [ -V severitylevel ] [ -m
error_level ]
[ -a packet_size ][ -c cmd_end ]
[ -L [ c ] list servers[clean output] ]
[ -p [ 1 ] print statistics[colon format]]
[ -X [ 1 ] ] disable commands, startup script, enviroment
variables [and exit]
[ -? show syntax summary ]
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we use max in where clause?
How do use Having,Group by,Group function in SQL?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What are click through reports?
How to call a function from a stored procedure in SQL Server ?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What is page-level compression?
What will be the maximum number of index per table?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What is the difference between getdate and sysdatetime?
How to convert numeric expression data types by assignment operations?
Explain the difference between HTTP and HTTPS in database?
What is logshipping and its purpose?
Explain boyce and codd normal form(bcnf)?
How to use order by with union operators in ms sql server?
