All Questions
21 questions
0
votes
1
answer
848
views
Take a "slice" of a SQL Server database: for all tables, get only the rows that join (directly or indirectly) to a specific row
For audit purposes, I'm trying to obtain a copy/export of a DB but including only the rows from each table that have relevance to a small collection of rows in some table. So every row of every table ...
2
votes
3
answers
10k
views
Postgresql Backup all databases separate files
I need to create an automatic backup of all databases from PostgreSQL (running on a Windows machine).
I need to know if it is possible to get a backup of all databases but in separate files.
Using ...
- 31
5
votes
3
answers
687
views
How to minimize\plan ahead the effect of running sp_delete_backuphistory? Measure the gains too!
while running the following query:
-- DATEADD (datepart , number , date )
DECLARE @dt DATETIME
SELECT @dt = DATEADD(month,-6,getdate())
select @dt
EXEC msdb.dbo.sp_delete_backuphistory @...
- 17.3k
7
votes
2
answers
4k
views
How to back up an entire database to text files
If it’s stupid and it works, it’s still stupid.
The hullabaloo about GDPR got me thinking - if you had to go into your backups and modify/delete data, how would you do it? Cracking open a .bak file ...
- 2,668
2
votes
2
answers
466
views
How to order databases by size? (For use in full backups)
Recently, I've been trying to make our company's full backup process more efficient. In order to do this, my team has decided that instructing the backup job to tackle the full backups starting with ...
- 21
1
vote
1
answer
475
views
Arguments for MongoDB backup with OpsManager or mongodump?
I have a replica set of two MongoDB nodes running (with an arbiter) and I am now wondering about the best backup and recovery solution. I am aware of the official documentation, but it does not ...
- 113
0
votes
1
answer
658
views
how to take backup of a child table with foreign key dependency in mysql using bash [duplicate]
Parent table : p_id, t_id, name , salary
Child table : c_id, t_id , age
key : Child.t_id=Parent.t_id
While taking backup i would like to take pull only the matching records from Child table . How can ...
-1
votes
1
answer
258
views
Alert when the restore verify only fails on the latest backup of all the database
I need a way to validate the backup files of all the database on weekly basis.
A script which should run Restore Verify Only on the latest backup file of all the database and incase the backupset in ...
- 190
0
votes
2
answers
8k
views
Can't read password from config using --defaults-extra-file in MySQL
I am trying to backup all databases automatically using a batch script. The password is read from a config file called config.cnf. Below is the batch script:
@echo off
C:\MySQL\bin\mysqldump.exe --...
2
votes
1
answer
86
views
How can I optimize/make safe a script that deletes lots of data?
I'm in the process of trying to develop a script that has to delete accidentally duplicated data (due to a bug in some code), from a client's production database.
It's quite a lot of data that I need ...
- 299
1
vote
0
answers
293
views
SQL Server and Network considerations to transfer backup file to a shared folder
I'm facing with a situation where backups are being transferred manually to a Shared Folder and my goal is to optimize all of this.
What I have to deal with is:
8 Windows 2008 R2 Servers
2 Windows ...
- 155
2
votes
0
answers
938
views
How do I create an automated SQL Server restore script for multiple backups? [duplicate]
I basically have 6 daily SQL Server backups (.bak) that need a restore everyday. I want to automate this process by having the SQL Agent run the script daily. I have the following restore script ...
- 21
1
vote
2
answers
2k
views
oracle rman connecting to a database in not mount state
When connected to oracle database through rman directly from the terminal, everything works fine, but when the same connection string is executed through a shell script rman connects to the database ...
1
vote
1
answer
310
views
Is it possible to take the table level backup in mysql using any of the script?
I am new to MySQL and I am in need of the script which is taking backup of multiple tables from the multiple databases in single file in MySQL?
- 11
-3
votes
1
answer
2k
views
Generate Script Of Database in SQL Server 2008 [closed]
How to Create Script for the Database Objects in SQL server 2008 r2 and restore it in database.
- 115