Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2009
    Posts
    20

    Unanswered: SQL Server Backup Databases

    Hi
    I wanna ask something for backups in sql server 2005...
    I made a database with name Bookstore
    Now when i try to make backup for the database it brings me this message

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------


    System.Data.SqlClient.SqlError: The filename '\BooksStore.bak' is invalid as a backup device name. Reissue the BACKUP statement with a valid filename. (Microsoft.SqlServer.Smo)
    -----------------------------------------------

    So what i have to do now??? Change the name of backup????

    I also wanna ask because i am new is there any wizard like sql server 2000 to make something like backup...???

  2. #2
    Join Date
    Mar 2009
    Posts
    20

    SQL Server 2005 Task shrink

    Can you suggest me any site for sql server tutorials????

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    What operating system is installed on the machine that is running SQL 2005? What Windows Login are you using for the SQL 2005 Windows service?

    -PatP

  4. #4
    Join Date
    Apr 2008
    Location
    Along the shores of Lake Michigan
    Posts
    242
    And, if this is how you actually qualified the path name "\BooksStore.bak", it isn't a valid destination string. Something like 'e:\validpath\BooksStore.bak' should work without issue (or if going over the network- even though that is consider a bad practice, something like '\\servername\validpath\BooksStore.bak').

    Edit - If going over the network, be sure permissions are set appropriately.

  5. #5
    Join Date
    Mar 2009
    Posts
    20
    My problem is that i cant change the path.... Where i will change it.... In the backup window i cant change it, its already fixed i can only remove it...

  6. #6
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Drop and recreate the backup device. Look under Server Objects -> Backup Devices.

  7. #7
    Join Date
    Apr 2008
    Location
    Along the shores of Lake Michigan
    Posts
    242
    Or if it's not a backup device but through the GUI (in my case I'm using EM), "remove" the destination and "add" a new one with the correct path.

  8. #8
    Join Date
    Mar 2009
    Posts
    20
    Ok i find that but still and i cant change the path there but how i will make tha backup now... When i make a new device backup i can change the destination so i can put c:\....... but how i will use that device??????
    When i come back to my database the destination cant change so i can puct (c:\.....

  9. #9
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    use a file

    backup database databasename to disk=N'C:\path\Backup.Bak' with init, stats=10

  10. #10
    Join Date
    Apr 2008
    Location
    Along the shores of Lake Michigan
    Posts
    242
    Quote Originally Posted by ThomasKain24
    Ok i find that but still and i cant change the path there but how i will make tha backup now... When i make a new device backup i can change the destination so i can put c:\....... but how i will use that device??????
    When i come back to my database the destination cant change so i can puct (c:\.....
    Don't use a device, simply backup to a file on a designated (valid) path. BOL has some examples of TSQL code you can use or right click on the database and select backup database or use a maintenance plan. Seems to me you're overthinking this process a bit. Take a deep breath and start fresh - it's not that complicated. Take screen shots or detail exactly what you are doing and where it is failing (detail is the key word here).


    Quote Originally Posted by ThomasKain24
    so i can puct (c:\.....
    ???? I have never "puct" as far as I know

Posting Permissions

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