April 5, 2011 at 3:39 pm
Hi,
I have a prod database of backup of size 300 GB on my production server.
I need to restore this Prod database to Development server.
Questions:
Which one of the following is recommended? Which puts less load on Prod Server?
1. Copy the backup file (.bak), the 300 GB file from Production server to Development server and then restore the database (or)
2. Directly restore the database from Production server by giving the path as \\Prodserver\Prod.bak
April 5, 2011 at 3:52 pm
Depends. are your backups on separate *physical* spindles from everything else, it wouldn't be too bad. I'd usually copy, then work.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply