[muddasir]

well
i am using sql server 2000 and vb6, when i want
to make a backup of my database i have open enterprize manager and then go to my database , and then click on backup database .
now my question is there any other way to make
a database backup in sql server.
thanks

[Martyr2]

Yeah you can go the SQL Enterprise Manager >> Your SQL machine >> Management >> Backup or you could go through Database Maintenance Plan and schedule backing up automatically on a scheduled time. This will put jobs into your SQL Agent section for optimizing and backing up databases/transaction logs and even run custom stored procedures like archiving.

Hopefully that answers your question.

"At DIC we be SQL Server 2000 coding DBAs... and ninjas!"

[muddasir]

would you please tell me the how to make custome stored procedure throug which i where ever run
that stored procedure will make backup of my databasae in the location where i want it to make
i have seared and try it a lot but find nothing
to solve ,
backup
thanks

Martyr2, on 13 Nov, 2007 - 12:05 PM, said:

Yeah you can go the SQL Enterprise Manager >> Your SQL machine >> Management >> Backup or you could go through Database Maintenance Plan and schedule backing up automatically on a scheduled time. This will put jobs into your SQL Agent section for optimizing and backing up databases/transaction logs and even run custom stored procedures like archiving.

Hopefully that answers your question.

"At DIC we be SQL Server 2000 coding DBAs... and ninjas!"