New answers tagged

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 ...
user avatar
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), ...
user avatar
  • 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,...
user avatar
  • 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 ...
user avatar
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....
user avatar
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 ...
user avatar
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 - ...
user avatar
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.
user avatar
  • 101

Top 50 recent answers are included