Web Development
We have a SQL Server 2000 database running in the production. We frequently requires the Production updated database in our Development server.
What is best possible way to achive this.
Not sure there is a best buts simply restoring your last production backup, or executing a DTS package should do the job.
If you use the backup then you've a timimg problem the bit of data you need is always put in after the last backup you've got.
Using DTS you could have the same problem and it would be a hefty bit of extra overhead on production.
Either strategy assumes you aren't making a change to the structure of the database and that you can easily get back in specific test data content for existing devlopments though. The latter is why I prefer either another environment to mirror production which can be auto-updated to examine issues with live content without impacting either production or ongoing developments.
by lfox
I am constantly moving copies of a our production database to dev. Backup/restore is my choice since my database is large with lots of tables, 1000+. The only problem you'll have is after the restore you MUST drop and re-add the users, since users are stored at the server level and the database contains only a reference, i.e. pointer, to the user. On the dev server those pointers will not match to the correct user.
I have a script for dropping all users -- send me an email if you would like a copy. To add the users on the dev database, you can either do them manually or if you are overlaying a dev database, script the database users before the restore, do the restore, then apply the script to the new version to add back the users.
Larry Fox, DBA
LFox@AgFirst.com
by melwinjames
Friend u need only the updated data's so u can take this steps:
1) detach the sqlserver:
2) Go to C:\Program Files\Microsoft SQL Server\MSSQL\Data
3) Copy the database_Data.LDF file
Then In ur system:
1) Follow the first 2 steps above.
2) Paste the file(Check the DB file name is same)
3) Then attach the DB.
It will work.
Any issues kindly let me know.
Melwin James
This discussion is closed to new replies.
Sort by Trending