Feb 12, 2024 · I have SQLServer 2022 Developer on my machine. A customer has send me a SQLS 2019 backup file. When I attempt to restore it into a fresh DB, I get: Cannot find server certificate with …

Nov 29, 2019 · I backup my databases from prod environment to file server. After taking my backups, i restore them to my report server. And i want to know that if i can get information about when backup …

Jul 26, 2022 · The file timestamp of the full backup shows 07/26/2022 2:17 AM. I have transaction logs taken every 5 minutes, so I would like to restore a chain of them. These transaction log backup's are …

Apr 24, 2013 · 59 I occasionally move a database (SQL Express 2012) from a development machine to a server, or vice versa, using database backup and restore in SQL Server Management Studio.

Aug 26, 2020 · Recently when I came across the script for restoring a database, I got a doubt on why we have to use "FILE = 1"? Can't we restore a database without that statement!? Basically, what it is …

Dec 4, 2019 · I need a copy of a live database called Carers on the same server for testing purposes. The test database name will be Carers_Test. I took a backup of Carers using SSMS. And tried to …

37 I am trying to restore a .BAK in SQL server but get the following error: Msg 3241, Level 16, State 7, Line 1 The media family on device 'c:\glyn\JA.bak' is incorrectly formed. SQL Server cannot process …

Oct 16, 2018 · I can't find documentation about whether agent jobs in SQL Server can be backed up. If not, how can I back them up in order to restore during the future recovery in case of an instance failure?

Feb 3, 2025 · I'm working with SQL-Server, using SQL-Server Management Studio (SSMS). In order to perform a restore of a backup, I have created an SQL Server login via SSMS, called PORT …

Jul 17, 2023 · My thought was to import the full database backup on the staging server, and then point production to that server, and then use transaction logs to update the new server, however, after …