Help with backupsystem!
-
I have a problem with my sql script. Iam doing a backup script but i dont realy know how to backup of all tabels . My point is that
how i can make a script some wold take one tabeln in row to do a backup in a database and save it to a device
like A: och C: or somewhere. but the size should be defined to exampel 40mb or something. And this backup will take every tabel and do a backup in some scheduled time. SOme like a Archive so i can go back and look what i have don in this day or wich time.
I hope for answer !
Please help me!
-
I'm not quite clear on what you are trying to do here, so let me tell you what it sounds like you are asking for. It sounds to me like you need to a way to periodically backup your database to an archive server.
1. Will you do this on a regular scheduled basis?
2. Does the data need to be accessible on the archive server, or will the archive server just store the backup files?
3. What do you mean by 'take one tableln in row'?
4. What exactly do you mean by 'but the size should be defined to example 40mb or something'?
-
Maybe some of the answers can be found here!
**ASCII stupid question, get a stupid ANSI !!!** -
Yes more like a arc.
Yes i will do this on on a regular scheduled basis
Yes the data MUST to be accessible on the archive server, or will the archive server just store the backup files olso.
The backup will take every tabel in the database to a backup.
The backup will happend automaticly when the files in a size f tex 40 mb..
Thanks for you help guys!
-
OK, so you need to archive off all tables in your database on a regular scheduled basis to a different server where the data will then be available until the next archive, at which point it will be refreshed with the latest data. Have you looked into log shipping? You say that you want to automatically backup your tables when the 'files' reach a certain size. When you say 'files', are you referring to the MDF file? Table Size?
-
Yes exactly. No Iam not refering to MDF file. With tabel size i mean when a backup is on a size wich is defined so i want it to be able to save it to another device
-
John - you'd really be better off following my link to the other post since Hasan has this posted at 3 different forums and kenneth is already addressing this in one of the other ones...will save time for everyone in the long run..
**ASCII stupid question, get a stupid ANSI !!!** -
just realized that nowhere in the link I posted do I mention that this is a cross-post...my apologies..
**ASCII stupid question, get a stupid ANSI !!!** -
Iam sorry for that i dont realy know how this works
-
I think you have 2 seperate issues here. One is that you need a way to look at archived data on a seperate server. Second, you need to save off backups to an alternate media. I would look into log shipping for archiving your data or use BCP as Kenneth has suggested in your other post. You will then need a secondary process that can move your backup files off to CD/DVD/Tape when they reach a certain size.
-
Yeah thats right! But John you could not help me with this?
-
Both the log shipping and BCP solutions will require some setup and testing. Read through BOL and see which method fits your needs. If you have specific questions as to how to get either method working, post your question.
-
Do you know how to wire script to save on cd/dvd or tape!
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply