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.
| Author |
Topic |
|
arifliminto86
Starting Member
7 Posts |
 Posted - 2008-01-28 : 20:34:27
|
| hi allright now , i am still learning how to use sql2005is it possible if i want to read the backup data without restoring the backup database.? if it possible can you show me how to do itcheers Arifarifliminto86 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-28 : 21:23:08
|
| No you can't. |
 |
|
|
arifliminto86
Starting Member
7 Posts |
Posted - 2008-01-28 : 21:39:32
|
| anyway there is a way how to “peek” into a database backup without actually restoring it right?it somewhere in RESTORE DATABASE SYNTAX but i dont understand which syntax is it?arifliminto86 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-01-28 : 21:46:36
|
| It's not possible. See rmiao's post.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-28 : 21:48:36
|
| You can find how many backups in the file with 'restore headeronly', find source db files with 'restore filelistonly', but can't read data in any table. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-01-29 : 04:08:26
|
quote:
Originally posted by arifliminto86
anyway there is a way how to “peek” into a database backup without actually restoring it right?it somewhere in RESTORE DATABASE SYNTAX but i dont understand which syntax is it?arifliminto86
Why do you want to read data from backup file without restoring it?MadhivananFailing to plan is Planning to fail |
|
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2008-01-29 : 05:44:29
|
| Its not possible in SQL but in oracle you can open the dump without restoring.RKNAIR |
|
|
|
|
|
|
is it possible if i want to read the backup data