Hi all,
My window xp pro suddenly cannot reboot any more.
luckily, I can get into safe mode with command prompt.
So before doing any repair or even reinstallation of the op.
I need to back up my database using transact-sql in order to restore later on completely if have to reinstall my OP system.
I have MSDE installed on my computer. so osql.exe is available
for me to back up the database. I did before with the backup command, but it's a while ago. since this time the backup is so precious to me. I want you guys to back me up.
I will go to osql dir in C:\program files\microsoft SQL server\...
then issue:
backup database CMCTIS to disk='D:\sqlbackup\cmcbackup.dat'

CMCTIS is the database name and d:\sqlbackup\cmcbackup.dat is the file I want to use later on
to restore. Since if I will probably do repair or reinstallation, the information on C: will be wiped out or damaged. that's why I will use D: drive for the backup.
Please confirm.

So later on I can restore database completely including data and store procedures, database changes, right?
I have several databases and two server instances. I have to back up database one by one right?

Please reply at your earliest convenience. Otherwise I will lose all three month database work.

Betty