about restore database

Question

Post reply

about restore database

praspras42

SSC Veteran

Points: 266
More actions
March 16, 2012 at 12:33 am

#257959

Hi all
RESTORE HEADERONLY
FROM DISK = 'C:\Backup\Adventureworks.bak';
I ran this command and got the required message.
Can anyone explain me the other things that r specified in the messege.I mean wat is the requirement of other specification.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

RESTORE HEADERONLY

FROM DISK = N'C:\AdventureWorks2008R2-FullBackup.bak'

WITH NOUNLOAD;

GO

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 2

praspras42 (3/16/2012)
Can anyone explain me the other things that r specified in the messege.I mean wat is the requirement of other specification.

Can you explain a bit more what you want to know?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 3

Henrico Bekker (3/16/2012)
RESTORE HEADERONLY
FROM DISK = N'C:\AdventureWorks2008R2-FullBackup.bak'
WITH NOUNLOAD;
GO

Why use NoUnload? It's an option only valid if the backup is on tape. For backups on disk that option is ignored.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 4

GilaMonster (3/16/2012)
Henrico Bekker (3/16/2012)
RESTORE HEADERONLY
FROM DISK = N'C:\AdventureWorks2008R2-FullBackup.bak'
WITH NOUNLOAD;
GO
Why use NoUnload? It's an option only valid if the backup is on tape. For backups on disk that option is ignored.

Just need OP to see the N before the file path that he's missing.....

edit: OK, once again I only assumed he has issues, and not the real question...apologies OP.

As Gail asked, what was the intention of your question? do you need more info on the results message you got from your query? Please explain.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 5

Edit: nm

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass