Back up Database

[vichet]

hi all;

i am new to sql server;
now i use Access 2003 and Sql server 2000.
i have serveral question:

1- how do i backup my sql database including my user and other security that
i create with my database?
2- i have seen new feature in access 2003 , BACKUP DATABSE. I want to write
code to use it?


thank for ur help

Vichet

 

[Derrick Leggett]

In the SQL Database, you need to use the command BACKUP DATABASE. The
format can be found in Books Online, which is included free with SQL Server.
Just type in BACKUP DATABASE in the Index tab.

BACKUP DATABASE database_name
TO DISK = '\\share\directory\database_name.bak'
WITH INIT

--That will create a backup for you.