Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Restoring database from another server

    you can run this command without creating new database

    RESTORE DATABASE testdb

    FROM DISK=' 'c:\sqlbackups\testdb.bak'

    WITH MOVE 'testdb_Data'

    TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\testdb.mdf',

    MOVE 'testdb_Log '

    TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\testdb_log.ldf'

Viewing post 1 (of 1 total)