Unix Technical Forum

Multiple Backup statements for backup multiple databases?

This is a discussion on Multiple Backup statements for backup multiple databases? within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hi I am trying to Backup my SQL server using the VDI (Virtual Device Interface) APIs I have the ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 07:32 PM
Moozar
 
Posts: n/a
Default Multiple Backup statements for backup multiple databases?

Hi I am trying to Backup my SQL server using the VDI
(Virtual Device Interface) APIs I have the capability of
creating and mounting snapshot.
I have already looked at the sample called "snapshot".

As far as It is one DB it is OK, everything goes smoothly.
But when I have more then one database on the same
partition,I need to ensure all the databases are at "Hot
backup state" and flush all the metadata of all the DB in
order to ensure a consistency state.
I have tried almost everything but it seems that nothing
works,
any Idea?
I have tried to create one Virtual device set, and open a
virtual device per DB. The Backup statement is per
database, and when I am trying to run more then one
statement I failed to open the devices. any solution will
be appreciated.
Thanks
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:20 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com