All Questions
46
questions
0
votes
1
answer
74
views
How does sql server derive the `Restore As` value?
When I'm restoring a database, it is auto populating the original file name and restore as.
The check box (relocate all files to folder) is to change the destination path.
No matter if this checkbox ...
2
votes
1
answer
271
views
SQL Server - Restoring backup with SQL Server Management Studio restores another database than running a 'restore backup' query
These are the steps I have performed:
I have run a 'restore backup' query for an old database backup
Then, I restore a backup with SQL Server Management Studio. I changed the type of some columns and ...
0
votes
2
answers
59
views
Does tail log backup option during restore (UI) truncate the tlog? And is there any way (UI option) to prevent truncation?
When restoring the db via SSMS UI, there is an option (checkmark) to take the tail log backup and optionally to place the db in NO RECOVERY mode.
Does such a tail log backup truncate the tlog? And is ...
0
votes
0
answers
104
views
Backup not taking latest position
We are doing a Backup / Restore with maintenance plans. Running a scheduled job for the maintenance plan to backup a database and save it to another server. The backup is being created every night and ...
0
votes
2
answers
362
views
SSMS doesn't rename files automatically when restoring a specific database. Why?
I have several databases that when I restore using SSMS and choose a different destination name, the file names are also automatically renamed.
Example:
The problem I'm having though is with one ...
0
votes
4
answers
687
views
How to tell Microsoft SQL Server Management Studio that a DB rename must be done completely
I have an older copy of a database. I retrieved it from customer system by taking a backup and restore it on my local PC. I would like to have a look at a more recent copy of that same database. ...
0
votes
1
answer
212
views
Corrupted database. How to restore it from an old backup and add newer changes after?
I have a corrupted database with the following error
Msg 8952, Level 16, State 1, Line 1
Table error: table 'sys.syscolpars' (ID 41). Index row of index 'nc' (ID 2) does not match any row of data. ...
1
vote
2
answers
267
views
In SQL Server the backup file is around 190 gb, but when restore the log needs around 2 TB space
From the production the database is backed up automatically every day full backup and every 1 hour for transactional backup.
A test server was prepared and I want to restore the latest full backup to ...
0
votes
2
answers
753
views
Database status "restoring..."
I have opened SSMS today, and went to open my database ADMINISTRATOR (in the picture) but this option is unavailable:
What's this problem, how can I cancel this restore?
I have just added a new ...
1
vote
3
answers
6k
views
Backup sqlserver 2019 and restore to Sqlserver 2017
I have only 1 table in SqlServer 2019 that I want to backup and restore into SqlServer 2017 in different server.
To SqlServer 2019 I have access to server and with SSMS but to SqlServer2017 I have ...
2
votes
1
answer
1k
views
Source Database of a restore stuck Restoring
I have copied a database vn_Budget_2021_BofDOct29 to the database vn_Budget_2021_Rig2. I did this through Tasks->Restore Database shown in the second image.
I saw this similar issue except the ...
4
votes
1
answer
1k
views
Not able to restore a backup to SQL Server 2019
I am trying to a restore a SQL Server from a .bak file and always get the same error :
The database was backed up on a server running version 15.00.2000.
That version is incompatible with this server,...
1
vote
2
answers
3k
views
Can't alter database roles on a restored database
My SSMS Login (using an AD group) is allocated all server roles apart from sysadmin so I have quite a lot of access.
Using this Login, I have restored a database from its .bak file. However, my Login ...
0
votes
1
answer
43
views
How to bring all replicas on a SQL availability group to an earlier state / point in time?
I have a SQL Always on availability group, with 4 replicas. One of them is the primary. Lets say someone accidentally drops a table on the primary. This transaction would go to all of the secondary ...
0
votes
0
answers
2k
views
"The backup set holds a backup of a database other than the existing database." - No matter what - even with replace?
I have a strange problem. I have been able to restore + overwrite databases for years on our SQL Server yet suddenly I seem to be unable to overwrite any databases.
I should be system admin, there is ...