Offline backup

Article View: bit.databases.mssql-l

Article #152

Back to bit.databases.mssql-l Previous Next

#152

From: Xavier S. Lescalier
Date: Tue, 20 Feb 2001 10:41

15 lines
1537 bytes

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 ?

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: <96thlo$bhm$1@bt02e2.god.bel.alcatel.be>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.stanford.edu!skynet.be!news.tele.dk!134.222.94.5!npeer.kpnqwest.net!news.bel.alcatel.be!news.bel.alcatel.be!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,184638b653a9088f,start
X-Google-Attributes: gidf6611,public
X-Google-Thread: 104de1,184638b653a9088f,start
X-Google-Attributes: gid104de1,public
X-Google-ArrivalTime: 2001-02-20 03:01:05 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.stanford.edu!skynet.be!news.tele.dk!134.222.94.5!npeer.kpnqwest.net!news.bel.alcatel.be!news.bel.alcatel.be!not-for-mail
From: "Xavier S. Lescalier" <xlescalier@euromold.alcatelDOTcom>
Newsgroups: bit.databases.mssql-l,comp.databases.ms-sqlserver
Subject: Offline backup
Date: Tue, 20 Feb 2001 11:41:36 +0100
Organization: Alcatel
Lines: 17
Message-ID: <96thlo$bhm$1@bt02e2.god.bel.alcatel.be>
Reply-To: "Xavier S. Lescalier" <xlescalier@euromold.alcatelDOTcom>
NNTP-Posting-Host: 172.31.253.5
X-Trace: bt02e2.god.bel.alcatel.be 982665720 11830 172.31.253.5 (20 Feb 2001 10:42:00 GMT)
X-Complaints-To: usenet@news.bel.alcatel.be
NNTP-Posting-Date: 20 Feb 2001 10:42:00 GMT
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