2 Replies - 1187 Views - Last Post: 14 November 2007 - 02:11 AM Rate Topic: -----

#1 muddasir  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 8
  • View blog
  • Posts: 114
  • Joined: 14-January 07

SQL Server 2000 ?

Posted 13 November 2007 - 11:32 AM

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
Is This A Good Question/Topic? 0
  • +

Replies To: SQL Server 2000 ?

#2 Martyr2  Icon User is offline

  • Programming Theoretician
  • member icon

Reputation: 4354
  • View blog
  • Posts: 12,160
  • Joined: 18-April 07

Re: SQL Server 2000 ?

Posted 13 November 2007 - 12:05 PM

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!" :snap:
Was This Post Helpful? 0
  • +
  • -

#3 muddasir  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 8
  • View blog
  • Posts: 114
  • Joined: 14-January 07

Re: SQL Server 2000 ?

Posted 14 November 2007 - 02:11 AM

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





View PostMartyr2, 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!" :snap:

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1