Author Archives: Andrew Jackson

Resolved: Database ‘msdb’ Can not be Opened. It Has Been Marked Suspect by Recovery.

User Query 1: “This is my first post here and I am in a bit of trouble I guess. Yesterday, when I attempted to access the database from Visual Studio to work on my SQL Server, I got a message that says Database ‘msdb’ cannot be opened. It has been marked SUSPECT by recovery. Error: […]

Get to Know How to Reset SA Password in SQL Server 2017

It is a cumbersome situation for an Organization when SQL Server database engine loss access as a system administrator. And, there is no relevant solution in hand on how to reset SA password in SQL Server 2017. Because if you do not regain access to password means you cannot use database anymore. Apart from this, […]

Recovering SQL Server Database Without Backup – Instant Solution

problem: “I dont have backup of my database and my mdf & ldf file get corrupted, Is it possible to restore database to previous state?” “My .bak file get corrupted by accidental shutdown of SQL Server Database and I dont have backup. How to recover SQL Server Database without backup?” Please help.” I have repeatedly […]

SQL Server Page Level Corruption And Resolution

SQL Server Page Level corruption is encountered due to several reasons, which includes hardware related issues, i.e. failure of certain hardware, hard disk functioning failure, improper network establishment, or logical level of issues such as

Performance Issues with Number of Virtual Log Files In SQL Server

Overview Each transaction log file is made of smaller parts, known as virtual log files. The number of virtual log files per transaction log files is not fixed. Its size is determined dynamically when the transaction log file is executed. The number of virtual log files cannot be set or configured by the database administrator. […]

Proficient Way For Giving and Removing Permissions in SQL Server

Overview While working with SQL Server Database, users has the right to assign or remove permission, to allow which user can perform particular tasks on the database. Due to security reasons, only some of the default database users such as db_owner, db_datawriter, etc. are granted access to the database. However, some database needs to be […]

Best Disaster Recovery Plans for SQL Server Database

Overview SQL Server Disaster is a condition that causes data loss or any disturbance in SQL Server. There are various users, who face the similar problem but they do not know how to overcome from such problem. Therefore, in the below discussion there are some reasons for occurrence of disaster and different SQL Server disaster […]

Know How to Fix Microsoft SQL Server Error 18452

Problem When the user tries to login, they may receives an error message “Login failed. The login is from untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)” which is a common problem while working on SQL Server. SQL Server Error 18452 Solutions There are various workarounds, which helps user […]

Switch to our mobile site