Results 1 to 8 of 8

Thread: Backup database

  1. #1
    Join Date
    Nov 2003
    Posts
    68

    Unanswered: Backup database

    Hello,
    I want to know how you backup your databases because i have the following problem :

    I am doing a backup every day with 1 days of retention, but i haven't got any places on my server.
    How can i put the backup on another server ( SAN for instance) ?

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by philio
    Hello,
    I want to know how you backup your databases because i have the following problem :

    I am doing a backup every day with 1 days of retention, but i haven't got any places on my server.
    How can i put the backup on another server ( SAN for instance) ?
    If I understand your question correctly, you have run out of space to store backups on your database server. You are trying to figure out a way to write the backups to a network device (such as Network Attached Storage (NAS) or another server).

    Correct?

    If so, you can use UNC naming conventions to write the backups to another network device. Such as: \\MyServer\MyShare\SQL_BACKUPS.

    Regards,
    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Note the big IF in the next sentence.

    IF you start the Windows Service that runs Microsoft SQL Server using a domain account (instead of localsystem), then you can backup to any UNC filename that that domain account can access.

    -PatP

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by Pat Phelan
    Note the big IF in the next sentence.

    IF you start the Windows Service that runs Microsoft SQL Server using a domain account (instead of localsystem), then you can backup to any UNC filename that that domain account can access.

    -PatP
    [embarrassed look]
    yes; I should have mentioned that
    [/embarrassed look]

    I should note, however, that it may be a bit different with a NAS, depending on the vendor and NAS OS. The only way we could write to our NAS was to map a drive, and then leave the server logged in (with the screen locked).
    Have you hugged your backup today?

  5. #5
    Join Date
    Nov 2003
    Posts
    68
    when i put a unc path to the maintenance plan, there is an error.
    It tells me that this path is invalid.

  6. #6
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by philio
    when i put a unc path to the maintenance plan, there is an error.
    It tells me that this path is invalid.
    It means that:

    1. The UNC path is specified incorrectly (copy and paste from a Explorer address bar to eliminate this possibility.

    2. (More likely) There is a permissions issue as described by Pat. Verify that your SQL Service is running under a DOMAIN account and that the user has permissions to the folder you wish to write to.

    3. (Possibly, if you are using a NAS) If you are using a NAS that is not "domain aware" you may have to do things differently (like mapping a drive).

    Regards,

    hmscott
    Have you hugged your backup today?

  7. #7
    Join Date
    Nov 2003
    Posts
    68

    backup database

    when i doing this i have the following message

    "The backup directory is invalid. Are you sure this is what you want ?"

    How are you doing ?

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Listen, the best advice we should be giving you is to clear off some space, dump to the local drive, zip it, and robocopy the file to another server.

    How big is your database, and how bug is the current drive?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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