September 12, 2013 at 4:49 am
how to restore a database backup in sql server 2008
on particular time scheduled
September 12, 2013 at 5:13 am
What's your knowledge about SQL2008 ?
Should you even be doing a restore ? ( is a restore really needed )
What are you trying to accomplish ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 12, 2013 at 5:32 am
Are you trying to restore the database over the LIVE or restore to a point in time ( from a backup )to a different database so you can do some comparison ?
You may wish to consider restoring the database to a separate database so that you can do specific table updates from the changed data ?!
The other question is ... what is your backup plan ?
do you have Full Backup and then T-Log backups ?
So many questions - but it is important to know what you are doing and what the un-expected results could be and damage that could be done.
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 12, 2013 at 10:44 am
SQL Server has a tool built into it called SQL Agent. It runs as a separate service. One of it's uses is to schedule things for SQL Server to do. That's how you can set up a restore to run at a specific time. You just have to know the T-SQL or PowerShell commands to run a restore.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 12, 2013 at 11:08 pm
ya thanks guys I got it.
I have basic knowledge of sql.
Actually I am just restoring to a new database .
ya i used sql server agent thanks.
September 12, 2013 at 11:37 pm
I guess u r talking about "point of time recovery".
and for that u need to have Transactional logs back.
its Easy and Tricky at the same time. :):-)
September 13, 2013 at 10:35 am
Keeping in mind the different types of Database restore 😉 and source and destination SQL versions.
Basic good info : http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups
September 14, 2013 at 9:09 am
Take a look at the posts here if you want an excellent series on using Powershell to backup and restore
https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply