Viewing 15 posts - 1 through 15 (of 232 total)
Well, that's a critical situation as backup is also encrypted. Did you get any key from the hacker to decrypt the file?
In my org, we have faced the ransomware issue....
September 17, 2021 at 4:07 am
this error means that some other process put a lock on a database file (or other related SQL Server files as well, i.e. log files, etc.) and SQL Server cannot...
June 14, 2021 at 9:04 am
1. Install and run SQL Management Studio to access the database.
2. Make a full backup of the database mentioned in the Description line of the error.
3. Stop all Milestone...
May 19, 2021 at 7:36 am
are you getting any warning or message popup?
May 19, 2021 at 7:28 am
The problem is due to the lack of permissions for SQL Server to access the mdf & ldf files. All these procedures will work :
May 12, 2021 at 5:53 am
You can check this link: https://support.microsoft.com/en-us/topic/kb4527376-cumulative-update-1-for-sql-server-2019-a8dae09e-96b5-9f13-9092-977341fafe17
May 12, 2021 at 4:55 am
Below are some reasons that could interfere with the restore process and throw the ‘restore of database failed because the database is in use’ error:
February 18, 2021 at 10:22 am
You should read this thread: https://dba.stackexchange.com/questions/254796/restore-a-database-with-a-different-name-on-the-same-server
February 18, 2021 at 10:18 am
Here's the blog where I found the answer: https://bahtisametcoban.home.blog/2019/01/04/always-on-availability-groups-with-multi-subnet-failover-cluster/.
In case you don't feel like reading through it, the answer is
If you enable [Availability Groups] before cluster is fully...
February 18, 2021 at 10:10 am
Is there any other option?
November 19, 2020 at 10:12 am
This handy page from Microsoft should be very useful for you as it explains in detail how to carry out a migration and the tools and methods available: Supported Version...
November 18, 2020 at 6:22 am
Read Paul's solution from this question: https://www.sqlservercentral.com/forums/topic/how-to-restore-ndf-file-in-database-sql-2005
December 18, 2019 at 6:35 am
Check this reference: https://www.mssqltips.com/sqlservertip/5526/how-to-setup-and-use-a-sql-server-stretch-database
December 13, 2019 at 6:56 am
You could use the following command which returns the URL of the backup file:
FROM managed_backup.fn_available_backups ('databasename')
For more details, please refer to https://docs.microsoft.com/en-us/sql/relational-databases/system-functions/managed-backup-fn-available-backups-transact-sql?view=sql-server-ver15.
Hope this could help you.
November 11, 2019 at 8:34 am
You may read these blogs: how to attach SQL database without LDF
November 11, 2019 at 8:33 am