2 sql servers pointing to the same DB file... is it a problem?
B.
I have a setup with 2 DB servers (MS-SQL Adv Server 2000) and I'd like
to have one of them be a "hot backup". My idea is to have both servers
pointing to the same .mdf and .ldf files on a drive located on a third
machine (linux with samba). Only one of the servers would be accessed
by the websites. The second server would only make backups of the DB
and be ready in case the first one fails. I'd then switch my
datasources to point to the second server.
I know that some file locking issues can arise when having 2 DB
servers accessing the same data file but what if the second server
only does backups? Are those file locking issues still there?
Is this config a bad idea?
Thanks
Benoit
Greg D. Moore (Strider)
"B." <bmart...@hotmail.com> wrote in message
news:a0a7c5e2.02103...@posting.google.com...
Bad? no.
Will it work? No.
For one thing, you can't locate SQL 2000 db files on a shared drive. It has
to be local. (SQL 7.0 had a flag to override this. AFAIK this is gone in
SQL 2000.)
What you've essentially described is clustering, but it's a lot more
involved than what you described above.
>
> Thanks
>
> Benoit
B.
thank you for your answer.
you are saying that we can't locate db files on a shared drive. Do you
mean that it's a bad idea and it won't work perfectly or do you mean
that it's totally impossible?
I currently have those files on a shared drive and beside some network
errors once in a while, it seems to be working. Is it a config I
should avoid?
Ben
"Greg D. Moore \(Strider\)" <moo...@greenms.com> wrote in message news:<8mlw9.45443$TX.14...@twister.nyroc.rr.com>...
Greg D. Moore (Strider)
> Greg,
>
> thank you for your answer.
>
> you are saying that we can't locate db files on a shared drive. Do you
> mean that it's a bad idea and it won't work perfectly or do you mean
> that it's totally impossible?
"It's impossible" but...
>
> I currently have those files on a shared drive and beside some network
> errors once in a while, it seems to be working. Is it a config I
> should avoid?
you appear to be doing it. I'm curious exactly how you managed to do this.
BP Margolin
The following sounds like it would interest you :-)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304261
BPM
"Greg D. Moore (Strider)" <moo...@greenms.com> wrote in message
news:P4Dw9.53496$c51.15...@twister.nyroc.rr.com...
Greg D. Moore (Strider)
"BP Margolin" <bpm...@attglobal.net> wrote in message
news:3dc34...@news1.prserv.net...
> Greg,
>
> The following sounds like it would interest you :-)
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304261
Right, I was partially aware of that. In my original post which was
clipped I mentioned the support for the flag in 7.0. I had read several
places that 2000 had removed that flag. Apparently not.
Still, as tempting as it is, I think I'll pass on actually doing it. :-)
(Though I do perform my backups to a NAS device. Works well enough for my
needs at this time.)