Rayne
asked on
SQL Server 2014 >> Restore database from both bak and trn files??
I have a SQL server 2014 which backs up database called “YJJ” to a folder. Within that folder I several files. Please see attached excel file for that info. Now just looking at the excel, the full back up [.bak] happens at 2AM daily, followed by [.trn] backups every 30 mins.
So if I want to RESTORE the database to 1/6/2020 with both .bak and .trn…how will I do it?
Also, there is also a [YJJ_Log_bk.bak] which I am not sure what to do?
When doing the backup – I go
Right Click >> Restore Database
Device >> Add >> Select multiple files, starting from .bak at 2AM to all the .TRN files after that time stamps?
Is my approach correct? Or did I missed a step ?
Thanks a lot
backups.xlsx
BU.png
So if I want to RESTORE the database to 1/6/2020 with both .bak and .trn…how will I do it?
Also, there is also a [YJJ_Log_bk.bak] which I am not sure what to do?
When doing the backup – I go
Right Click >> Restore Database
Device >> Add >> Select multiple files, starting from .bak at 2AM to all the .TRN files after that time stamps?
Is my approach correct? Or did I missed a step ?
Thanks a lot
backups.xlsx
BU.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER