Hi!

I am trying to backup several databases (AdventureWorks, 
AdventureWorksDW, AdventureWorksDW2008) to the same backup device 
(file). I would like to add all these databases to the same device. I 
have the following t-sql to accomplish this:

BACKUP DATABASE [AdventureWorks] TO  [AW_BKP_DEVICE]
WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorks-Full Database Backup',
SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10
GO


BACKUP DATABASE [AdventureWorksDW] TO  [AW_BKP_DEVICE]
WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorksDW-Full Database Backup',
SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10
GO


BACKUP DATABASE [AdventureWorksDW2008] TO  [AW_BKP_DEVICE]
WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorksDW2008-Full Database 
Backup',
SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10
GO

Now i would like to see the contents of the backup device and to restore 
any of these databases. How can accomplish this?

Thank you

Zaur
Under Server Objects folder take a look into Backup Devices folder


"Zaur Bahramov" <zbakhramov@msn.com> wrote in message 
news:uA1JagigKHA.5792@TK2MSFTNGP05.phx.gbl...
> Hi!
>
> I am trying to backup several databases (AdventureWorks, AdventureWorksDW, 
> AdventureWorksDW2008) to the same backup device (file). I would like to 
> add all these databases to the same device. I have the following t-sql to 
> accomplish this:
>
> BACKUP DATABASE [AdventureWorks] TO  [AW_BKP_DEVICE]
> WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorks-Full Database Backup',
> SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10
> GO
>
>
> BACKUP DATABASE [AdventureWorksDW] TO  [AW_BKP_DEVICE]
> WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorksDW-Full Database Backup',
> SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10
> GO
>
>
> BACKUP DATABASE [AdventureWorksDW2008] TO  [AW_BKP_DEVICE]
> WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorksDW2008-Full Database 
> Backup',
> SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10
> GO
>
> Now i would like to see the contents of the backup device and to restore 
> any of these databases. How can accomplish this?
>
> Thank you 

I see the backup device, which I created earlier "AW_BKP_DEVICE". What I 
would like to do (and unerdstand), how to backup several databases to 
this device and restore a single database, and how to show contents of 
the backup device. When I use RESTORE VERYFYONLY I see only two files:

D:\SQLSrv\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks_Data.mdf
D:\SQLSrv\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks_Log.ldf


After backing up I was expecting to be able to see the content of the 
device, i.e. which databases are there and be able to restore each 
single database.



Uri Dimant wrote:
> Zaur
> Under Server Objects folder take a look into Backup Devices folder
> 
> 
> "Zaur Bahramov" <zbakhramov@msn.com> wrote in message 
> news:uA1JagigKHA.5792@TK2MSFTNGP05.phx.gbl...
>> Hi!
>>
>> I am trying to backup several databases (AdventureWorks, AdventureWorksDW, 
>> AdventureWorksDW2008) to the same backup device (file). I would like to 
>> add all these databases to the same device. I have the following t-sql to 
>> accomplish this:
>>
>> BACKUP DATABASE [AdventureWorks] TO  [AW_BKP_DEVICE]
>> WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorks-Full Database Backup',
>> SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10
>> GO
>>
>>
>> BACKUP DATABASE [AdventureWorksDW] TO  [AW_BKP_DEVICE]
>> WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorksDW-Full Database Backup',
>> SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10
>> GO
>>
>>
>> BACKUP DATABASE [AdventureWorksDW2008] TO  [AW_BKP_DEVICE]
>> WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorksDW2008-Full Database 
>> Backup',
>> SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10
>> GO
>>
>> Now i would like to see the contents of the backup device and to restore 
>> any of these databases. How can accomplish this?
>>
>> Thank you 
> 
> 

Z,B
Take a look at RESTORE HEADERONLY  command




"Z.B." <"zbakhramov["@]msn.com> wrote in message 
news:OKSVn0jgKHA.3552@TK2MSFTNGP06.phx.gbl...
>I see the backup device, which I created earlier "AW_BKP_DEVICE". What I 
>would like to do (and unerdstand), how to backup several databases to this 
>device and restore a single database, and how to show contents of the 
>backup device. When I use RESTORE VERYFYONLY I see only two files:
>
> D:\SQLSrv\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks_Data.mdf
> D:\SQLSrv\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks_Log.ldf
>
>
> After backing up I was expecting to be able to see the content of the 
> device, i.e. which databases are there and be able to restore each single 
> database.
>
>
>
> Uri Dimant wrote:
>> Zaur
>> Under Server Objects folder take a look into Backup Devices folder
>>
>>
>> "Zaur Bahramov" <zbakhramov@msn.com> wrote in message 
>> news:uA1JagigKHA.5792@TK2MSFTNGP05.phx.gbl...
>>> Hi!
>>>
>>> I am trying to backup several databases (AdventureWorks, 
>>> AdventureWorksDW, AdventureWorksDW2008) to the same backup device 
>>> (file). I would like to add all these databases to the same device. I 
>>> have the following t-sql to accomplish this:
>>>
>>> BACKUP DATABASE [AdventureWorks] TO  [AW_BKP_DEVICE]
>>> WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorks-Full Database Backup',
>>> SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10
>>> GO
>>>
>>>
>>> BACKUP DATABASE [AdventureWorksDW] TO  [AW_BKP_DEVICE]
>>> WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorksDW-Full Database Backup',
>>> SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10
>>> GO
>>>
>>>
>>> BACKUP DATABASE [AdventureWorksDW2008] TO  [AW_BKP_DEVICE]
>>> WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorksDW2008-Full Database 
>>> Backup',
>>> SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10
>>> GO
>>>
>>> Now i would like to see the contents of the backup device and to restore 
>>> any of these databases. How can accomplish this?
>>>
>>> Thank you
>> 

Thanks Uri,

RESTORE HEADERONLY is what I was looking for.




Uri Dimant wrote:
> Z,B
> Take a look at RESTORE HEADERONLY  command
> 
> 
> 
> 
> "Z.B." <"zbakhramov["@]msn.com> wrote in message 
> news:OKSVn0jgKHA.3552@TK2MSFTNGP06.phx.gbl...
>> I see the backup device, which I created earlier "AW_BKP_DEVICE". What I 
>> would like to do (and unerdstand), how to backup several databases to this 
>> device and restore a single database, and how to show contents of the 
>> backup device. When I use RESTORE VERYFYONLY I see only two files:
>>
>> D:\SQLSrv\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks_Data.mdf
>> D:\SQLSrv\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks_Log.ldf
>>
>>
>> After backing up I was expecting to be able to see the content of the 
>> device, i.e. which databases are there and be able to restore each single 
>> database.
>>
>>
>>
>> Uri Dimant wrote:
>>> Zaur
>>> Under Server Objects folder take a look into Backup Devices folder
>>>
>>>
>>> "Zaur Bahramov" <zbakhramov@msn.com> wrote in message 
>>> news:uA1JagigKHA.5792@TK2MSFTNGP05.phx.gbl...
>>>> Hi!
>>>>
>>>> I am trying to backup several databases (AdventureWorks, 
>>>> AdventureWorksDW, AdventureWorksDW2008) to the same backup device 
>>>> (file). I would like to add all these databases to the same device. I 
>>>> have the following t-sql to accomplish this:
>>>>
>>>> BACKUP DATABASE [AdventureWorks] TO  [AW_BKP_DEVICE]
>>>> WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorks-Full Database Backup',
>>>> SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10
>>>> GO
>>>>
>>>>
>>>> BACKUP DATABASE [AdventureWorksDW] TO  [AW_BKP_DEVICE]
>>>> WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorksDW-Full Database Backup',
>>>> SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10
>>>> GO
>>>>
>>>>
>>>> BACKUP DATABASE [AdventureWorksDW2008] TO  [AW_BKP_DEVICE]
>>>> WITH NOFORMAT, NOINIT,  NAME = N'AdventureWorksDW2008-Full Database 
>>>> Backup',
>>>> SKIP, NOREWIND, NOUNLOAD, COMPRESSION,  STATS = 10
>>>> GO
>>>>
>>>> Now i would like to see the contents of the backup device and to restore 
>>>> any of these databases. How can accomplish this?
>>>>
>>>> Thank you
>