troubleshooting Question

Get table from .bak file in SQL

Avatar of Karen Wilson
Karen WilsonFlag for United States of America asked on
Microsoft SQL Server
29 Comments3 Solutions1554 ViewsLast Modified:
I am trying to get rows from a table in a DB in a .bak file.

I opened a new DB called RestoreDB.
I clicked on Restore.
I clicked on Source: Device and linked by .bak file
I clicked on Destination:Database and chose RestoreDB
I clicked on the file and verify backup media - all is good.
I click OK.
The tail-Log backup of the operation completed successfully.  The restore of the RestoreDB failed.

I'm not sure what I should try next...  any suggestions?

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 29 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 29 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros