1,930
We had some corruption - but did not have a backup (backup that is created by GP or SQL) typically these backup sets have *.bak as an extensioin.
But we do have the backup of mdf and ldf files - how can we restore these?
Thanks
It also may not be a bad idea to run DBCC CHECKDB against the restored databases just to make sure no consistency or allocation errors are found on the databases.
This will help verify there isn't any issues with the GP objects nor SQL objects or the database itself.
You do not restore mdf and ldf files you attach them. You will find this under tasks on the database in SSMS.Right click on any database - Tasks - Detach/Attach. When you attach the database make sure you set DYNSA as the owner.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (