How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
Answer Posted / rahul
1) type cmd in rum
2) Stop the Server from configuration manager first and
then In Command Window, Type net start mssqlserver -m for
starting the Service in single user mode.
3) Type net start mssqlserver -f to start the Server in
minimal configration.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a fill factor?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is sql collation?
query processing
what is datawarehouse?
What is the maximum size of column in sql server?
How much is a sql server license?
Is foreign key a primary key?
How to disable a login name in ms sql server?
What is 1nf normalization form?
What is difference between equi join and inner join?
Define clusters?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
Explain about builtinadministrator?
What is a deadlock and what is a live lock?