I've been asked to find a data recovery service who can help restore a sql
server database that has become corrupt or is on a hard drive that has
become non-functional. Does anyone have suggestions of a company who
specializes in this sort of work?
Since most drives (disk arrays) are multiple spindles in a RAID configuration
could you be a bit more specific? Do you mean, for example, an internal set
of drives?
--DatabaseAdmins.com
Remote DBA Services
"Beth In Alaska" wrote:
> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>
>
|||Hello,
If you hard drive is totally unusable, only option is restore from a good
backup and restore transaction log backups.
Take a look into various hugh availability options using:-
1. Replication
2. Logshipping
3. Database mirroring
or
Clustering
Thanks
Hari
"Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
news:12up0hbf4hgf94b@.corp.supernews.com...
> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>
|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23MgK8%235XHHA.2640@.TK2MSFTNGP06.phx.gbl...
> Hello,
> If you hard drive is totally unusable, only option is restore from a good
> backup and restore transaction log backups.
>
In the meantime, see what a company like Ontrack.com can do.
And there's one or two software packages that claim to be able to help
recover data from a corrupt db.
Take a look at those.
> Take a look into various hugh availability options using:-
> 1. Replication
> 2. Logshipping
> 3. Database mirroring
> or
> Clustering
> Thanks
> Hari
> "Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
> news:12up0hbf4hgf94b@.corp.supernews.com...
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
Showing posts with label recovery. Show all posts
Showing posts with label recovery. Show all posts
Tuesday, March 20, 2012
Data recovery service!
I've been asked to find a data recovery service who can help restore a sql
server database that has become corrupt or is on a hard drive that has
become non-functional. Does anyone have suggestions of a company who
specializes in this sort of work?Since most drives (disk arrays) are multiple spindles in a RAID configuration
could you be a bit more specific? Do you mean, for example, an internal set
of drives?
--DatabaseAdmins.com
Remote DBA Services
"Beth In Alaska" wrote:
> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>
>|||Hello,
If you hard drive is totally unusable, only option is restore from a good
backup and restore transaction log backups.
Take a look into various hugh availability options using:-
1. Replication
2. Logshipping
3. Database mirroring
or
Clustering
Thanks
Hari
"Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
news:12up0hbf4hgf94b@.corp.supernews.com...
> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23MgK8%235XHHA.2640@.TK2MSFTNGP06.phx.gbl...
> Hello,
> If you hard drive is totally unusable, only option is restore from a good
> backup and restore transaction log backups.
>
In the meantime, see what a company like Ontrack.com can do.
And there's one or two software packages that claim to be able to help
recover data from a corrupt db.
Take a look at those.
> Take a look into various hugh availability options using:-
> 1. Replication
> 2. Logshipping
> 3. Database mirroring
> or
> Clustering
> Thanks
> Hari
> "Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
> news:12up0hbf4hgf94b@.corp.supernews.com...
>> I've been asked to find a data recovery service who can help restore a
>> sql server database that has become corrupt or is on a hard drive that
>> has become non-functional. Does anyone have suggestions of a company who
>> specializes in this sort of work?
>
--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
server database that has become corrupt or is on a hard drive that has
become non-functional. Does anyone have suggestions of a company who
specializes in this sort of work?Since most drives (disk arrays) are multiple spindles in a RAID configuration
could you be a bit more specific? Do you mean, for example, an internal set
of drives?
--DatabaseAdmins.com
Remote DBA Services
"Beth In Alaska" wrote:
> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>
>|||Hello,
If you hard drive is totally unusable, only option is restore from a good
backup and restore transaction log backups.
Take a look into various hugh availability options using:-
1. Replication
2. Logshipping
3. Database mirroring
or
Clustering
Thanks
Hari
"Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
news:12up0hbf4hgf94b@.corp.supernews.com...
> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23MgK8%235XHHA.2640@.TK2MSFTNGP06.phx.gbl...
> Hello,
> If you hard drive is totally unusable, only option is restore from a good
> backup and restore transaction log backups.
>
In the meantime, see what a company like Ontrack.com can do.
And there's one or two software packages that claim to be able to help
recover data from a corrupt db.
Take a look at those.
> Take a look into various hugh availability options using:-
> 1. Replication
> 2. Logshipping
> 3. Database mirroring
> or
> Clustering
> Thanks
> Hari
> "Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
> news:12up0hbf4hgf94b@.corp.supernews.com...
>> I've been asked to find a data recovery service who can help restore a
>> sql server database that has become corrupt or is on a hard drive that
>> has become non-functional. Does anyone have suggestions of a company who
>> specializes in this sort of work?
>
--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
Data recovery service!
I've been asked to find a data recovery service who can help restore a sql
server database that has become corrupt or is on a hard drive that has
become non-functional. Does anyone have suggestions of a company who
specializes in this sort of work?Since most drives (disk arrays) are multiple spindles in a RAID configuratio
n
could you be a bit more specific? Do you mean, for example, an internal set
of drives?
--DatabaseAdmins.com
Remote DBA Services
"Beth In Alaska" wrote:
> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>
>|||Hello,
If you hard drive is totally unusable, only option is restore from a good
backup and restore transaction log backups.
Take a look into various hugh availability options using:-
1. Replication
2. Logshipping
3. Database mirroring
or
Clustering
Thanks
Hari
"Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
news:12up0hbf4hgf94b@.corp.supernews.com...
> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23MgK8%235XHHA.2640@.TK2MSFTNGP06.phx.gbl...
> Hello,
> If you hard drive is totally unusable, only option is restore from a good
> backup and restore transaction log backups.
>
In the meantime, see what a company like Ontrack.com can do.
And there's one or two software packages that claim to be able to help
recover data from a corrupt db.
Take a look at those.
> Take a look into various hugh availability options using:-
> 1. Replication
> 2. Logshipping
> 3. Database mirroring
> or
> Clustering
> Thanks
> Hari
> "Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
> news:12up0hbf4hgf94b@.corp.supernews.com...
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
server database that has become corrupt or is on a hard drive that has
become non-functional. Does anyone have suggestions of a company who
specializes in this sort of work?Since most drives (disk arrays) are multiple spindles in a RAID configuratio
n
could you be a bit more specific? Do you mean, for example, an internal set
of drives?
--DatabaseAdmins.com
Remote DBA Services
"Beth In Alaska" wrote:
> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>
>|||Hello,
If you hard drive is totally unusable, only option is restore from a good
backup and restore transaction log backups.
Take a look into various hugh availability options using:-
1. Replication
2. Logshipping
3. Database mirroring
or
Clustering
Thanks
Hari
"Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
news:12up0hbf4hgf94b@.corp.supernews.com...
> I've been asked to find a data recovery service who can help restore a sql
> server database that has become corrupt or is on a hard drive that has
> become non-functional. Does anyone have suggestions of a company who
> specializes in this sort of work?
>|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23MgK8%235XHHA.2640@.TK2MSFTNGP06.phx.gbl...
> Hello,
> If you hard drive is totally unusable, only option is restore from a good
> backup and restore transaction log backups.
>
In the meantime, see what a company like Ontrack.com can do.
And there's one or two software packages that claim to be able to help
recover data from a corrupt db.
Take a look at those.
> Take a look into various hugh availability options using:-
> 1. Replication
> 2. Logshipping
> 3. Database mirroring
> or
> Clustering
> Thanks
> Hari
> "Beth In Alaska" <bethinak@.spamfreeclearwire.net> wrote in message
> news:12up0hbf4hgf94b@.corp.supernews.com...
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
Data recovery problems
I restored a backup and latest trasnsactions files for one
of my db (hrMasterData), now I have a messages that says
HrMasterData (loading).
It is a long time I am waiting for, what is happening, and
what can I do?If you restored all your transaction log files already, maybe you just
forgot to use the WITH RECOVERY in your last tlog. Use the following command
to solve this problem:
RESTORE DATABASE dbname WITH RECOVERY
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"FREDY COREA" <anonymous@.discussions.microsoft.com> wrote in message
news:105bb01c40df9$d8bd9f20$a401280a@.phx
.gbl...
> I restored a backup and latest trasnsactions files for one
> of my db (hrMasterData), now I have a messages that says
> HrMasterData (loading).
> It is a long time I am waiting for, what is happening, and
> what can I do?
>
of my db (hrMasterData), now I have a messages that says
HrMasterData (loading).
It is a long time I am waiting for, what is happening, and
what can I do?If you restored all your transaction log files already, maybe you just
forgot to use the WITH RECOVERY in your last tlog. Use the following command
to solve this problem:
RESTORE DATABASE dbname WITH RECOVERY
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"FREDY COREA" <anonymous@.discussions.microsoft.com> wrote in message
news:105bb01c40df9$d8bd9f20$a401280a@.phx
.gbl...
> I restored a backup and latest trasnsactions files for one
> of my db (hrMasterData), now I have a messages that says
> HrMasterData (loading).
> It is a long time I am waiting for, what is happening, and
> what can I do?
>
data recovery problem: need help with sp_attach_db
Hello, The short story is that we were trying to update to windows
2000 sp4 and the server was corrupted. It would not boot. So, we
reinstalled the OS and SQL Server 7. Now, I have one MDF
file/database which I need to reattach. How do I do this? I've been
reading about sp_attach_db and sp_attach_single_file_db so I know that
it's possible but I need a quick step-by-step as to how to access the
command line and what to do, caveats, etc. I'd like to have things
back up and running by Monday AM so if there is a gentle reader who
sees this cry for help and can send me an email concerning the fix I
would greatly appreciate it. THANKS!
Eben Yong
eben_yong@.hpsm.org <--work (I prefer responses, here)
yonglove@.yahoo.com <--personalIf you only have the data file, you might get lucky with
sp_attach_single_file_db. For example:
EXEC sp_attach_single_file_db
'MyDatabase',
'C:\MyDataFiles\MyDatabase.mdf'
Depending on the state database at the time of the crash, the attach may
fail because the data file is inconsistent and the log file is required.
In this case, I suggest you restore from backup if possible. If you
have no backup, contact Microsoft PSS.
If the database attaches successfully, you'll need to recreate logins
and remap database. You can use sp_change_users_login to facilitate
this. See the Books Online for details on using these stored procs.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Eben Yong" <yonglove@.yahoo.com> wrote in message
news:b9393494.0309131949.86e62f5@.posting.google.com...
> Hello, The short story is that we were trying to update to windows
> 2000 sp4 and the server was corrupted. It would not boot. So, we
> reinstalled the OS and SQL Server 7. Now, I have one MDF
> file/database which I need to reattach. How do I do this? I've been
> reading about sp_attach_db and sp_attach_single_file_db so I know that
> it's possible but I need a quick step-by-step as to how to access the
> command line and what to do, caveats, etc. I'd like to have things
> back up and running by Monday AM so if there is a gentle reader who
> sees this cry for help and can send me an email concerning the fix I
> would greatly appreciate it. THANKS!
> Eben Yong
> eben_yong@.hpsm.org <--work (I prefer responses, here)
> yonglove@.yahoo.com <--personal|||I tried it, but it didn't work... help!! Am I 'stuck'?
exec sp_attach_single_file_db @.dbname = 'eVision_Data', @.physname ='E:\MSSQL7\DATA\eVision_Data.MDF'
Server: Msg 945, Level 14, State 2, Line 1
Database 'eVision_Data' cannot be opened because some of the files
could not be activated.
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'eVision_Data'. CREATE DATABASE is
aborted.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message news:<#UnLjVneDHA.3896@.tk2msftngp13.phx.gbl>...
> If you only have the data file, you might get lucky with
> sp_attach_single_file_db. For example:
> EXEC sp_attach_single_file_db
> 'MyDatabase',
> 'C:\MyDataFiles\MyDatabase.mdf'
>|||> I tried it, but it didn't work... help!! Am I 'stuck'?
Yes. I suggest you restore from backup if possible. If you have no
backup, contact Microsoft PSS.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Eben Yong" <yonglove@.yahoo.com> wrote in message
news:b9393494.0309150616.48445f1e@.posting.google.com...
> I tried it, but it didn't work... help!! Am I 'stuck'?
> exec sp_attach_single_file_db @.dbname = 'eVision_Data', @.physname => 'E:\MSSQL7\DATA\eVision_Data.MDF'
> Server: Msg 945, Level 14, State 2, Line 1
> Database 'eVision_Data' cannot be opened because some of the files
> could not be activated.
> Server: Msg 1813, Level 16, State 2, Line 1
> Could not open new database 'eVision_Data'. CREATE DATABASE is
> aborted.
> "Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:<#UnLjVneDHA.3896@.tk2msftngp13.phx.gbl>...
> > If you only have the data file, you might get lucky with
> > sp_attach_single_file_db. For example:
> >
> > EXEC sp_attach_single_file_db
> > 'MyDatabase',
> > 'C:\MyDataFiles\MyDatabase.mdf'
> >sql
2000 sp4 and the server was corrupted. It would not boot. So, we
reinstalled the OS and SQL Server 7. Now, I have one MDF
file/database which I need to reattach. How do I do this? I've been
reading about sp_attach_db and sp_attach_single_file_db so I know that
it's possible but I need a quick step-by-step as to how to access the
command line and what to do, caveats, etc. I'd like to have things
back up and running by Monday AM so if there is a gentle reader who
sees this cry for help and can send me an email concerning the fix I
would greatly appreciate it. THANKS!
Eben Yong
eben_yong@.hpsm.org <--work (I prefer responses, here)
yonglove@.yahoo.com <--personalIf you only have the data file, you might get lucky with
sp_attach_single_file_db. For example:
EXEC sp_attach_single_file_db
'MyDatabase',
'C:\MyDataFiles\MyDatabase.mdf'
Depending on the state database at the time of the crash, the attach may
fail because the data file is inconsistent and the log file is required.
In this case, I suggest you restore from backup if possible. If you
have no backup, contact Microsoft PSS.
If the database attaches successfully, you'll need to recreate logins
and remap database. You can use sp_change_users_login to facilitate
this. See the Books Online for details on using these stored procs.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Eben Yong" <yonglove@.yahoo.com> wrote in message
news:b9393494.0309131949.86e62f5@.posting.google.com...
> Hello, The short story is that we were trying to update to windows
> 2000 sp4 and the server was corrupted. It would not boot. So, we
> reinstalled the OS and SQL Server 7. Now, I have one MDF
> file/database which I need to reattach. How do I do this? I've been
> reading about sp_attach_db and sp_attach_single_file_db so I know that
> it's possible but I need a quick step-by-step as to how to access the
> command line and what to do, caveats, etc. I'd like to have things
> back up and running by Monday AM so if there is a gentle reader who
> sees this cry for help and can send me an email concerning the fix I
> would greatly appreciate it. THANKS!
> Eben Yong
> eben_yong@.hpsm.org <--work (I prefer responses, here)
> yonglove@.yahoo.com <--personal|||I tried it, but it didn't work... help!! Am I 'stuck'?
exec sp_attach_single_file_db @.dbname = 'eVision_Data', @.physname ='E:\MSSQL7\DATA\eVision_Data.MDF'
Server: Msg 945, Level 14, State 2, Line 1
Database 'eVision_Data' cannot be opened because some of the files
could not be activated.
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'eVision_Data'. CREATE DATABASE is
aborted.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message news:<#UnLjVneDHA.3896@.tk2msftngp13.phx.gbl>...
> If you only have the data file, you might get lucky with
> sp_attach_single_file_db. For example:
> EXEC sp_attach_single_file_db
> 'MyDatabase',
> 'C:\MyDataFiles\MyDatabase.mdf'
>|||> I tried it, but it didn't work... help!! Am I 'stuck'?
Yes. I suggest you restore from backup if possible. If you have no
backup, contact Microsoft PSS.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Eben Yong" <yonglove@.yahoo.com> wrote in message
news:b9393494.0309150616.48445f1e@.posting.google.com...
> I tried it, but it didn't work... help!! Am I 'stuck'?
> exec sp_attach_single_file_db @.dbname = 'eVision_Data', @.physname => 'E:\MSSQL7\DATA\eVision_Data.MDF'
> Server: Msg 945, Level 14, State 2, Line 1
> Database 'eVision_Data' cannot be opened because some of the files
> could not be activated.
> Server: Msg 1813, Level 16, State 2, Line 1
> Could not open new database 'eVision_Data'. CREATE DATABASE is
> aborted.
> "Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:<#UnLjVneDHA.3896@.tk2msftngp13.phx.gbl>...
> > If you only have the data file, you might get lucky with
> > sp_attach_single_file_db. For example:
> >
> > EXEC sp_attach_single_file_db
> > 'MyDatabase',
> > 'C:\MyDataFiles\MyDatabase.mdf'
> >sql
Data Recovery Book
Hi!
I am glad to introduce World's First Book on Professional Data
Recovery Programming. Book also Includes a FREE CD, which contains
complete Source Codes of all the software/Programs described within
the book and may interesting tools
You can see the contents of the book and order Online on following
link:
http://www.DataDoctor.biz/author.htm
The Details of the Book are as follows:
Title of the book: "Data Recovery with & without Programming"
Author of the book: Tarun Tyagi
Publishers of the book: BPB Publications, New Delhi, India
Number of Pages: 540
Size: (9.5 x 7.5 x 1.0) Inches
ISBN: 81-7656-922-4
Price: $ 69.00 (Including Shipping Charge, Cost of
Book and Other expenses)
Enjoy Reading!!
Regards,
Tarun Tyagi
J-110, Patel Nagar - 1,
Ghaziabad (U.P.), India -201001
Cell: (+91)9868337762
http://www.DataDoctor.Biz
Your page doesn't render at all in Firefox. You might want to check that
out.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Author Tarun Tyagi" <tyagi_st@.yahoo.com> wrote in message
news:a921f5f5.0412010120.1b976a90@.posting.google.c om...
> Hi!
> I am glad to introduce World's First Book on Professional Data
> Recovery Programming. Book also Includes a FREE CD, which contains
> complete Source Codes of all the software/Programs described within
> the book and may interesting tools
> You can see the contents of the book and order Online on following
> link:
> http://www.DataDoctor.biz/author.htm
> The Details of the Book are as follows:
> Title of the book: "Data Recovery with & without Programming"
> Author of the book: Tarun Tyagi
> Publishers of the book: BPB Publications, New Delhi, India
> Number of Pages: 540
> Size: (9.5 x 7.5 x 1.0) Inches
> ISBN: 81-7656-922-4
> Price: $ 69.00 (Including Shipping Charge, Cost of
> Book and Other expenses)
> Enjoy Reading!!
> Regards,
> Tarun Tyagi
> J-110, Patel Nagar - 1,
> Ghaziabad (U.P.), India -201001
> Cell: (+91)9868337762
> http://www.DataDoctor.Biz
I am glad to introduce World's First Book on Professional Data
Recovery Programming. Book also Includes a FREE CD, which contains
complete Source Codes of all the software/Programs described within
the book and may interesting tools
You can see the contents of the book and order Online on following
link:
http://www.DataDoctor.biz/author.htm
The Details of the Book are as follows:
Title of the book: "Data Recovery with & without Programming"
Author of the book: Tarun Tyagi
Publishers of the book: BPB Publications, New Delhi, India
Number of Pages: 540
Size: (9.5 x 7.5 x 1.0) Inches
ISBN: 81-7656-922-4
Price: $ 69.00 (Including Shipping Charge, Cost of
Book and Other expenses)
Enjoy Reading!!
Regards,
Tarun Tyagi
J-110, Patel Nagar - 1,
Ghaziabad (U.P.), India -201001
Cell: (+91)9868337762
http://www.DataDoctor.Biz
Your page doesn't render at all in Firefox. You might want to check that
out.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Author Tarun Tyagi" <tyagi_st@.yahoo.com> wrote in message
news:a921f5f5.0412010120.1b976a90@.posting.google.c om...
> Hi!
> I am glad to introduce World's First Book on Professional Data
> Recovery Programming. Book also Includes a FREE CD, which contains
> complete Source Codes of all the software/Programs described within
> the book and may interesting tools
> You can see the contents of the book and order Online on following
> link:
> http://www.DataDoctor.biz/author.htm
> The Details of the Book are as follows:
> Title of the book: "Data Recovery with & without Programming"
> Author of the book: Tarun Tyagi
> Publishers of the book: BPB Publications, New Delhi, India
> Number of Pages: 540
> Size: (9.5 x 7.5 x 1.0) Inches
> ISBN: 81-7656-922-4
> Price: $ 69.00 (Including Shipping Charge, Cost of
> Book and Other expenses)
> Enjoy Reading!!
> Regards,
> Tarun Tyagi
> J-110, Patel Nagar - 1,
> Ghaziabad (U.P.), India -201001
> Cell: (+91)9868337762
> http://www.DataDoctor.Biz
Data Recovery Book
Hi!
I am glad to introduce World's First Book on Professional Data
Recovery Programming. Book also Includes a FREE CD, which contains
complete Source Codes of all the software/Programs described within
the book and may interesting tools
You can see the contents of the book and order Online on following
link:
http://www.DataDoctor.biz/author.htm
The Details of the Book are as follows:
Title of the book: "Data Recovery with & without Programming"
Author of the book: Tarun Tyagi
Publishers of the book: BPB Publications, New Delhi, India
Number of Pages: 540
Size: (9.5 x 7.5 x 1.0) Inches
ISBN: 81-7656-922-4
Price: $ 69.00 (Including Shipping Charge, Cost of
Book and Other expenses)
Enjoy Reading!!
Regards,
Tarun Tyagi
J-110, Patel Nagar - 1,
Ghaziabad (U.P.), India -201001
Cell: (+91)9868337762
http://www.DataDoctor.BizYour page doesn't render at all in Firefox. You might want to check that
out.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Author Tarun Tyagi" <tyagi_st@.yahoo.com> wrote in message
news:a921f5f5.0412010120.1b976a90@.posting.google.com...
> Hi!
> I am glad to introduce World's First Book on Professional Data
> Recovery Programming. Book also Includes a FREE CD, which contains
> complete Source Codes of all the software/Programs described within
> the book and may interesting tools
> You can see the contents of the book and order Online on following
> link:
> http://www.DataDoctor.biz/author.htm
> The Details of the Book are as follows:
> Title of the book: "Data Recovery with & without Programming"
> Author of the book: Tarun Tyagi
> Publishers of the book: BPB Publications, New Delhi, India
> Number of Pages: 540
> Size: (9.5 x 7.5 x 1.0) Inches
> ISBN: 81-7656-922-4
> Price: $ 69.00 (Including Shipping Charge, Cost of
> Book and Other expenses)
> Enjoy Reading!!
> Regards,
> Tarun Tyagi
> J-110, Patel Nagar - 1,
> Ghaziabad (U.P.), India -201001
> Cell: (+91)9868337762
> http://www.DataDoctor.Biz
I am glad to introduce World's First Book on Professional Data
Recovery Programming. Book also Includes a FREE CD, which contains
complete Source Codes of all the software/Programs described within
the book and may interesting tools
You can see the contents of the book and order Online on following
link:
http://www.DataDoctor.biz/author.htm
The Details of the Book are as follows:
Title of the book: "Data Recovery with & without Programming"
Author of the book: Tarun Tyagi
Publishers of the book: BPB Publications, New Delhi, India
Number of Pages: 540
Size: (9.5 x 7.5 x 1.0) Inches
ISBN: 81-7656-922-4
Price: $ 69.00 (Including Shipping Charge, Cost of
Book and Other expenses)
Enjoy Reading!!
Regards,
Tarun Tyagi
J-110, Patel Nagar - 1,
Ghaziabad (U.P.), India -201001
Cell: (+91)9868337762
http://www.DataDoctor.BizYour page doesn't render at all in Firefox. You might want to check that
out.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Author Tarun Tyagi" <tyagi_st@.yahoo.com> wrote in message
news:a921f5f5.0412010120.1b976a90@.posting.google.com...
> Hi!
> I am glad to introduce World's First Book on Professional Data
> Recovery Programming. Book also Includes a FREE CD, which contains
> complete Source Codes of all the software/Programs described within
> the book and may interesting tools
> You can see the contents of the book and order Online on following
> link:
> http://www.DataDoctor.biz/author.htm
> The Details of the Book are as follows:
> Title of the book: "Data Recovery with & without Programming"
> Author of the book: Tarun Tyagi
> Publishers of the book: BPB Publications, New Delhi, India
> Number of Pages: 540
> Size: (9.5 x 7.5 x 1.0) Inches
> ISBN: 81-7656-922-4
> Price: $ 69.00 (Including Shipping Charge, Cost of
> Book and Other expenses)
> Enjoy Reading!!
> Regards,
> Tarun Tyagi
> J-110, Patel Nagar - 1,
> Ghaziabad (U.P.), India -201001
> Cell: (+91)9868337762
> http://www.DataDoctor.Biz
Data Recovery Book
Hi!
I am glad to introduce World's First Book on Professional Data
Recovery Programming. Book also Includes a FREE CD, which contains
complete Source Codes of all the software/Programs described within
the book and may interesting tools
You can see the contents of the book and order Online on following
link:
http://www.DataDoctor.biz/author.htm
The Details of the Book are as follows:
Title of the book: "Data Recovery with & without Programming"
Author of the book: Tarun Tyagi
Publishers of the book: BPB Publications, New Delhi, India
Number of Pages: 540
Size: (9.5 x 7.5 x 1.0) Inches
ISBN: 81-7656-922-4
Price: $ 69.00 (Including Shipping Charge, Cost of
Book and Other expenses)
Enjoy Reading!!
Regards,
Tarun Tyagi
J-110, Patel Nagar - 1,
Ghaziabad (U.P.), India -201001
Cell: (+91)9868337762
http://www.DataDoctor.BizYour page doesn't render at all in Firefox. You might want to check that
out.
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Author Tarun Tyagi" <tyagi_st@.yahoo.com> wrote in message
news:a921f5f5.0412010120.1b976a90@.posting.google.com...
> Hi!
> I am glad to introduce World's First Book on Professional Data
> Recovery Programming. Book also Includes a FREE CD, which contains
> complete Source Codes of all the software/Programs described within
> the book and may interesting tools
> You can see the contents of the book and order Online on following
> link:
> http://www.DataDoctor.biz/author.htm
> The Details of the Book are as follows:
> Title of the book: "Data Recovery with & without Programming"
> Author of the book: Tarun Tyagi
> Publishers of the book: BPB Publications, New Delhi, India
> Number of Pages: 540
> Size: (9.5 x 7.5 x 1.0) Inches
> ISBN: 81-7656-922-4
> Price: $ 69.00 (Including Shipping Charge, Cost of
> Book and Other expenses)
> Enjoy Reading!!
> Regards,
> Tarun Tyagi
> J-110, Patel Nagar - 1,
> Ghaziabad (U.P.), India -201001
> Cell: (+91)9868337762
> http://www.DataDoctor.Biz
I am glad to introduce World's First Book on Professional Data
Recovery Programming. Book also Includes a FREE CD, which contains
complete Source Codes of all the software/Programs described within
the book and may interesting tools
You can see the contents of the book and order Online on following
link:
http://www.DataDoctor.biz/author.htm
The Details of the Book are as follows:
Title of the book: "Data Recovery with & without Programming"
Author of the book: Tarun Tyagi
Publishers of the book: BPB Publications, New Delhi, India
Number of Pages: 540
Size: (9.5 x 7.5 x 1.0) Inches
ISBN: 81-7656-922-4
Price: $ 69.00 (Including Shipping Charge, Cost of
Book and Other expenses)
Enjoy Reading!!
Regards,
Tarun Tyagi
J-110, Patel Nagar - 1,
Ghaziabad (U.P.), India -201001
Cell: (+91)9868337762
http://www.DataDoctor.BizYour page doesn't render at all in Firefox. You might want to check that
out.
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Author Tarun Tyagi" <tyagi_st@.yahoo.com> wrote in message
news:a921f5f5.0412010120.1b976a90@.posting.google.com...
> Hi!
> I am glad to introduce World's First Book on Professional Data
> Recovery Programming. Book also Includes a FREE CD, which contains
> complete Source Codes of all the software/Programs described within
> the book and may interesting tools
> You can see the contents of the book and order Online on following
> link:
> http://www.DataDoctor.biz/author.htm
> The Details of the Book are as follows:
> Title of the book: "Data Recovery with & without Programming"
> Author of the book: Tarun Tyagi
> Publishers of the book: BPB Publications, New Delhi, India
> Number of Pages: 540
> Size: (9.5 x 7.5 x 1.0) Inches
> ISBN: 81-7656-922-4
> Price: $ 69.00 (Including Shipping Charge, Cost of
> Book and Other expenses)
> Enjoy Reading!!
> Regards,
> Tarun Tyagi
> J-110, Patel Nagar - 1,
> Ghaziabad (U.P.), India -201001
> Cell: (+91)9868337762
> http://www.DataDoctor.Biz
data recovery - pls help
Hi,
If i have some data on a table that's being deleted by an application and i
did not do backup but the recovery mode is "Full Recovery" can i somehow get
back the data ?
i know there's a deleted/ (created or updated) table but that's wtithin a
session isn't it ?
appreciate any advise
tks & rdgs
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...-msde/200512/1
hi,
maxzsim via droptable.com wrote:
> Hi,
> If i have some data on a table that's being deleted by an
> application and i did not do backup but the recovery mode is "Full
> Recovery" can i somehow get back the data ?
> i know there's a deleted/ (created or updated) table but that's
> wtithin a session isn't it ?
> appreciate any advise
> tks & rdgs
unfortunately there's no native way... but you can have a look at
http://www.aspfaq.com/show.asp?id=2449 for some tools that enable that kind
of stuff..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
tks for the link that you have provided
rdgs
Andrea Montanari wrote:
>hi,
>[quoted text clipped - 8 lines]
>unfortunately there's no native way... but you can have a look at
>http://www.aspfaq.com/show.asp?id=2449 for some tools that enable that kind
>of stuff..
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...-msde/200512/1
If i have some data on a table that's being deleted by an application and i
did not do backup but the recovery mode is "Full Recovery" can i somehow get
back the data ?
i know there's a deleted/ (created or updated) table but that's wtithin a
session isn't it ?
appreciate any advise
tks & rdgs
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...-msde/200512/1
hi,
maxzsim via droptable.com wrote:
> Hi,
> If i have some data on a table that's being deleted by an
> application and i did not do backup but the recovery mode is "Full
> Recovery" can i somehow get back the data ?
> i know there's a deleted/ (created or updated) table but that's
> wtithin a session isn't it ?
> appreciate any advise
> tks & rdgs
unfortunately there's no native way... but you can have a look at
http://www.aspfaq.com/show.asp?id=2449 for some tools that enable that kind
of stuff..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
tks for the link that you have provided
rdgs
Andrea Montanari wrote:
>hi,
>[quoted text clipped - 8 lines]
>unfortunately there's no native way... but you can have a look at
>http://www.aspfaq.com/show.asp?id=2449 for some tools that enable that kind
>of stuff..
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...-msde/200512/1
data recovery
Hello All,
Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was accidentally deleted from a table.
Thanks in advance
Hugo
Unfortunately, if you do not have a backup (and more importantly are using transaction log backups (to be able to restore to a specific point-in-time)), then unfortunately there is not a way to recover the database back to it's state before the deletion.
|||I wrote an article on this topic a couple of days ago:
http://www.karaszi.com/sqlserver/inf...eral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"hugo" <anonymous@.discussions.microsoft.com> wrote in message
news:249BA122-C703-4B60-8695-16D7A01EBD82@.microsoft.com...
> Hello All,
> Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was
accidentally deleted from a table.
> Thanks in advance
> Hugo
>
sql
Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was accidentally deleted from a table.
Thanks in advance
Hugo
Unfortunately, if you do not have a backup (and more importantly are using transaction log backups (to be able to restore to a specific point-in-time)), then unfortunately there is not a way to recover the database back to it's state before the deletion.
|||I wrote an article on this topic a couple of days ago:
http://www.karaszi.com/sqlserver/inf...eral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"hugo" <anonymous@.discussions.microsoft.com> wrote in message
news:249BA122-C703-4B60-8695-16D7A01EBD82@.microsoft.com...
> Hello All,
> Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was
accidentally deleted from a table.
> Thanks in advance
> Hugo
>
sql
data recovery
Hello All
Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was accidentally deleted from a table
Thanks in advanc
HugUnfortunately, if you do not have a backup (and more importantly are using transaction log backups (to be able to restore to a specific point-in-time)), then unfortunately there is not a way to recover the database back to it's state before the deletion.|||I wrote an article on this topic a couple of days ago:
http://www.karaszi.com/sqlserver/info_restore_log_several_times.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"hugo" <anonymous@.discussions.microsoft.com> wrote in message
news:249BA122-C703-4B60-8695-16D7A01EBD82@.microsoft.com...
> Hello All,
> Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was
accidentally deleted from a table.
> Thanks in advance
> Hugo
>
Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was accidentally deleted from a table
Thanks in advanc
HugUnfortunately, if you do not have a backup (and more importantly are using transaction log backups (to be able to restore to a specific point-in-time)), then unfortunately there is not a way to recover the database back to it's state before the deletion.|||I wrote an article on this topic a couple of days ago:
http://www.karaszi.com/sqlserver/info_restore_log_several_times.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"hugo" <anonymous@.discussions.microsoft.com> wrote in message
news:249BA122-C703-4B60-8695-16D7A01EBD82@.microsoft.com...
> Hello All,
> Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was
accidentally deleted from a table.
> Thanks in advance
> Hugo
>
data recovery
Hello All,
Is there a way to restore/recover data from an earlier date if you donot hav
e a backup. The data was accidentally deleted from a table.
Thanks in advance
HugoUnfortunately, if you do not have a backup (and more importantly are using t
ransaction log backups (to be able to restore to a specific point-in-time)),
then unfortunately there is not a way to recover the database back to it's
state before the deletion.|||I wrote an article on this topic a couple of days ago:
http://www.karaszi.com/sqlserver/in...veral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"hugo" <anonymous@.discussions.microsoft.com> wrote in message
news:249BA122-C703-4B60-8695-16D7A01EBD82@.microsoft.com...
> Hello All,
> Is there a way to restore/recover data from an earlier date if you donot have a ba
ckup. The data was
accidentally deleted from a table.
> Thanks in advance
> Hugo
>
Is there a way to restore/recover data from an earlier date if you donot hav
e a backup. The data was accidentally deleted from a table.
Thanks in advance
HugoUnfortunately, if you do not have a backup (and more importantly are using t
ransaction log backups (to be able to restore to a specific point-in-time)),
then unfortunately there is not a way to recover the database back to it's
state before the deletion.|||I wrote an article on this topic a couple of days ago:
http://www.karaszi.com/sqlserver/in...veral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"hugo" <anonymous@.discussions.microsoft.com> wrote in message
news:249BA122-C703-4B60-8695-16D7A01EBD82@.microsoft.com...
> Hello All,
> Is there a way to restore/recover data from an earlier date if you donot have a ba
ckup. The data was
accidentally deleted from a table.
> Thanks in advance
> Hugo
>
Thursday, March 8, 2012
data missing in the full backup
i have a 2005 db with full recovery mode. daily full backups, diff backups and log backups are done through sqlagent. i wanted to make a copy of it on another instance using the restore method with the latest full backup. after i created the new db, i noticed that a few tables were missing and columns were missing from existing tables also. futhermore, the recrods in these tables were not up-to-date either. i did fresh a full backup and tried again and the problem persisted. i aslo tried to restore on the same sql server instance under a different db name and that reproduced the problem.
the database schema was changed a few weeks ago and it seems that i am only seeing a snapshot of the database before the schema change. dbcc checkdb returns no error. the size of the backup file looks reasonable and i seen an increase in size since the schema change which is expected. there is no active transactions in the db and if i generate a create script, it contains proper t-sql that matches the current schema.
what am i missing there? what could i be doing wrong? i am lost here and any help or advice will be greatly appreciated!
i found the problem. the backup script didn't specify INIT and SKIP so an older set was used by the restore operation.
Subscribe to:
Posts (Atom)