710 questions
0
votes
2
answers
212
views
Restore-DbaDatabase returns [Restore-DbaDatabase] Failure | Cannot index into a null array
This is causing me to pull my hair out. I'm trying to use DbaTools to restore a backup and log files to a new SQL Server. This is what I am running:
$File = Get-ChildItem '\\bckp01\sql_backups$\...
- 13
1
vote
1
answer
72
views
SQL-Express 2019: Restore Multiple .BAK Files as individual Databases
I have to restore a SQL backup from someone external and have the following issue:
Instead of making a nice single big file for the entire instance of SQL, I have a folder with 100+ individual ...
- 31
0
votes
0
answers
43
views
Unable to Restore SQL Database from Disk. SSMS only sees server filesystem [duplicate]
I have SQL Server 2022 and I am trying to take a .bak from my localhost server instance and restore it to my remote instance (NOT Azure).
When I go to Restore Database I select Device and click the ...
- 1,550
1
vote
0
answers
132
views
Unable to run DBCC CHECKDB , Receiving Transport-Level Error Every Time
LOOOONG story short, I am trying to migrate to a new server. I installed SQL Server on the new one and had it access the same drive with the sql databases.
There were some bumps trying to get it to ...
- 1,550
2
votes
1
answer
60
views
How do I partly restore data from the pg_data_dump?
I have an issue. I've got a backup functionality in my application
Here is how I do dumps:
schema_command = (
f'PGPASSWORD={os.environ["POSTGRES_PASSWORD"]} '
f'...
- 25
0
votes
1
answer
81
views
Decrypt file encrypted with Azure Backup Vault
I have a backup vault in Azure that store long term backups of my Azure Database for PostgreSQL - Flexible Servers.
Problem is that I can't restore the backups. When I restore the backups in the ...
- 11
1
vote
0
answers
149
views
Cannot restore SQL Server log due to early LSN of log backup
I want to do a databases backup on master server and afterwards restore of this database on slave server. I have this sequence in T-SQL script:
Backup (run on master server)
DECLARE @backupFileName ...
- 49
0
votes
1
answer
173
views
Exclusive access could not be obtained because the database is in use with SQL Server authentication
I am facing a weird issue with the way I am using the Server object. It looks like when using SQL Server authentication, doing a restore it's complaining
Exclusive access could not be obtained ...
- 1,764
0
votes
1
answer
96
views
Alternatives to backup/restore databases for testing purposes
I have an environment for testing purposes with its own database (Microsoft Azure). So every single release, once we deploy a new version to our environment, we restore the database from our backup. ...
0
votes
0
answers
447
views
Powershell error message: Failure | The network path was not found
I am relatively new to Powershell, and I got a script to use to restore database in SQL Server 2019.
I was running this bottom Powershell script on my new VM, and got bottom error message.
This is ...
- 1,344
0
votes
0
answers
153
views
Authorization Errors After Restoring DB2 Database to V9.7 or Higher
Here’s a message you can use to post on Stack Overflow:
Title: Authorization Errors After Restoring DB2 Database to V9.7 or Higher
Body:
Hi everyone,
I’m experiencing authorization errors after ...
0
votes
1
answer
39
views
Backup and restore metadata of PieCloudDB
I am using the cloud edition, and the overall usage of the database is relatively light, about 1GB. I want to know how to backup and restore the metadata of PieCloudDB Database management and control ...
- 89
0
votes
0
answers
153
views
How to restore external table
I created an external table by importing a Google Sheet link in BigQuery.
However, I accidentally deleted this table.
I tried to recover the table by checking the table creation and deletion logs ...
- 1
0
votes
3
answers
339
views
restore an ibm db2 from a savf file
I have a .savf file that someone created from an IBM DB2 S400 server to transmit a database to me.
I installed db2 server community edition on Ubuntu. My install works, as I was able to create a test ...
- 59
0
votes
1
answer
5k
views
Backup Dbeaver with postgres
I'm tring to apply backup using DBeaver with postgres:
1: Create backup:
2:
3: I try apply restore on another database and get this:
this is the error pg_restore: error: did not find magic string ...
- 281