473,575 Members | 3,390 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Point-in-time backup of database & filesystem

We're considering purchasing an application,
which stores some data in the filesystem, and
some data (meta data and links to files) in
MS-SQL.

We need to be able to create a backup wherein
the database and files are "in synch" (in other words,
in a consistent state). We need to maintain the
"referentia l integrity" between database and files.

What I'm thinking of is something like this:
1. stop the application server
2. set database to readonly (flush updates
from cache to disk)
3. backup database to disk files
4. back up application files and backup files.
(We could use "snapshot" capabilities of our disk
hardware, so that the backup could run against the
snapshot; that would minimize downtime.)
4. set database to read_write; restart app server

Recovery scenario would be:
1. Stop application server.
2. restore application files and database backup files
3. restore database from disk backup
4. restart application server

Is there a simpler way to get a "point in time" backup
of application files and the database?

Jul 20 '05 #1
1 3947
"L. Bertolini" <be*********@os u.edu> wrote in message news:<c2******* ***@charm.magnu s.acs.ohio-state.edu>...
We're considering purchasing an application,
which stores some data in the filesystem, and
some data (meta data and links to files) in
MS-SQL.

We need to be able to create a backup wherein
the database and files are "in synch" (in other words,
in a consistent state). We need to maintain the
"referentia l integrity" between database and files.

What I'm thinking of is something like this:
1. stop the application server
2. set database to readonly (flush updates
from cache to disk)
3. backup database to disk files
4. back up application files and backup files.
(We could use "snapshot" capabilities of our disk
hardware, so that the backup could run against the
snapshot; that would minimize downtime.)
4. set database to read_write; restart app server

Recovery scenario would be:
1. Stop application server.
2. restore application files and database backup files
3. restore database from disk backup
4. restart application server

Is there a simpler way to get a "point in time" backup
of application files and the database?


The first place to ask would be the vendor - find out what their
recommended backup strategy is, and how they say you should recover in
case of failure. If they can't give you a good answer, then you should
make that fact part of your decision.

The snapshot backup might be a good option if you already have the
hardware to support it - you probably wouldn't need to stop the server
at all in that case.

Simon
Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1504
by: Jerry Asher | last post by:
I have a table of points, actually zip codes and their points. If a point is an X, Y pair, how do I extract X from a point? (And how do I create or insert a new point (X, Y)?) I am given a latitude, longitude pair and I would like to determine the closest zipcode. I can do this using point_distance, but I wonder if there is a faster...
3
1974
by: Martin Hart | last post by:
Hi all, PG 7.4 beta4 (not had a chance to upgrade yet :-( how do i cast something of type point to text? db=# select '(1,2)'::point::text; ERROR: cannot cast type point to text db=# select text('(1,2)'::point); ERROR: function text(point) does not exist
24
2218
by: j0mbolar | last post by:
C supports single precision floating point and double precision floating point but does it support fixed floating point? i've read that fixed floating point is more accurate than single precision floating point when dealing with dollars and cents.
21
4194
by: Allin Cottrell | last post by:
OK, I realize that what I am asking here is not likely to have a answer within the C standard. Nonetheless, it is not specific to any particular platform, so I'll hazard the question anyway. A C double can be aliased by an array of unsigned char, to which any desired byte pattern may be written. Is there any somewhat portable way of...
0
1617
by: pallav | last post by:
is anyone aware of a freely-available C fixed point library for unix/linux systems? i remember about 6-7 months ago, i searched the net and located a project (i'm not sure now if it was open source or not) that was developing a Q.16 fixed-point library. i'm searching today and can't locate this project or the source code. if anyone has...
3
3801
by: Action | last post by:
Point is a struct but I can do both Point a; Write(a.X); Write(a.Y); and Point a = new Point(1,1); Write(a.X);
2
6183
by: jerry chapman | last post by:
I have created an Array of Point Arrays. Point myPolygons; myPolygons=new Point; What is the syntax for entering the 30 points into myPolygons?
7
1623
by: venkatesh | last post by:
hai to everybodey, suppose i am using float variable in structure,when i am manupulating them it will not shows the linkage error? but when i am using scanf to read particular variable it shows run time error? how to make explicitly link betwen floating point library and to printf statement?
5
2007
by: pcnerd | last post by:
I want to create a program that will do graphics like math functions & fractals & stuff. I've been browsing thru books at the bookstores. Apparently, the Point object replaced Pset. The books explain how to create a Point object, but not how to use it. I want to be able to plot individual pixels. I tried DrawEllipse, but that just draws...
3
1609
by: roche72 | last post by:
Help. I have a simple floating point calculation and depending on what thread it gets executed on, I get a different result. Here are the pieces of code: class OmniCamera { private float m_PixelSize; private float m_ImageHeight;
0
7775
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8120
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8281
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7868
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
1
5664
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5338
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3778
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1382
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1107
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.