Tag Info

Hot answers tagged

5

You don't have to be fancy/worried or scared when you are restarting sql server. Just make sure that you dont have any long running transactions. Best is to restart sql server using console or shutdown command during a low/minimum activity period also called maintenance window to minimize impact on your business. If you have any DR setup and you dont want ...


2

Not exactly when it comes to shutting down and preventing DB corruption. MS SQL Server is a very mature product and the odds of causing a corruption issue by a simple 'shutdown' would be a edge scenario. You're much more likely to cause corruption by not running CHECK DB or having checksum validation set on your DB. Perhaps having external tools ...


1

A shutdown is already in progress. You can either Wait Login using su - oracle and then sqlplus / as sysdba and issue the command shutdown abort if that's what you really want.



Only top voted, non community-wiki answers of a minimum length are eligible