<tsgd84@gmail.com> wrote in message
news:1159866125.489126.65840@h48g2000cwc.googlegroups.com...
> hi..,
>
> Thanks for ur reply,
> But what i am trying to do is to backup an ordinary database of mssql
> server using snapshot
> command appended with backup database query.
> For example, Backup Database 'pubs' to
> Virtual_device='0830-e397-3987-u3k8' with snapshot.
>
> Thanx in advance
> regards
> deena
>
>
> Uri Dimant wrote:
>> Hi
>> You cannot BACKUP snapshot database. BOL has pretty good explanation
>> about
>> shpashots and its purpose
>>
>>
>>
>>
>> <tsgd84@gmail.com> wrote in message
>> news:1159851202.368579.188330@m7g2000cwm.googlegroups.com...
>> > hi everybody,
>> >
>> > I was writing an app to get snapshot backup of mssql server databases
>> > using VDI interface,
>> > VDC_Snapshot command was successfully issued by the interface(database
>> > was in frozen state),
>> > then I was trying to read the .mdf and .ldf files in the data folder of
>> > the mssql server installation location, but I could not get the handles
>> > to read .mdf and .ldf files. They were returned with negative value if
>> > i try to open an handle for reading the database and log files.
>> > (OR)
>> > After VDC_Snapshot was issued how should i copy the mdf and ldf files
>> > or how to take the snapshot backup.
>> >
>> > Any suggestions on this will be highly appreciated,
>> >
>> > Thanks and regards
>> > deena
>> >
>

Roger Wolter[MSFT] wrote:
> I think what's confusing us is that there isn't a snapshot option in the
> backup command. Perhaps if you told us what you're trying to do it would
> help us understand what you need.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> <tsgd84@gmail.com> wrote in message
> news:1159866125.489126.65840@h48g2000cwc.googlegroups.com...
> > hi..,
> >
> > Thanks for ur reply,
> > But what i am trying to do is to backup an ordinary database of mssql
> > server using snapshot
> > command appended with backup database query.
> > For example, Backup Database 'pubs' to
> > Virtual_device='0830-e397-3987-u3k8' with snapshot.
> >
> > Thanx in advance
> > regards
> > deena
> >
> >
> > Uri Dimant wrote:
> >> Hi
> >> You cannot BACKUP snapshot database. BOL has pretty good explanation
> >> about
> >> shpashots and its purpose
> >>
> >>
> >>
> >>
> >> <tsgd84@gmail.com> wrote in message
> >> news:1159851202.368579.188330@m7g2000cwm.googlegroups.com...
> >> > hi everybody,
> >> >
> >> > I was writing an app to get snapshot backup of mssql server databases
> >> > using VDI interface,
> >> > VDC_Snapshot command was successfully issued by the interface(database
> >> > was in frozen state),
> >> > then I was trying to read the .mdf and .ldf files in the data folder of
> >> > the mssql server installation location, but I could not get the handles
> >> > to read .mdf and .ldf files. They were returned with negative value if
> >> > i try to open an handle for reading the database and log files.
> >> > (OR)
> >> > After VDC_Snapshot was issued how should i copy the mdf and ldf files
> >> > or how to take the snapshot backup.
> >> >
> >> > Any suggestions on this will be highly appreciated,
> >> >
> >> > Thanks and regards
> >> > deena
> >> >
> >