ClioSport.net
Register a free account today to become a member!
Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!
-
When you purchase through links on our site, we may earn an affiliate commission. Read more here.
Any SQL Server Experts
- Thread starter sh33n
- Start date
cock mobile.
I would like some way of automatically creating a backup of data from our live DB, but only data in certain tables that I'd obviously specify, and only recent data again I would specify.
This data can then be restored to our local dev machines for use, it would overwrite any duplicates but other tables would remain consistent.
At the moment we have to do a complete backup and restore of the DB, which is now quite large.
Hopefully you can understand that!
Cheers guys.
This data can then be restored to our local dev machines for use, it would overwrite any duplicates but other tables would remain consistent.
At the moment we have to do a complete backup and restore of the DB, which is now quite large.
Hopefully you can understand that!
Cheers guys.
cock mobile.
DB backup is over 5Gb un compressed.
Downloading it can be a right pain, even zipped it takes hours and then it takes a good 30 mins to RESTORE it.
Even a quick way of just backing up and loading certain tables would be handy, although I don't think this is so straight forward anymore, as LOAD table isn't supported anymore is it?!
It's 2000 btw.
Cheers for any ideas.
Downloading it can be a right pain, even zipped it takes hours and then it takes a good 30 mins to RESTORE it.
Even a quick way of just backing up and loading certain tables would be handy, although I don't think this is so straight forward anymore, as LOAD table isn't supported anymore is it?!
It's 2000 btw.
Cheers for any ideas.
ofcourse veritas can backup SQL online using the SQL agent, we do it all the time.
Better than yours. C*nt.
Veritas isn't an option for me anyhow.
I need some SQL that will do this really.
Creating a DTS Package would be fine I guess, just need to get it right
So it sounds like you want an SQL database export, as opposed to a backup?
cock mobile.
Veritas isn't an option for me anyhow.
I need some SQL that will do this really.
Creating a DTS Package would be fine I guess, just need to get it right
So it sounds like you want an SQL database export, as opposed to a backup?
Yer pretty much, export the tables to a CSV and import them in is probably the easiest option here.
However importing large CSVs I've never found to be that easy, something always c***s up, unless someone has any decent tips or guides here that means I won't get it all bent out of shape!
cock mobile.
Better than yours. C*nt.
Not sure on the exports for 2000. We have 2 SQL2000 databases but they're supported by the software provider. My Altiris database is 2005, so anything I found would be irrelevant - and I'm not brave enough to break a live clinical database from my user account!
