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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy