restore database bakup

  • how to restore a database backup in sql server 2008

    on particular time scheduled

  • 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

  • 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.

  • 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

  • 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.

  • 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. :):-)

  • 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

  • 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