Restoring backup - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Restoring backup

Author

Topic

carau2007
Starting Member

31 Posts

Posted - 2007-09-07 : 11:50:33

Hi,

I am using SQL server 2000. When I want to restore a backup database from the disk. I use the Enterprise Manager tool to restore database. From there I checked Restore database and select from the first backup to restore. Do I need to backup the transaction log after? Or this does all of it?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-07 : 11:55:56

no you don't need to backup a transaction log after restore.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

carau2007
Starting Member

31 Posts

Posted - 2007-09-07 : 13:27:56

Sorry I meant do I need to restore the transaction log after I restored the database

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-07 : 13:33:02

this all depends on how you took your backup.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

carau2007
Starting Member

31 Posts

Posted - 2007-09-07 : 13:37:27

I want to restore the backup created with the maintenace plan in SQL. The backup is on the disk.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-07 : 13:40:27

If you want to restore to a point in time, then yes you need the transaction logs up to that time. If you only want the snapshot taken from the full backup, then you only need to restore the full backup.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-07 : 13:41:28