SQL backup questions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: pohkeat (pohkeat_at_hotmail.com)
Date: 04/19/04 

Date: Tue, 20 Apr 2004 00:27:04 +0800

got a list of backup questions re SQL2000 (on W2K Svr), any advice,comments
welcome

1) Backing & restore a DB on another svr will not include logins, scheduled
jobs, is there anything else ?

2) Copy DB however will include the whole lot ?

3) If so , for the purpose of easier restore can we scheduled running COPY
DB wizard every night, instead of a SQL backup job ? is it b'coz COPY DB
will produce a larger file compared to SQL bak file ?

4) If a DB is set toFULL recovery model, a common problem is it will result
in really huge ldf file. must we live with it or is there a workaround ,
other then setting it to SIMPLE model. Once a FULL backup is made, can we
safely truncate the ldf so as to shrink the log file.

5) Does this Backup Strategey make sense : Full DB Bckup nightly, and hourly
LDF backup. Consider the DB is of fairly critical nature. Reason why I dun
use differential back up nightly is because I realized there is no drastic
difference in the bak file size between Differential and Full Backup.

TIA
pk

Relevant Pages

  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • Re: [opensuse] About Backing Up
    ... there is a data failure we can restore. ... the restoration is to get the backup file that we first complete as it ... failure, physical destruction, or it has been half inched. ... Other data should be archived to media. ...
    (SuSE)
  • Re: Exchange in Recovery Mode
    ... On the backup SBS server, did you restore Mailbox Store from backup ... After Mailbox Store was restored, ... Create a Recovery Storage Group. ... Restore the backup to Recovery Storage Group with NTbackup. ...
    (microsoft.public.windows.server.sbs)
  • Re: Computer problem, need help
    ... >>> defining the three levels of backup and recovery. ... >>> has been corrupted, use backup and restore. ... >>hard drives and a reliable backup utility like Ghost. ... doesn't work I use my preferred backup utility, ...
    (soc.retirement)
  • Re: RAID, SCHMAID.......
    ... And risky to change it later without a full image backup. ... partition, & then restore only the OS, but still verydoable. ... partition before an install of something you havent installed before, ... but so many ppl make a mess of things esp with today's big drives. ...
    (comp.sys.ibm.pc.hardware.storage)