Solved

Backup

Posted on 2011-03-09
2
336 Views
Last Modified: 2012-05-11
I am having a problem with a backup.
I have a bakup of a Database "mydb.bak" 2-years old.

I am using diffrent  types of backups but getting en error?

1. How can i find out the name of the DB
2. Filegroups in this backup.
3. getting problems with physical & logical names.

anyone
0
Comment
Question by:shanj
2 Comments
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 250 total points
ID: 35081996
RESTORE FILELISTONLY FROM DISK='<path to your file>'
RESTORE HEADERONLY FROM DISK='<path to your file>'
You're gonna see contents of your backup file.
0
 
LVL 5

Expert Comment

by:ThakurVinay
ID: 35082148
what error are you getting?
what version of sql server are you using?

verify the backup also.

restore verifyonly from disk=""

HTH
Vinay
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now