2 Replies - 1549 Views - Last Post: 01 November 2009 - 07:14 PM Rate Topic: -----

#1 xoops  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 81
  • Joined: 06-August 09

syntax query for backup database for one month in sql server 2000

Posted 01 November 2009 - 06:20 PM

hi,

how the way backup database in sql server 2000 with syntax sql, i mean query. Thank's
Is This A Good Question/Topic? 0
  • +

Replies To: syntax query for backup database for one month in sql server 2000

#2 Martyr2  Icon User is offline

  • Programming Theoretician
  • member icon

Reputation: 4188
  • View blog
  • Posts: 11,857
  • Joined: 18-April 07

Re: syntax query for backup database for one month in sql server 2000

Posted 01 November 2009 - 07:06 PM

Use the BACKUP DATABASE query syntax...

BACKUP DATABASE MyDB
TO DISK = 'D:\backups\mydb.bak'



Here we are backing up the database "MyDB" to disk on the D:\ drive as mydb.bak. This syntax also has many options that you can add in as well. Plus you can backup to various types of devices including TAPE. Again, lookup the syntax for more information.

:)
Was This Post Helpful? 0
  • +
  • -

#3 xoops  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 81
  • Joined: 06-August 09

Re: syntax query for backup database for one month in sql server 2000

Posted 01 November 2009 - 07:14 PM

View PostMartyr2, on 1 Nov, 2009 - 06:06 PM, said:

Use the BACKUP DATABASE query syntax...

BACKUP DATABASE MyDB
TO DISK = 'D:\backups\mydb.bak'



Here we are backing up the database "MyDB" to disk on the D:\ drive as mydb.bak. This syntax also has many options that you can add in as well. Plus you can backup to various types of devices including TAPE. Again, lookup the syntax for more information.

:)



i want to backup database only one month not all month, example: October. How can i do that
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1