by Gayathri R Nayak | Jan 28, 2021 | Latest, Server Management
Orphaned users in SQL Server occurs when a database user is based on login at the master database. But the login doesn’t exist at master. Normally, this happens while taking a database backup from one server and restoring it to another server (Mostly during DB...
by Gayathri R Nayak | Jan 28, 2021 | Latest, Server Management
Auto shrink database property in SQL server allows to automatically shrink the database files if the value is set to ON/True. However, it is not a good practice to shrink a database. Because it is a very expensive operation in terms of I/O, CPU usage, locking, and...
by Gayathri R Nayak | Jan 22, 2021 | Latest, Server Management
We can make use of DMF sys.dm_db_log_info to find the number of virtual log files in SQL Server. Here at Bobcares, we have seen several such SQL related queries as part of our Server Management Services for web hosts and online service providers. Today we’ll take a...
by Gayathri R Nayak | Jan 19, 2021 | Latest, Server Management
Are you looking for steps to enable Instant File Initialization in SQL Server? We can help you to enable it. SQL Server allocates space and fills it with zeroes for certain operations like creating/restoring a database or growing data/log files which is tedious work....
by Gayathri R Nayak | Jan 17, 2021 | Latest, Server Management
Wondering how to create bacpac file from the SQL server? We can help you with it. Here at Bobcares, we have seen several such SQL related queries as part of our Server Management Services for web hosts and online service providers. Today we’ll take a look at how to...
Recent Comments