|
| |
|
|
TimC
Posts: 199
From: Greenville SC (& or) Monterrey Mexico
Status: offline
 |
Using DTS to back up SQL DB - 4/15/2002 6:58:25
My provider does not allow any db backups because of security/permissons issues. I re-invented the wheel when I figured out the hard way how to back up by making a blank db on my machine and then use dts export to make a copy - my problem has been in the fact that it seems to loose the unique id/autonumbering feature - once I have done a backup, I have been forced to manually reset the identity property for each field to auto increment - tried custom mapping the id field to guid but that just created a ton of errors. [32 tables, 31 errors - spooky's active user table made the round trip because it has no id field  ) Any one else doing this ?
TimC
"If at first you DO succeed, try not to look astonished!"
|
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Using DTS to back up SQL DB - 4/15/2002 16:22:03
Im in a similar situation with my host, but my thought is that its only a backup. The IDs stored in the access db are correct when compared with the SQL database.
If you ever need to reinstate the data back to SQL, then the ID's will remain the same.
Its easier to convert SQL back to an auto increment field when needed.
The other option is to backup to MSDE on the local machine.
I was going to actively persue an answer earlier, as backups of the forum were taking 2 hrs via satellite. Now Ive got DSL, its only 15 minutes, so I lost the urge :)
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Using DTS to back up SQL DB - 4/15/2002 16:23:59
When you export - do you export to an empty database, or do you create the tables first? Ive always exported to an empty database, its never really caused any errors at all
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
|
|
TimC
Posts: 199
From: Greenville SC (& or) Monterrey Mexico
Status: offline
|
RE: Using DTS to back up SQL DB - 4/15/2002 16:51:44
I was always exporting to a blank database, I named each db based on the date and then burned it to cd for a safetynet. Last night I played with opening each table and setting it to drop original table and recreate a new one. Then I saved the DTS Package up to the server, and set it to run everynight at midnight. Worked too, dangblast it, if it hadn't had all the transform errors on "id" fields. Getting really frustrated with not having level of control I need on this project, I really want to be able to synchronize imported data from a whole lot of small access databases into my sql database. Loading data one record at a time over the internet is ok for a small amount of inventory but if you have a lot to enter, it would be slick to use a normal access form, load everything and then do one upload.
TimC
"If at first you DO succeed, try not to look astonished!"
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
