Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Beginner needs help: Backup and Restore DB

    Try this:

    USE MASTER

    BACKUP DATABASE Northwind

    TO DISK = 'd:\backup\Northwind.bak'

    RESTORE DATABASE TestDB

    FROM DISK = 'd:\backup\Northwind.bak'

    WITH MOVE 'Northwind' TO 'd:\test\testdb.mdf',

    ...

Viewing post 1 (of 2 total)