Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Keeping test DataBase up to date

Status
Not open for further replies.
Fishhead714

Fishhead714

Technical User
Dec 9, 2004
58
US
We have a copy of our live data that we rename and use for testing in our ERP system. What I would like to do is update the test data nightly, currently if we want an fresh updated test DB we copy the live one, what would be the best way to keep the testing DB updated?

Sorry if this is not the right forum for this, but I'm pretty much a novice with the SQL server and still trying to get my legs under me...

Bill
 
Sort by date Sort by votes
Your best bet will be to do a full backup and restore as needed.

forum962 or forum183 are the other main SQL Server forums.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

petart
  • Locked
  • Question
Problem Date MS SQL Server
Replies
0
Views
165
petart
petart
briangriffin
  • Locked
  • Question
Add Current Date to Insert
Replies
2
Views
82
drlex
drlex
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
155
botatun
botatun
johnb1023
  • Locked
  • Question
Date conversions between Microsoft SQL Server and Viewing in MS Access
Replies
0
Views
242
johnb1023
johnb1023
ciarra41
  • Locked
  • Question
Rollup to one record with same order number
Replies
2
Views
182
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top