What is Dedicated Administrator Connection in sql server
2005?
Answers were Sorted based on User's Feedback
Answer / muruganandam05
In this The Administrators can use to access a running
server even if the server is locked or othervise
unavailable .This capability enables administrators to
troubleshoot problems on a server by executing diagnostic
function or Transact-SQL-Statements.
Is This Answer Correct ? | 3 Yes | 0 No |
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 |
Explain trigger and its types?
How to disconnect from a sql server using mssql_close()?
What are database states in ms sql server?
What happens if strings are casted into wrong code pages in ms sql server?
How to create a view with data from multiple tables?
Can a unique index be created on a column, which contains null?
What is difference between views and stored procedures?
What are the different types of normalization?
What is BLOCK statements in SQL?
What is the meaning of resultset type_scroll_insensitive?
Can two tables share a primary key?
What is database dimension? : sql server analysis services, ssas