You database might be Standby/Read-only mode after restoring your database in SQL Server.
The solution is:
RESTORE DATABASE <db_name> WITH RECOVERY
Hint: Replace <db_name> with the name of the database.
In case your database name has space or special characters or space, write it inside square brackets [db_name].
To know more about restoring SQL Server 2012 databases, read Katie's and Emil's blog.
More info can be found from Microsoft's documentation here.
The solution is:
- Click on New Query
- Select 'master' as your database
- Run the following script
RESTORE DATABASE <db_name> WITH RECOVERY
Hint: Replace <db_name> with the name of the database.
In case your database name has space or special characters or space, write it inside square brackets [db_name].
To know more about restoring SQL Server 2012 databases, read Katie's and Emil's blog.
More info can be found from Microsoft's documentation here.
No comments:
Post a Comment