Tuesday, February 14, 2012

backup

i am attempting to move a data base to a new system. when trying to backup
the db i get the following error ' incorrect syntax near keyword 'disk' '
from the following
use master
exec sp_addumpdevice 'disk', 'mydb_1',
disk = 'd:\data\backup\mydb_1.dat'
backup database mydb
Terry,
This is an example from BooksOnLine for sp_addumpdevice:
USE master
EXEC sp_addumpdevice 'disk', 'mydiskdump', 'c:\dump\dump1.bak'
Andrew J. Kelly SQL MVP
"Terry" <cooleyt@.woh.rr.com> wrote in message
news:QA1sd.26481$MG3.10582@.fe2.columbus.rr.com...
>i am attempting to move a data base to a new system. when trying to backup
> the db i get the following error ' incorrect syntax near keyword 'disk' '
> from the following
> use master
> exec sp_addumpdevice 'disk', 'mydb_1',
> disk = 'd:\data\backup\mydb_1.dat'
> backup database mydb
>

No comments:

Post a Comment