Programming Help

Web Development

Projects



What's Here?

  • Members: 99,782
  • Replies: 389,609
  • Topics: 58,611
  • Snippets: 2,047
  • Tutorials: 550
  • Total Online: 1,530
  • Members: 51
  • Guests: 1,479

Who's Online?

Welcome to Dream.In.Code
Getting Help is Easy!

Join 99,782 Programmers for FREE! Ask your question and get quick answers from experts. There are 1,530 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now!



database backup

 
 Reply to this topicStart new topic

database backup
samichol
post 2 May, 2008 - 02:17 AM
Post #1


New D.I.C Head

*
Joined: 2 May, 2008
Posts: 3
I want to back up an SQL 2000 database using vb6 comand.Can anyone write me the code how to do that?
User is offlineProfile CardPM

Go to the top of the page


no2pencil
post 2 May, 2008 - 02:19 AM
Post #2


Wet D.I.C.

Group Icon
Joined: 10 May, 2007
Posts: 4,288



Thanked 15 times

Dream Kudos: 2275

Expert In: Goofing Off

My Contributions
Dream.In.Code has a policy by which we prefer to see a good faith effort on your part before providing source code. Please post the code you have written in an effort to resolve the problem, and our members would be happy to provide some guidance. Be sure to include a description of any errors you are encountering as well.

code.gif
User is online!Profile CardPM

Go to the top of the page

samichol
post 2 May, 2008 - 03:51 AM
Post #3


New D.I.C Head

*
Joined: 2 May, 2008
Posts: 3
QUOTE(no2pencil @ 2 May, 2008 - 02:19 AM) *

Dream.In.Code has a policy by which we prefer to see a good faith effort on your part before providing source code. Please post the code you have written in an effort to resolve the problem, and our members would be happy to provide some guidance. Be sure to include a description of any errors you are encountering as well.

code.gif

I have tried to use the this SQL code on vb commad button

BACKUP DATABASE Stock
TO DISK = 'd:\backups\Stock

and it shows compiler error
User is offlineProfile CardPM

Go to the top of the page

mikeblas
post 4 May, 2008 - 08:11 PM
Post #4


D.I.C Head

**
Joined: 8 Feb, 2008
Posts: 148



Thanked 1 times
My Contributions
You're missing a closing quote in 'd:\backups\Stock'.

What specific error are you getting?
User is offlineProfile CardPM

Go to the top of the page

waqasaptech125
post 8 May, 2008 - 05:00 AM
Post #5


New D.I.C Head

*
Joined: 8 May, 2008
Posts: 1
Backup database master TO disk = C:\
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 7/25/08 01:04AM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month
-->