Backup questions

From: bagman3rd (bagman3rd_at_discussions.microsoft.com)
Date: 06/01/05 

Date: Wed, 1 Jun 2005 13:58:03 -0700

I was wondering if someone could point me in the right direction and/or give
me a quick breakdown on SQL Server backups. I work in Environmental
Consulting, and all of my databases are geochemical/hydrogeological
databases. None of them are very big(300 megs for all my databases), and the
data rarely changes. I do add data to the databases when it comes in, but I
do have sp's that I am updating/creating on a weekly basis. I really only
need to backup my databases once a week or maybe twice a month, and I have
been shutting down the SQL Service Manager, copying the db files to cd, then
restarting the SQL service. My sys admin wants to use the backup procedure
within SQL Server, but I really dont understand how the restoring works. If
you use the backup procedures within SQL Server, and your physical server
blows up, can you restore the db's on another machine. How does this work?
I really like being able to have two detached database files which can be
re-attached to any machine, but do not understand how to restore the backup
db files, or how this works even. Thanks for you help.

Archer

Relevant Pages

  • Re: Backing Up WSS
    ... Backup and Restore Options for Windows SharePoint Services ... ·Use the Microsoft SQL Server 2000 tools to back up the databases. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Automating SQL Service start and shut down
    ... The best option would be using the Transact-SQL BACKUP command. ... make sure that you know how to restore/recover your data and your databases. ... Grab a tape, restore the files to a different server, and try to get the files restored. ... Moving SQL Server databases to a new location with Detach/Attach ...
    (microsoft.public.sqlserver.setup)
  • Re: Backup questions
    ... You can restore the backup to any other server. ... > me a quick breakdown on SQL Server backups. ... and all of my databases are geochemical/hydrogeological ...
    (microsoft.public.sqlserver.security)
  • Re: Off-Site Duplicate Server Setup
    ... the normal process for databases is backing up the ... backup the backup files to tape/disk/offline/whatever. ... Which is good until restoration when you need to restore the original, ... likely have a live replicated server available. ...
    (microsoft.public.windows.server.general)