system-databases Archives

When is autoclose OK to be not OK

By adminPosted on September 4, 2022

Question : By chance, I happened to see that the autoclose feature on SQL dbs (I’m using SQL 2008) shouldn’t […]

By adminPosted on August 25, 2022

Question : Hi everyone i am getting an error trying to run the below query ERROR 1067 (42000): Invalid default […]

By adminPosted on June 25, 2022

Question : I know that system databases hold logins, security info, jobs, etc. Assuming I have backup of all system […]

By adminPosted on May 1, 2022

Question : I have just installed a new sql server 2014 server, migrated some databases there and connected some applications […]

By adminPosted on February 28, 2022

Question : I want to check whether all the sysadmin users in my sql server instance have a master database […]

By adminPosted on February 16, 2022

Question : This question already has answers here: hide system databases sql server management studio (2 answers) Closed last year. […]

By adminPosted on December 2, 2021

Question : Is it possible to safely change the drive letter for a volume which holds only system databases? What […]

By adminPosted on October 29, 2021

Question : I simulated a corruption of model database on test environment just for learning purposes. While reading others blogs […]

By adminPosted on October 20, 2021

Question : We are going to move an sql instance to a new physical server (SQL SERVER 2008 r2). The […]

By adminPosted on October 15, 2021

Question : As far as I know the resource database contains information on all objects in its server instance, so […]