+ Post New Thread
Results 1 to 5 of 5
Windows Thread, Backing up SQL database ? in Technical; Can some one point me to a idiots guide of backing up a SQL database. That is always running. Or ...
  1. #1
    Kyle's Avatar
    Join Date
    Jan 2006
    Posts
    983
    Thank Post
    92
    Thanked 14 Times in 13 Posts
    Rep Power
    21

    Backing up SQL database ?

    Can some one point me to a idiots guide of backing up a SQL database. That is always running.

    Or give me a idiots guide here.

  2. #2

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Backing up SQL database ?

    It depends what the application youre using the database for.

    Most big name backup programs have an SQL module/agent for Microsoft SQL Server 2000

    If you're using the SQL Server for SIMS.net then you should use the backup option in System Manager or the command line utitility dbAttach.exe

  3. #3
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42

    Re: Backing up SQL database ?

    We use Veritas to backup everything here, which is capable of backing up a live sql database. If you dont want to use 3rd party software to do it or follow Geezers suggestions then a rough way to do it is to have a batch script stop the service, backup the relavant files and start the service.

  4. #4

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,592
    Thank Post
    109
    Thanked 770 Times in 598 Posts
    Rep Power
    183

    Re: Backing up SQL database ?

    You can always just use the 'Backup' command in Enterprise Manager to back it up. Run it on a schedule and dump it off to somewhere. This is the cheapest option by far.

    Otherwise, you're looking at a couple of hundred quid for your backup program's SQL agent.

  5. #5
    Kyle's Avatar
    Join Date
    Jan 2006
    Posts
    983
    Thank Post
    92
    Thanked 14 Times in 13 Posts
    Rep Power
    21

    Re: Backing up SQL database ?

    So what would be the correct way of backing up CMIS

SHARE:
+ Post New Thread

Similar Threads

  1. backing up
    By gwendes in forum How do you do....it?
    Replies: 7
    Last Post: 13th November 2007, 09:06 AM
  2. Replies: 4
    Last Post: 28th February 2007, 09:37 AM
  3. Backing Up System State
    By mrforgetful in forum Windows
    Replies: 27
    Last Post: 11th January 2007, 02:04 PM
  4. Backing up MSDE (WMSDE for WSS) database with BackupExec
    By meastaugh1 in forum How do you do....it?
    Replies: 13
    Last Post: 23rd July 2006, 01:56 PM
  5. Mac software for backing up DVDs
    By dagza in forum Mac
    Replies: 14
    Last Post: 23rd May 2006, 11:29 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •