New answers tagged restore
0
votes
Accepted
Mysql point in time restore using event position from 100 binary log files
You dump each binlog file and grep it until you find the file and position you're looking for.
Example: I ran 'drop schema test2' on my local instance and then checked the last binary log file. I use ...
- 10k
3
votes
Accepted
SQL Server fix deleted mdf
The normal process to recover from a storage failure is to backup the tail of the log (if possible), restore from your last full backup, restore the most recent differential backup (if you do those), ...
- 24.5k
0
votes
How to tell Microsoft SQL Server Management Studio that a DB rename must be done completely
Answering Your Questions
How to tell Microsoft SQL Server Management Studio that a DB rename must be done completely
and
Is there a way to enforce the DB rename to perform a FULL rename (everything,...
- 15.1k
-1
votes
How to tell Microsoft SQL Server Management Studio that a DB rename must be done completely
Database data file and log file are locked as long as database is online and can't be changed just as many other files opened by an application.
If you're using SSMS when restoring, load the backup ...
0
votes
Accepted
How come mariabackup fails to restore in ubuntu and achieves it on fedora?
Awards to Rick James.
When I posted my question I actually saw the difference between versions (10.3 - 10.5) and I remember having updated MariaDB manually from its own repos and not ubuntu's official....
5
votes
How to tell Microsoft SQL Server Management Studio that a DB rename must be done completely
It sounds like the names of each database are not largely important, as you've mentioned they're copies you've restored to your local PC. If that's the case, a much easier approach may be to rename ...
- 3,219
5
votes
How to tell Microsoft SQL Server Management Studio that a DB rename must be done completely
This is how it is designed by Microsoft, if you rename database only database name changes - neither logical nor physical name changes. This is described in the documentation Rename a Database - ...
- 3,752
0
votes
UnShrunk SQL Server database restore which is larger than available disk space
You can use Relocate all files to the folder where your drive has a lot of free space. I have same problem on Drive C and use Relocate all files to option in SSMS as shown as then click OK and solved.
- 101
Top 50 recent answers are included