Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-07 : 09:29:29
|
| writes "I wanted To copy data from Production server database To Development everyday can you tel me any way that I can set up process that oit can run automaticaly copy data from one databse to another or Server to another.thanks" |
|
|
PiecesOfEight
Posting Yak Master
200 Posts |
Posted - 2001-12-07 : 13:38:23
|
| If you only need to do it once a day, you might try snapshot replication or DTS. If you need the changes as they occur, you should look at transactional replication. For either type of replication, you can make the production server the publisher and the dev server the subscriber. |
 |
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2001-12-14 : 02:01:07
|
| I would like to do exactly the same thing, Is there a way to do it so that it copies the SP's and all other stuff at the same time?Also my datafiles are 143meg however my log file is over 9Gig and I can not delete it .. its says "primary log file cannot be deleted from a database"Any helps greatly appreciated .. thanks |
|
|
|
PiecesOfEight
Posting Yak Master
200 Posts |
Posted - 2001-12-14 : 11:33:23
|
| Log size reduction is a well traveled road here at SQL Team, so you should do a search for transaction log. Basically the log is truncated when you back it up, which you should definitely be doing. In order to reclaim that space on the drive, you might need to run DBCC SHRINKFILE after you run BACKUP LOG. As for the other issue, it depends on what objects you have to move between the two servers. Do you need to move data from production to dev and procs, etc. from dev to production? You could use transactional replication to keep the data in sync throughout the day, and then have a snapshot job or DTS copy over the other objects. |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2001-12-14 : 12:36:55
|
quote:
I would like to do exactly the same thing, Is there a way to do it so that it copies the SP's and all other stuff at the same time? quote:
You can replicate the stored procedures as well as the database. |
|
|
|
PiecesOfEight
Posting Yak Master
200 Posts |
Posted - 2001-12-14 : 12:48:17
|
quote:
You can replicate the stored procedures as well as the database.
True, but you cannot replicate incremental changes to procs. That's why I suggested transactional for the data and snapshot for the procs. |
|
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2001-12-18 : 17:33:55
|
| Thanks for the help guys .. When I attempt to backup my Database (now 11.7 gigs!) so that it automatically truncates I get an "unrecoverable I/O Error". I have tried serveral times and it usually errors out at about 5 gigs ... there is about 14 gig free on the drive. Any suggestions? How can I manually truncate it if I can't back it up? Thanks in advance!Mike |
|
|
|
|
|
|
|
|
Replicate database