Is there a way to achieve this. Unfortunately we do not have a sdo backup. I
s
it possible through SQL server transaction log?

[ Post a follow-up to this message ]

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?

[ Post a follow-up to this message ]

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 posti
ng
> 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... 
>
>
>

[ Post a follow-up to this message ]

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:
> 

[ Post a follow-up to this message ]

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... 
>
>

[ Post a follow-up to this message ]

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 
>
>

[ Post a follow-up to this message ]

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] 

[ Post a follow-up to this message ]

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] 
>
>

[ Post a follow-up to this message ]

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 
>
>
>

[ Post a follow-up to this message ]