Re: Offline backup

Article View: bit.databases.mssql-l

Article #153

Back to bit.databases.mssql-l Previous Next

#153

From: Greg D. Moore (Strider)
Date: Tue, 20 Feb 2001 14:44

31 lines
2044 bytes

"Xavier S. Lescalier" <xlescalier@euromold.alcatelDOTcom> wrote in message
news:96thlo$bhm$1@bt02e2.god.bel.alcatel.be...
> Hi,
>
> I stop every night my SQL Server (6.5) service via a "net stop" command
> before the backup software runs.
>
> I've heard that an offline backup is unusable in case you need to restore
> your database. Is that true ?

    Generally not.  In theory this is a perfectly fine method of backup.
(and in fact has some distinct advantages.)

    However, TEST it first.

And read:

http://www.mssqlserver.com/backup/


>
> I know that buying a backup agent would be a better solution, but is an
> offline backup really so bad ?
>
> Regards,
>
>
> Xavier Lescalier.
>
>

Technical Details

Message-ID: <9pvk6.98550$v.7910976@typhoon.nyroc.rr.com>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!cyclone-sf.pbi.net!63.208.208.143!feed2.onemain.com!feed1.onemain.com!news-out.cwix.com!newsfeed.cwix.com!feed2.news.rcn.net!rcn!dca1-feed1.news.digex.net!intermedia!newsfeed.skycache.com!Cidera!cyclone-0.nyroc.rr.com!cyclone-out.nyroc.rr.com!typhoon.nyroc.rr.com.POSTED!not-for-mail

References: <96thlo$bhm$1@bt02e2.god.bel.alcatel.be>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,184638b653a9088f
X-Google-Attributes: gidf6611,public
X-Google-Thread: 104de1,184638b653a9088f
X-Google-Attributes: gid104de1,public
X-Google-ArrivalTime: 2001-02-20 06:47:30 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!cyclone-sf.pbi.net!63.208.208.143!feed2.onemain.com!feed1.onemain.com!news-out.cwix.com!newsfeed.cwix.com!feed2.news.rcn.net!rcn!dca1-feed1.news.digex.net!intermedia!newsfeed.skycache.com!Cidera!cyclone-0.nyroc.rr.com!cyclone-out.nyroc.rr.com!typhoon.nyroc.rr.com.POSTED!not-for-mail
From: "Greg D. Moore \(Strider\)" <mooregr@greenms.com>
Newsgroups: bit.databases.mssql-l,comp.databases.ms-sqlserver
References: <96thlo$bhm$1@bt02e2.god.bel.alcatel.be>
Subject: Re: Offline backup
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <9pvk6.98550$v.7910976@typhoon.nyroc.rr.com>
Date: Tue, 20 Feb 2001 14:44:21 GMT
NNTP-Posting-Host: 24.161.40.63
X-Complaints-To: abuse@nycap.rr.com
X-Trace: typhoon.nyroc.rr.com 982680261 24.161.40.63 (Tue, 20 Feb 2001 09:44:21 EST)
NNTP-Posting-Date: Tue, 20 Feb 2001 09:44:21 EST
Organization: Time Warner Road Runner - Albany NY

Reply to Parent Message