September 6, 2011 at 11:42 pm
what is Logical Back ups?
how we take Logical Back ups?
September 7, 2011 at 12:42 am
Never heard the term. Where did you hear it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 7, 2011 at 12:47 am
srik780 (9/6/2011)
what is Logical Back ups?how we take Logical Back ups?
Are you talking about Log Backups?
September 7, 2011 at 1:42 am
Logical backups are a snapshot of data and metadata. To restore a logical backup you have to read the dump file and port it back into a working database by executing a bunch of CREATE and INSERT statements. Logical backups don't take care of the database physical structures (data files, log files and so on).
Physical backups are used to back up and recover a database at the physical file and page level. As such, a physical backup can use the backupsets to completely rebuild a database from nothing.
Unlike Oracle, SQL Server does not implement logical backups directly. Backups in SQL Server are physical.
There's no imp/exp or impdb/expdp tool comparable to those provided by Oracle.
Hope this helps
Gianluca
-- Gianluca Sartori
September 8, 2011 at 9:22 am
What is the use of the logical back-ups?
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
September 8, 2011 at 9:25 am
SQL doesn't have logical backups.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 8, 2011 at 9:30 am
What about in Oracle?Or where ever the logical back-ups exist?
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
September 8, 2011 at 9:57 am
When I worked with Oracle, I used logical backups, created by the Export utility, to move data between databases without having to do a physical backup and restore. It was especially useful for moving a few tables rather than an entire database.
Greg
September 9, 2011 at 1:41 am
Noted.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply