You are not logged in or registered. Please login or register to use the full functionality of this Website SybaseTeam.Com...
Hello There, Guest! (LoginRegister) Remember Me? Current time: 12-19-2014, 06:33 PM
   Home  |  About Us  |  Sybase Training  |  Synergy  |  Consulting  |  Job Openings  |  Tech Videos  |  Rules and Disclaimer  |  Search
Post Reply 
Forum Tools
dbcc dbreboot command
03-19-2010, 01:17 AM
Post: #1
Quote this message in a reply
dbcc dbreboot command


dbcc dbreboot



_ report – Shows a report on the specified database(s).

_ reboot – Database is shutdown and restarted with recovery.

_ reboot_norecovery – Database is shutdown and restarted and left in a “not recovered” state. Can be used to add more space.

_ shutdown – Database is shutdown and left in an unusable state.

_ shutdown_load – Database is shutdown and left in a state that allows LOAD DATABASE to be done.

_ restart – Restart and recover a database that has been shutdown.

_ restart_norecovery – Restart database and left in a “not recovered” state. Good when there are problems with recovery.

WARNING : ITS UNDOCUMNETED dbcc COMMAND, RUN IT ON YOUR OWN RISK , SYBASE TECH SUPPORT MAY NOT HELP YOU IN CASE OF ISSUE WITH THIS COMMAND


1> dbcc dbreboot
2> go
dbreboot (report | reboot | reboot_norecovery | shutdown | shutdown_load |
restart | restart_norecovery, [, ...])
Reboot the specified databases.
1> dbcc dbreboot(report, test1)
2> go
---------- Active Processes and Transactions in Database 'test1' ----------

Spid Program Transaction Status CPU I/O Blk Err

---------- Operation on Database 'test1' Completed Successfully ----------
1> dbcc dbreboot(reboot,test1)
2> go
---------- Shutting Down Database 'test1' ----------
---------- Re-starting Database 'test1' With Recovery ----------
Recovering database 'test1'.
Started estimating recovery log boundaries for database 'test1'.
Database 'test1', checkpoint=(25602, 13), first=(25602, 13), last=(25602, 13
Completed estimating recovery log boundaries for database 'test1'.
Started ANALYSIS pass for database 'test1'.
Completed ANALYSIS pass for database 'test1'.
Started REDO pass for database 'test1'. The total number of log records to
process is 1.
Completed REDO pass for database 'test1'.
Recovery of database 'test1' will undo incomplete nested top actions.
Started filling free space info for database 'test1'.
Completed filling free space info for database 'test1'.
Started cleaning up the default data cache for database 'test1'.
Completed cleaning up the default data cache for database 'test1'.
Recovery complete.
Database 'test1' is now online.
---------- Operation on Database 'test1' Completed Successfully ----------



Regards,
AnVa
TechSupport-SeniorMember
Sybase Forum : Sybase Blog : Sybase Wiki
Synergy Project (SybaseTeam.Com)
Find all posts by this user
Post Reply 


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  dbcc sqltext(spid) might cause signal 11 and stacktrace phadkedhawal21 1 3,103 02-02-2012 07:54 AM
Last Post: padalav

Options:
Forum Jump:


Contact Us | SybaseTeam | Disclaimer & Rules | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication