Results 1 to 3 of 3

Thread: Backup Database

  1. #1
    Join Date
    Jun 2010
    Posts
    1

    Question Backup Database

    i am trying to backup a database but couldn't find any solution to it the last tecnique i used was that i made a procedure in which i write

    BACKUP DATABASE database name
    TO DISK ='E:/database.bak'

    But i got the following Exception/Error

    "Could not locate entry in sysdatabases for database 'DB_1'. No entry found with that name. Make sure that the name is entered correctly.
    BACKUP DATABASE is terminating abnormally."

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Sounds db name is not correct.

  3. #3
    Join Date
    Jun 2011
    Posts
    3

    Syntax Error

    It seems you have 2 syntax errors:
    - If your database has spaces in the name try using [Database Name].
    - You're using a slash instead of a backslash in the file path.

    If your backup is not too complex you could try this tool SQL Backup and FTP

Posting Permissions

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