How to Resolve Error 7904 or Filestream Error in SQL Server Database

SQL Administrators maintain a healthy, updated, and a restorable backup copy of the database, and if this database gets corrupt, then it is restored using a backup. But, there are instances of corruption in SQL database while restoring MDF files (primary database files) where the restored database shows an error message: Table error: The Filestream […]

Recover Suspect MSDB Database Icon

How to Recover Suspect MSDB Database in SQL Server?

MS SQL Server has mainly four system databases they are Master database, MSDB database, Tempdb, and Model database. Master Database: The master database stores all the system level information of the SQL Server like system configuration and logging account settings. Tempdb Database: A global resource holds information of all the temporary objects like temporary tables […]

Forgot “sa” password

this is a common problem we will be facing in our test environment or in our test,personal and dev environment servers. ,  there are 3 steps to recover the lost password, Step 1 Open the SQL Server Management Studio.  go to the security tab in the  server objects. click on logins  select the user you […]