Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...
SQL Server Forum / General / Security / November 2007

Tip: Looking for answers? Try searching our database.

Backup SQL Server 2000 and 2005

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ralph Haddad - 27 Nov 2007 14:00 GMT
Good morning,

I am with some questions concerning Backup of SQL Server 2000 and 2005.

First, I would like to know whether performing the backup Full, it is done
automatically backup of the Transaction Log? And if it is truncate it?
Or whether it is in fact necessary to perform a backup of the transaction
log specific?

Secondly, I would like to know about the differential backup. If after the
Full on Monday, I made a backup differential on Tuesday and on Wednesday, if
I have a problem on Wednesday to Thursday. It will be necessary to restore
the backup only Full of Monday and differential backup of Wednesday? Or will
it restore the backup of Differential Tuesday to restore the backup
differential of Wednesday?

Thank you,

Sincerely,

Ralph Haddad
Reply to this Message
Uri Dimant - 27 Nov 2007 14:09 GMT
> First, I would like to know whether performing the backup Full, it is done
> automatically backup of the Transaction Log? And if it is truncate it?

TLOG is also being backuped ,however BACKUP does not truncate it

> Or whether it is in fact necessary to perform a backup of the transaction
> log specific?

You have to read about different RECOVERY models in the BOL to understand it

> Secondly, I would like to know about the differential backup. If after the
> Full on Monday, I made a backup differential on Tuesday and on Wednesday,
[quoted text clipped - 4 lines]
> it restore the backup of Differential Tuesday to restore the backup
> differential of Wednesday?

Please read BOL

> Good morning,
>
[quoted text clipped - 19 lines]
>
> Ralph Haddad
Reply to this Message
Ekrem Önsoy - 27 Nov 2007 14:36 GMT
Answers are below:

Signature

Ekrem Önsoy

> Good morning,
>
[quoted text clipped - 4 lines]
> Or whether it is in fact necessary to perform a backup of the transaction
> log specific?

BACKUP DATABASE would not truncate T-Log. You need to perform a BACKUP LOG
to truncate T-Log. And to reduce your T-Log' s size you'll need to use
Shrinking. (don't use this unless necessary)

> Secondly, I would like to know about the differential backup. If after the
> Full on Monday, I made a backup differential on Tuesday and on Wednesday,
[quoted text clipped - 4 lines]
> it restore the backup of Differential Tuesday to restore the backup
> differential of Wednesday?

Restore the full backup you take on Monday and restore the lastest
differential backup only.

> Thank you,
>
> Sincerely,
>
> Ralph Haddad
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.