Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2010
    Posts
    39

    Unanswered: Help with Backup Procedure Step

    I am trying to create a backup job for sql database.

    BACKUP DATABASE msdb TO DISK = ''c:\msdb.log_bak'

    But when I have to backup database 'Lytec Tutorial', How do specify it's name instead of 'msdb' ?
    Because SQL gives error when enter the name with spaces. I also trid putting underscore and qoutes.

    Is there any other way?

  2. #2
    Join Date
    Jul 2010
    Posts
    39

    Answer

    I think I got it.
    You specify the name inside [Lytec Tutorial]

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Man, and you're planning to support MR system by venue of this forum? Did you tell your management that this is your source of knowledge?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Jul 2010
    Posts
    39
    What do you mean, is this wrong or wat ?

Posting Permissions

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