| Author |
How to recover deleted postings from Deleted Items folder?
|
|
|
| Is there a way to achieve this. Unfortunately we do not have a sdo backup. Is
it possible through SQL server transaction log?
| |
| Angus Logan [MVP] 2005-05-30, 7:52 am |
| Hi Lam,
You would need to restore the database to a previous backup when the posting
existed.
Once you restore the database export the posting;
restore the current MCMS database and import the posting.
Regards
--
________________________________________
Angus Logan (MCAD/MCDBA/MCP/MVP for MCMS)
Product Specialist
Microsoft Application Solutions
Data#3 Limited
E angus_logan@data3.com.au
BLOG www.anguslogan.com
________________________________________
"Lam" <Lam@discussions.microsoft.com> wrote in message
news:7BA663D8-7BCB-4926-82C7-D717045E4C3C@microsoft.com...
> Is there a way to achieve this. Unfortunately we do not have a sdo backup.
> Is
> it possible through SQL server transaction log?
| |
|
| Hi angus,
Unfortunately, we do not have a db backup. Is restoring the transaction log
a recommended way? Any other suggestion?
Thanks.
"Angus Logan [MVP]" wrote:
> Hi Lam,
>
> You would need to restore the database to a previous backup when the posting
> existed.
>
> Once you restore the database export the posting;
> restore the current MCMS database and import the posting.
>
> Regards
> --
> ________________________________________
>
> Angus Logan (MCAD/MCDBA/MCP/MVP for MCMS)
> Product Specialist
> Microsoft Application Solutions
> Data#3 Limited
> E angus_logan@data3.com.au
> BLOG www.anguslogan.com
> ________________________________________
> "Lam" <Lam@discussions.microsoft.com> wrote in message
> news:7BA663D8-7BCB-4926-82C7-D717045E4C3C@microsoft.com...
>
>
>
| |
| Angus Logan [MVP] 2005-05-30, 7:52 am |
| Hi Lam,
I am unsure of the effects of running MCMS from a Database that has been
rolled back with transaction logs - so maybe you should backup the database
in its existing state;
roll back using the transaction logs;
export the posting;
restore the database to its previous state and import the posting.
Regards
--
________________________________________
Angus Logan (MCAD/MCDBA/MCP/MVP for MCMS)
Product Specialist
Microsoft Application Solutions
Data#3 Limited
E angus_logan@data3.com.au
BLOG www.anguslogan.com
________________________________________
"Lam" <Lam@discussions.microsoft.com> wrote in message
news:16F38F25-A2CF-4963-AFE6-03EF28D30F17@microsoft.com...[vbcol=seagreen]
> Hi angus,
>
> Unfortunately, we do not have a db backup. Is restoring the transaction
> log
> a recommended way? Any other suggestion?
>
> Thanks.
>
> "Angus Logan [MVP]" wrote:
>
| |
| Chester Ragel 2005-05-30, 7:52 am |
| Hi Angus,
This is not a good idea. Rolling back transaction logs may make the MCMS
database inconsistent -> it is a way of breaking the support boundary.
Cheers,
Chester.
"Angus Logan [MVP]" <angus_logan@data3.com.au> wrote in message
news:epg0Z6PZFHA.1088@TK2MSFTNGP14.phx.gbl...
> Hi Lam,
>
> I am unsure of the effects of running MCMS from a Database that has been
> rolled back with transaction logs - so maybe you should backup the
database
> in its existing state;
>
> roll back using the transaction logs;
>
> export the posting;
>
> restore the database to its previous state and import the posting.
>
> Regards
> --
> ________________________________________
>
> Angus Logan (MCAD/MCDBA/MCP/MVP for MCMS)
> Product Specialist
> Microsoft Application Solutions
> Data#3 Limited
> E angus_logan@data3.com.au
> BLOG www.anguslogan.com
> ________________________________________
> "Lam" <Lam@discussions.microsoft.com> wrote in message
> news:16F38F25-A2CF-4963-AFE6-03EF28D30F17@microsoft.com...
>
>
| |
| Angus Logan [MVP] 2005-05-30, 7:52 am |
| Hi Chester,
Thanks for the tip.
I was thinking only roll it back just to export the deleted posting and then
restore to a clean backup.
but that then raises the question - "If you export a posting from a database
in an unsupported data does that then make the database it is imported into
unsupported". <--- which I dont want to get into right now.
So Lam - it looks like you need to restore to a clean backup to export the
posting.
Regards
--
________________________________________
Angus Logan (MCAD/MCDBA/MCP/MVP for MCMS)
Product Specialist
Microsoft Application Solutions
Data#3 Limited
E angus_logan@data3.com.au
BLOG www.anguslogan.com
________________________________________
"Chester Ragel" <Chesterr@Gmail.Com> wrote in message
news:uGo%23uOQZFHA.2288@TK2MSFTNGP14.phx.gbl...
> Hi Angus,
>
> This is not a good idea. Rolling back transaction logs may make the MCMS
> database inconsistent -> it is a way of breaking the support boundary.
>
> Cheers,
> Chester.
>
> "Angus Logan [MVP]" <angus_logan@data3.com.au> wrote in message
> news:epg0Z6PZFHA.1088@TK2MSFTNGP14.phx.gbl...
> database
>
>
| |
| Chester Ragel 2005-05-30, 7:52 am |
| Hi Lam,
It is not a good idea to do like that. It may make your MCMS database
inconsistent. If you have a database backup (if you are sure that no
background processing has run) then you can request Microsoft support
service for recovery.
Cheers,
Chester.
"Lam" <Lam@discussions.microsoft.com> wrote in message
news:16F38F25-A2CF-4963-AFE6-03EF28D30F17@microsoft.com...
> Hi angus,
>
> Unfortunately, we do not have a db backup. Is restoring the transaction
log[vbcol=seagreen]
> a recommended way? Any other suggestion?
>
> Thanks.
>
> "Angus Logan [MVP]" wrote:
>
posting[vbcol=seagreen]
backup.[vbcol=seagreen]
| |
| Chester Ragel 2005-05-30, 7:52 am |
| Hi Angus,
You are welcome.
The point is that you may only wanted to import one deleted posting. But
with that posting, you may import incorrect data/relationships as well.
Which is surely not good for the database!
Cheers,
Chester.
"Angus Logan [MVP]" <angus_logan@data3.com.au> wrote in message
news:#C9OhUQZFHA.584@TK2MSFTNGP15.phx.gbl...
> Hi Chester,
>
> Thanks for the tip.
>
> I was thinking only roll it back just to export the deleted posting and
then
> restore to a clean backup.
>
> but that then raises the question - "If you export a posting from a
database
> in an unsupported data does that then make the database it is imported
into
> unsupported". <--- which I dont want to get into right now.
>
> So Lam - it looks like you need to restore to a clean backup to export the
> posting.
>
> Regards
> --
> ________________________________________
>
> Angus Logan (MCAD/MCDBA/MCP/MVP for MCMS)
> Product Specialist
> Microsoft Application Solutions
> Data#3 Limited
> E angus_logan@data3.com.au
> BLOG www.anguslogan.com
> ________________________________________
> "Chester Ragel" <Chesterr@Gmail.Com> wrote in message
> news:uGo%23uOQZFHA.2288@TK2MSFTNGP14.phx.gbl...
been[vbcol=seagreen]
transaction[vbcol=seagreen]
>
>
| |
|
| Thanks Angus and Chester for your big help.
"Chester Ragel" wrote:
> Hi Angus,
>
> You are welcome.
>
> The point is that you may only wanted to import one deleted posting. But
> with that posting, you may import incorrect data/relationships as well.
> Which is surely not good for the database!
>
> Cheers,
> Chester.
>
> "Angus Logan [MVP]" <angus_logan@data3.com.au> wrote in message
> news:#C9OhUQZFHA.584@TK2MSFTNGP15.phx.gbl...
> then
> database
> into
> been
> transaction
>
>
>
|
|
|
|