New answers tagged

0

Our server level backup software, Veeam, was apparently configured to truncate the Transaction Log. I had no knowledge that Veeam even could interact at the database level until the wise Tibor Karaszi pointed me in the right direction: (This was configured long before my existence. Side note, I see absolutely no reason why Veeam would even offer this ...


0

The bottom line is that you (unfortunately) can't rely on SSMS to help you with restore. Because it doesn't do it right. I have a case I reported 2014 which IMO is bad where SSMS tries to base a restore sequence on a copy_only backup, and I have reminded MS on this a few times. This has fallen on deaf ears, so that is a pretty clear message to me. See this ...


0

You are pretty much doing the right thing with backing up the grants logically. I recommended that same way about 7.5 years ago : Export all MySQL users You can also use pt-show-grants and append FLUSH PRIVILEGES; to the output ( pt-show-grants ... echo "FLUSH PRIVILEGES;" ) > user_grants.sql


3

Yes. You can use the --system switch. This exists only in the MariaDB version of mysqldump, although you can use that to dump from a MySQL database. system=users will dump CREATE USER ... and GRANT ... statements for your users and grants: mysqldump --opt --system=users --insert-ignore --all-databases > /root/openstack.sql The --insert-ignore option is ...


1

Yes, you can run backup on all nodes (but rather mongodump or monogexport). It is just a matter of available disk space. You can develop your own scripts and check whatever you like, e.g. systemctl status mongod, rs.status(), db.hello(), etc. Or you use the Mongo Ops Manager And then you have standard monitoring tools, one of the most common known is Nagios


0

Most likely, this is due to a fileset, volume level, or VM backup. All of those will use VSS to snapshot the disk. When they do this, they will initiate all of the VSS writers on the box, one of them being the SQL Server Writer. Talk to your backup admin, infrastructure admin, or VM admin to see if they are doing any type of backup. If they are, their action ...


5

Sometimes you can see which software performed a backup by looking in backupmediaset. There's a column called software_name that may hold clues. You're likely to see something other than Microsoft SQL Server here, since native SQL Server backups don't freeze I/O. Someone is probably taking snapshot backups via a tool like Veeam or something, which uses the ...


2

5CD/882A2558 (in file 00000001000005CD00000088) is where you will find the WAL record for checkpoint completion. 5CD/87000850 is the position from which WAL will be replayed. You can use the pg_walfile_name function to find the file for a certain LSN.


8

Not in SQL Server There is no option to force BACKUP DATABASE & BACKUP LOG to specify WITH ENCRYPTION... as part of backup commands in SQL Server. But if you want data in backups encrypted... If you want data in backups encrypted, you can enable Transparent Data Encryption (TDE) on your database. When a database is encrypted with TDE, the backups contain ...


2

The backup_label file is there for the software to read when it enters recovery. It is not meant for you to interpret. @dwhitemv is definitely wrong, it is a critical part of your backup and is not just there for your pleasure. Historically this file was created in the base directory at the start of an online backup and was then copied along with the rest ...


2

Welcome to dba.se! Try to confine posts to a single question so we know what to answer. Please update your question to identify the question you are asking if I'm answering the wrong one. The most important one I think is: does pg_wal.tar.gz contain all the wal archives I need to do a successful restore? Yes, the contents of pg_wal.tar need to be put in ...


1

The question is a little vague; do you mean an Azure SQL Database or Azure SQL Managed Instance, or do you mean an Azure VM hosting a SQL Server instance? Azure SQL Database or Azure SQL Managed Instance You cannot take a normal backup of an Azure SQL Database or Azure SQL Managed Instance because you do not have access to the underlying filesystem, so the ...


0

It is not practical to merge two databases that have both been added to. Decide on how to move data/procs/whatever from one into the other. Adding a column can destroy code that does something simple like SELECT *. Beware. Get rid of any dangerous SELECT * in the code; push that code. ALTER TABLE .. ADD COLUMN .. Push code to use that column. That is ...


-1

Adding up to the answer above, it is the issue that is resolved after SQL Server 2012 release. This restore issue is derived from the log files. I have seen some comments saying that "even though restore with UI doesn't work, restoring with query works well". However, the only working solution for me was to update SQL Server Management Studio. For ...


1

look to https://github.com/AlexAkulov/clickhouse-backup it have SFTP support and compression_format your config should contains sftp: section in config.yaml


1

Directory format dumps are restored with the same pg_restore conmand as custom format dumps. pg_restore recognizes the format automatically. Use the name of the directory that contains the dump as argument to pg_restore.


4

You can use SqlPackage.exe to create a BACPAC file. You can then use SqlPackage.exe to import the BACPAC into Azure SQL Database. You can also script it using PowerShell and automate it in Azure using a PowerShell Runbook, or use SQL Agent on-prem to automate it. The basic process you need to follow, regardless of whether you use SqlPackage.exe or PowerShell,...


1

shut down the system ... try to restore a recent backup ... I would lose at least about a day's updates to the database. Your Recovery Point Objective seems to be that you want to minimise data loss after a failure. That's good, but your once-a-day Backups don't meet that objective. Simply put, you need to take backups more often or, at the very least, ...


2

There is no way to undo things in a PostgreSQL database. You really need to work on your backup strategy. With a proper online file system backup, you can restore the database to any given point in time, so you need not lose more data than you would with an undo operation. If restoring a backup seems scary to you, that is an indication that you don't have a ...


Top 50 recent answers are included