Welcome to Sign in | Help
in Search

restore from .bak file

Last post 03-04-2009, 3:49 AM by xmldeveloper. 1 replies.
Sort Posts: Previous Next
  •  03-04-2009, 12:56 AM 6860

    restore from .bak file

    Am facut restore la o baza de date pe serverul meu local de sql, 2005. Insa, daca ma conectez la un alt server de pe internet si vreau sa fac restore si acolo, cu acelasi fisier .bak, imi spune : " C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup
    Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists. 

    If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box."

    Am incercat sa il fac share, sa il map-ez. Nimic.:(

    Daca ii scriu din cod ,imi da eroare

    RESTORE DATABASE is terminating abnormally.

    Daca stie cineva, va rog mult sa postati ! Multumesc !

     

     

  •  03-04-2009, 3:49 AM 6861 in reply to 6860

    Re: restore from .bak file

    Cand faceti restore aveti optiunea sa specificati noua cale a fisierelor de date si a transaction log-ului.
    Puteti specifica o noua locatie atat din SSMS cat si din T-SQL (verificati sintaxa RESTORE DATABASE in Books Online).

    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems