How to back up
-
I would like to know the easiest way to back up (or copy) my data. I am now seeing how important this issue is because the other day i was working on a datagrid and while tring to design the right query, i made on little hickup and all the data that i had in that table turned into a copy of the insert that i had just made. Long story short with the click of a mouse all the data in the table looked the same, i think i did something like, where ProductID = @IDProduct, instead of WHERE CompanyID = @IDCompany, I can not remember.
What would be a easey way for me to copy the entire database to my harddrive every day? "I am still in the development stage; however, i can see that it is taking along time just to get the data into the database, i would FREAK if i was to do that to my Product table, because it is already stacking up.
Thanks,
Erik...
Dam again!
-
Just performing nightly backups on your database should help.
But if for example you have a table with Static data that you want to preserve, then you can use BCP to export all of the data out to a flat file, and save that to disk. Then on your release to production you can easily use that Flat file to BCP your data into the production server.
There are a few things you can do, but the solution depends on how much data were talking about.
If it is a few thousand rows, then keeping a tsql script with the insert statements is acceptable, if were talking few Hundred thousand rows or more than BCP the data out is the way to go.
Or you can create DTS Package to export data to another database.
It all depends
-
Ray has good advice with the nightly db backup. It's simple and easy. If you want to just grab one table, I'd run a quick DTS pacakge to export to Excel or something that I Can pull back with DTS if needed.
-
Thank you.
I fall into the under 2000 rows so I will look into the tsql and do that this evening.
Thanks,
Erik....
Dam again!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply