Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Moving Sql2000 DB to Different Location

    The backup was thru the Gui. We used full backup and took all the defaults.

    Restore is :

    RESTORE DATABASE ARSystem FROM DISK='C:\REMEDY-DB\ARSystem_db_200702022300.BAK'

    WITH MOVE 'ARSystem' to 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\ARSystem.mdf',

    MOVE 'ARSystem_log' to...

  • RE: Moving Sql2000 DB to Different Location

    Thanks again MohammedU.

    I did do a full backup with no errors.

    I got the error "..is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable."" ...

  • RE: Moving Sql2000 DB to Different Location

    Thanks very much Veteran and MohammedU.

    Why do you think the backup was no good? I didn't receive any errors on it.

    My problem is with the restore.

    Zeek

Viewing 3 posts - 1 through 3 (of 3 total)