Ivan Gusev
  • Member for 1 year, 11 months
  • Last seen more than a week ago
  • Russia Rybinsk
How to Restore data from binary log
5 votes

First of all, it should be noted that the binlog files contain changes of a database for a time interval, but they do not include ALL data, and it makes no sense to restore only the binlog files. As a ...

View answer
Sql server database synchronization on 2 different server
3 votes

You can go in three ways: Use replication. This is a large area of ​​database engineering. I recommend you get started with types of replication. Use log shipping. This is usually used to create an ...

View answer
How to unpack a DACPAC?
2 votes

I know two ways to import DACPAC file. Via SQL Server Management studio: Right-click on Databases in object explorer Select: Deploy Data-Tier Application Follow the prompts     Via sqlpackage.exe ...

View answer
Set crontab backup job for Mariadb Databases from 1 remote server to another
Accepted answer
1 votes

Your task will not fit into one command. You need a bash script. If your backup server has FTP then here is a good script . If FTP is not installed on the server, and you do not want to bring it up, ...

View answer
Need help merging multiple full SQL Server Backups into single database
1 votes

There is a fairly simple way that I use for a similar task: Restore a backup under a different name. For example, WellProductionInjection_new_data Right-click on WellProductionInjection_new_data -&...

View answer
Why is a .bacpac file so small compared to a .bak file of the same database?
1 votes

A backup created via the BACKUP DATABASE command (.bak) is a page-by-page copy of a database. Note that SQL Server database contains not only data pages. There are also pages with indexes that can be ...

View answer
How to take a remote SQL server database backup to local machine?
1 votes

If you prefer to save the classic SQL Server database backup (.bak) to another machine, then the only option is to use a BACKUP DATABASE with a shared folder. If, in general, the backup format is not ...

View answer
AWS RDS SQL Server Native Backups
1 votes

As far as I understand, your task is not so much to make a backup - how to automatically restore it to another RDS SQL Server in the development environment. In general, there are two ways on how to ...

View answer
pg_dump without postgresql
1 votes

For Windows Just download the version you need here It is not necessary to extract all data from the archive, it takes up a lot of space. It will be enough to unzip the \pgsql\bin directory, it will ...

View answer
Location of postgres db file for backup
1 votes

To find out where the PostgreSQL data folder is located, just run SQL query: show data_directory; You can find more details here However, note File System Level Backup are faster but large in size. ...

View answer
How to copy database from one server to another with script
1 votes

Yes, you can do it but that solution isn't perfect. You will need the sqlpackage utility and also allow the SQL server to execute the xp_cmdshell procedure Run this script on the receiver server. ...

View answer
Backup TO URL S3
0 votes

No, at the moment there is no way to transfer backups directly to S3. It seems to me that that option will not be added, since Microsoft and Amazon are competing in the cloud computing market. They ...

View answer
History of actions that occured on a table in SQL Server
0 votes

You can try enabling tracing: INSERT, UPDATE, DELETE operations will be saved in the file. I note that a lot of things that you don't need will be saved in the file. This is, after all, a diognastic ...

View answer
How to hot-backup mysql slave database with read operations
0 votes

It seems to me that you shouldn't have abandoned xtrabackup It can create compressed backups at once xtrabackup --backup --compress --target-dir=/data/compressed/ and also supports streaming ...

View answer
SQL SERVER Detailed Backup Report
0 votes

To get the path in the query to the backup file, you need to use the [msdb].[dbo].[backupmediafamily] table. Such a request should satisfy your conditions: DECLARE @dbname VARCHAR(255) = NULL --set ...

View answer
Postgresql Backup all databases seperate files
0 votes

To backup a separate database, use the pg_dump utility SET PGPASSWORD = my_password pg_dump -U postgres database_name > database.sql to restore a PostgreSQL database SET PGPASSWORD = my_password ...

View answer
Migrating or exporting a database from azure to SQL Server 2016
0 votes

Besides export\import .bacpac described by other users, there is another way to migrate a database, which in many cases may be preferable. You can create a .sql script of Azure database and then run ...

View answer
Mysql backup strategies?
0 votes

When discussing the MySQL Server backup strategy, it should be noted that this topic is not limited to the choice of the tool that will be used to backup your databases. What command should be used ...

View answer
Backup / Restore of DB on MSSQL 2019 to MSSQL 2014
0 votes

Right answer - generate script. You can set compatible for SQL Server 2014. Maybe you skipped it's an option? You can do it via SSMS:

View answer
How to sync daily the prod database to dev database in Azure SQL Server service?
0 votes

You can write a batch file that exports the database to BACPAC file and then imports into the dev database. You will need sqlpackage.exe utility and sqlcmd.exe utility The script is simple: rem ...

View answer
Granting a user a permission to restore a database
Accepted answer
0 votes

You cannot do this on an SQL server level. But you can do this on OS level. Try to this route: Use TDE, which in particular encrypts .ldf and .mdf files. Instead of a native t-sql backup-restore (....

View answer
Query to seed many to many table
0 votes

To get many to many, it’s enough to simply not specify the conditions for the relation of tables in the WHERE statement Also, You can combine the selection and insert operation. insert .. select ... ...

View answer