sql

SQL database Offline or Online

Linux General,

When you are working with the databases to restore or backup you may come across the error: “Cannot Backup/Restore (especially) when database is in use” So in order to over come the database status, Right Click on Database -> New Query: sp_dboption ‘dbname’,’offline’,’true’ (It will make the database to become offline) sp_dboption ‘dbname’,’offline’,’false’ (It will…

Read more