NTWH
SSC Rookie
Points: 32
More actions
June 12, 2003 at 2:14 pm
#64861
Have had MSDE installed, new to me! Have been requested to do a backup of the database to Email, to our software supplier.
Does anyone know how to do this?
tonymend
Old Hand
Points: 319
June 12, 2003 at 2:18 pm
#461144
right click on the database and go to all tasks, then backup db
Allen Cui-55137
SSC Guru
Points: 51650
June 12, 2003 at 2:24 pm
#461146
From DOS.
C:\OSQL.exe -Syourservername -E
Once you login to SQL Server, Run following statemnet.
>backup database yourdbname to disk = 'c:\temp\yourdbname_date.bak'
June 12, 2003 at 2:26 pm
#461148
sorry,
I forgot MSDE does not have a SQL interface
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply