Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

restore database bakup Expand / Collapse
Author
Message
Posted Thursday, September 12, 2013 4:49 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 1:31 AM
Points: 68, Visits: 387
how to restore a database backup in sql server 2008
on particular time scheduled

Post #1494088
Posted Thursday, September 12, 2013 5:13 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:27 AM
Points: 6,997, Visits: 8,411
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


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- 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
Post #1494092
Posted Thursday, September 12, 2013 5:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 5:43 AM
Points: 170, Visits: 405
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.
Post #1494098
Posted Thursday, September 12, 2013 10:44 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:30 PM
Points: 14,802, Visits: 27,275
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1494288
Posted Thursday, September 12, 2013 11:08 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 1:31 AM
Points: 68, Visits: 387
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.
Post #1494438
Posted Thursday, September 12, 2013 11:37 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, April 03, 2014 10:57 PM
Points: 416, Visits: 512
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. :)
Post #1494443
Posted Friday, September 13, 2013 10:35 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 2:56 PM
Points: 604, Visits: 366
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
Post #1494664
Posted Saturday, September 14, 2013 9:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 5:23 AM
Points: 15, Visits: 415
Take a look at the posts here if you want an excellent series on using Powershell to backup and restore

[url=http://stuart-moore.com/category/31-days-of-sql-server-backup-and-restore-with-powershell/ ][/url]



http://sqldbawithabeard.com Its where I blog

SQL South West UK User Grouphttp://sqlsouthwest.co.uk/
Post #1494817
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse