RE: [sap-basis] System copy
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by D. Caddick (SAP NetWeaver/BASIS Consultant) on Mar 27 at 10:18 AM |  Mark as helpful |
Hi Mridul
Did you create backup devices in SQL Server Management Studio? Try to
create a device pointing to file xyz.trn
Regards
From: mridulg via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 27 March 2010 05:28
To: D. Caddick
Subject: Re: [sap-basis] System copy
Posted by mridulg (Analyst)
on Mar 27 at 1:35 AM
<http://it.toolbox.com/api/ContentVote/3402507/1/1 /> Mark this reply as
helpfulMark as helpful
Hi Caddick,
There is no backup device attached to it, I took backup of source and saved
on disk, the format was xyz.trn for transactional log backup. I copied the
backup to the target on local drive, I have restored successfully the full
backup( abc.bak) and now trying to restore from xyz.trn but when doing faces
the error I mentioned. The <dbsid> that I configured is still in restore
mode.
Regards,
Mridul
On Fri, Mar 26, 2010 at 10:58 PM, D. Caddick via sap-basis <
sap-basis@groups.ittoolbox.com> wrote:
>
> Posted by D. Caddick (SAP
> NetWeaver/BASIS Consultant)
> on Mar 26 at 1:28 PM
> Hi Mridul
>
>
>
> No I am talking about the target system. You are trying to apply
> Transaction
> Logs from the Source System, right?
>
>
>
> Regards
>
>
>
> From: mridulg via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
> Sent: 26 March 2010 13:15
> To: D. Caddick
> Subject: Re: [sap-basis] System copy
>
>
>
>
>
>
>
>
> Posted by mridulg (Analyst)
> on Mar 26 at 9:14 AM
>
> <http://it.toolbox.com/api/ContentVote/3400911/1/1 /> Mark this reply as
> helpfulMark as helpful
>
> Hi Caddick,
>
> Please pardon me I am new to MSSQL, are you talking of the source sytem,
if
>
> yes then you are right that I do not have permission. So you think the
> issue
>
> is permission related, how can I solve this.
>
> Regards,
> Mridul
>
>
> On Fri, Mar 26, 2010 at 6:11 PM, D. Caddick via sap-basis <
> sap-basis@groups.ittoolbox.com> wrote:
>
> >
> > Posted by D. Caddick (SAP
> > NetWeaver/BASIS Consultant)
> > on Mar 26 at 8:42 AM
> > Hi Mridul,
> >
> >
> >
> > Using SQL Server Management Studio select the database -> Server Objects
> ->
> >
> > Backup Devices
> >
> > Double click the Log Backup device and Select the Media Contents Tab.
> >
> >
> >
> > If you can't see the detail there must be a permission issue with the
> > Transaction Log file.
> >
> >
> >
> > Regards
> >
> >
> >
> > From: mridulg via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
> > Sent: 26 March 2010 09:31
> > To: D. Caddick
> > Subject: Re: [sap-basis] System copy
> >
> >
> >
> >
> >
> >
> >
> >
> > Posted by mridulg (Analyst)
> > on Mar 26 at 5:33 AM
> >
> > <http://it.toolbox.com/api/ContentVote/3400478/1/1 /> Mark this reply as
>
> > helpfulMark as helpful
> >
> > Hi Caddick,
> >
> > the DB is in resotre mode adn yes , I m using MS SQL Server Management
> > Studio.
> > How can I make attachment visible? I am attaching it again.
> >
> > Regards,
> > Mridul
> >
> >
> >
> > Regards,
> > Mridul
> >
> > On Fri, Mar 26, 2010 at 2:04 PM, D. Caddick via sap-basis <
> > sap-basis@groups.ittoolbox.com> wrote:
> >
> > >
> > > Posted by D. Caddick (SAP
> > > NetWeaver/BASIS Consultant)
> > > on Mar 26 at 4:38 AM
> > > Hi Mridul,
> > >
> > >
> > >
> > > Is the database still in read only? We can't see attachments in this
> > group.
> > >
> > >
> > > Are you using the MS SQL Server Management Studio to perform the
> restore?
> >
> > >
> > >
> > >
> > > Regards
> > >
> > >
> > >
> > > From: mridulg via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
> > > Sent: 26 March 2010 05:44
> > > To: D. Caddick
> > > Subject: Re: [sap-basis] System copy
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Posted by mridulg (Analyst)
> > > on Mar 26 at 1:53 AM
> > >
> > > <http://it.toolbox.com/api/ContentVote/3400125/1/1 /> Mark this reply
> as
>
> >
> > > helpfulMark as helpful
> > >
> > > Hi Caddick,
> > >
> > > I read the guide and note given by you and I read SAP Note 193816 -
> > Restore
> > >
> > > with SQL Server in addition to the note u mentioned. In note 151603 I
> > have
> >
> > > some confusion like do I need to perform steps 4-7 as I am using
> > > backup/restore technique not attach/detach. After installing MSSQL
2005
>
> > > on tgt system I restored the full backup that I took from source
> system,
>
> > > now
> > >
> > > when I am trying to apply the transaction log backup to the tgt DB it
> > > throws
> > >
> > > error (You must select a restore source) even after the correct path
of
>
> > the
> > >
> > > transaction log backup file is given, I have attached the screenshot
of
>
> > the
> > >
> > > error for your reference.
> > >
> > > Snowy,
> > >
> > > I already signed in on that site but there is no file for download.
> > >
> > > Regards,
> > > Mridul
> > >
> > >
> > > On Thu, Mar 25, 2010 at 9:34 PM, D. Caddick via sap-basis <
> > > sap-basis@groups.ittoolbox.com> wrote:
> > >
> > > >
> > > > Posted by D. Caddick (SAP
> > > > NetWeaver/BASIS Consultant)
> > > > on Mar 25 at 12:11 PM
> > > > Hi Mridul,
> > > >
> > > >
> > > >
> > > > Your best option is to use the SAP supplied System Copy Guide and
SAP
>
> > > note
> > >
> > > > 151603 for SQL Server System copies.
> > > >
> > > >
> > > >
> > > > Regards
> > > >
> > > >
> > > >
> > > > From: mridulg via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
> > > > Sent: 25 March 2010 14:39
> > > > To: D. Caddick
> > > > Subject: Re: [sap-basis] System copy
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Posted by mridulg (Analyst)
> > > > on Mar 25 at 10:40 AM
> > > >
> > > > <http://it.toolbox.com/api/ContentVote/3398487/1/1 /> Mark this
> reply
> > as
> >
> > >
> > > > helpfulMark as helpful
> > > >
> > > > hi snowy,
> > > >
> > > > there is no document over there, I went on the link
> > > > http://www.basisconsultant.com/component/remository
> > > > /Sytem-Copy-Guides/Homogeneous-System-Copy-for-Win do
ws--and--MSSQL/
>
> > > > but
> > > > there was nothing other than a child pic enjoying music on ipod :D
> > > >
> > > > rgds,
> > > > Mridul
> > > >
> > > > On Thu, Mar 25, 2010 at 6:38 PM, Snowy via sap-basis <
> > > > sap-basis@groups.ittoolbox.com> wrote:
> > > >
> > > > > Posted by Snowy(Certified Netweaver '04/Oracle Basis consultant)
> > > > > on Mar 25 at 9:34 AM
> > > > > Hi,
> > > > >
> > > > > there is a user based document that could help you on your
> questions.
> >
> > > > >
> > > > > search google with these keywords:
> > > > >
> > > > > Homogeneous System Copy for Windows/MSSQL - SAP Basis Community
> > > > >
> > > > > ---------------Original Message---------------
> > > > > From: A Prasad Rao
> > > > > Sent: Friday, November 01, 2002 5:33 AM
> > > > > Subject: System copy
> > > > >
> > > > > > Hai
> > > > > > We are planning to replicate from SAP Production to SAP testing
> > > server.
> > > >
> > > > > > After database copy, the transport request will be reset
> (provided
>
> > > same
> > > >
> > > > > SAP
> > > > > > <sid> is used ). We would like to restore the last transport
> > request
> >
> > > > into
> > > > >
> > > > > > the testing server after database copy. For this purpose, all
the
>
> > > > > transport
> > > > > > requests created in Testing Server before database copy is to be
> > > backed
> > > >
> > > > > up
> > > > > > and then restore after database copy so that last transport
> request
> >
> > > > > created
> > > > > > before database copy will be restored. .
> > > > > > I don't know which tables (where all transport requests
> information
> >
> > > > > resided)
> > > > > > and the procedure to restore the last transport request in the
> > > Testing
> > >
> > > > > > Server after database copy
> > > > > >
> > > > > > Thanks and regards
> > > > > > APR
__.____._ Did you create backup devices in SQL Server Management Studio? Try to
create a device pointing to file xyz.trn
Regards
From: mridulg via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 27 March 2010 05:28
To: D. Caddick
Subject: Re: [sap-basis] System copy
Posted by mridulg (Analyst)
on Mar 27 at 1:35 AM
<http://it.toolbox.com/api/ContentVote/3402507/1/1 /> Mark this reply as
helpfulMark as helpful
Hi Caddick,
There is no backup device attached to it, I took backup of source and saved
on disk, the format was xyz.trn for transactional log backup. I copied the
backup to the target on local drive, I have restored successfully the full
backup( abc.bak) and now trying to restore from xyz.trn but when doing faces
the error I mentioned. The <dbsid> that I configured is still in restore
mode.
Regards,
Mridul
On Fri, Mar 26, 2010 at 10:58 PM, D. Caddick via sap-basis <
sap-basis@groups.ittoolbox.com> wrote:
>
> Posted by D. Caddick (SAP
> NetWeaver/BASIS Consultant)
> on Mar 26 at 1:28 PM
> Hi Mridul
>
>
>
> No I am talking about the target system. You are trying to apply
> Transaction
> Logs from the Source System, right?
>
>
>
> Regards
>
>
>
> From: mridulg via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
> Sent: 26 March 2010 13:15
> To: D. Caddick
> Subject: Re: [sap-basis] System copy
>
>
>
>
>
>
>
>
> Posted by mridulg (Analyst)
> on Mar 26 at 9:14 AM
>
> <http://it.toolbox.com/api/ContentVote/3400911/1/1 /> Mark this reply as
> helpfulMark as helpful
>
> Hi Caddick,
>
> Please pardon me I am new to MSSQL, are you talking of the source sytem,
if
>
> yes then you are right that I do not have permission. So you think the
> issue
>
> is permission related, how can I solve this.
>
> Regards,
> Mridul
>
>
> On Fri, Mar 26, 2010 at 6:11 PM, D. Caddick via sap-basis <
> sap-basis@groups.ittoolbox.com> wrote:
>
> >
> > Posted by D. Caddick (SAP
> > NetWeaver/BASIS Consultant)
> > on Mar 26 at 8:42 AM
> > Hi Mridul,
> >
> >
> >
> > Using SQL Server Management Studio select the database -> Server Objects
> ->
> >
> > Backup Devices
> >
> > Double click the Log Backup device and Select the Media Contents Tab.
> >
> >
> >
> > If you can't see the detail there must be a permission issue with the
> > Transaction Log file.
> >
> >
> >
> > Regards
> >
> >
> >
> > From: mridulg via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
> > Sent: 26 March 2010 09:31
> > To: D. Caddick
> > Subject: Re: [sap-basis] System copy
> >
> >
> >
> >
> >
> >
> >
> >
> > Posted by mridulg (Analyst)
> > on Mar 26 at 5:33 AM
> >
> > <http://it.toolbox.com/api/ContentVote/3400478/1/1 /> Mark this reply as
>
> > helpfulMark as helpful
> >
> > Hi Caddick,
> >
> > the DB is in resotre mode adn yes , I m using MS SQL Server Management
> > Studio.
> > How can I make attachment visible? I am attaching it again.
> >
> > Regards,
> > Mridul
> >
> >
> >
> > Regards,
> > Mridul
> >
> > On Fri, Mar 26, 2010 at 2:04 PM, D. Caddick via sap-basis <
> > sap-basis@groups.ittoolbox.com> wrote:
> >
> > >
> > > Posted by D. Caddick (SAP
> > > NetWeaver/BASIS Consultant)
> > > on Mar 26 at 4:38 AM
> > > Hi Mridul,
> > >
> > >
> > >
> > > Is the database still in read only? We can't see attachments in this
> > group.
> > >
> > >
> > > Are you using the MS SQL Server Management Studio to perform the
> restore?
> >
> > >
> > >
> > >
> > > Regards
> > >
> > >
> > >
> > > From: mridulg via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
> > > Sent: 26 March 2010 05:44
> > > To: D. Caddick
> > > Subject: Re: [sap-basis] System copy
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Posted by mridulg (Analyst)
> > > on Mar 26 at 1:53 AM
> > >
> > > <http://it.toolbox.com/api/ContentVote/3400125/1/1 /> Mark this reply
> as
>
> >
> > > helpfulMark as helpful
> > >
> > > Hi Caddick,
> > >
> > > I read the guide and note given by you and I read SAP Note 193816 -
> > Restore
> > >
> > > with SQL Server in addition to the note u mentioned. In note 151603 I
> > have
> >
> > > some confusion like do I need to perform steps 4-7 as I am using
> > > backup/restore technique not attach/detach. After installing MSSQL
2005
>
> > > on tgt system I restored the full backup that I took from source
> system,
>
> > > now
> > >
> > > when I am trying to apply the transaction log backup to the tgt DB it
> > > throws
> > >
> > > error (You must select a restore source) even after the correct path
of
>
> > the
> > >
> > > transaction log backup file is given, I have attached the screenshot
of
>
> > the
> > >
> > > error for your reference.
> > >
> > > Snowy,
> > >
> > > I already signed in on that site but there is no file for download.
> > >
> > > Regards,
> > > Mridul
> > >
> > >
> > > On Thu, Mar 25, 2010 at 9:34 PM, D. Caddick via sap-basis <
> > > sap-basis@groups.ittoolbox.com> wrote:
> > >
> > > >
> > > > Posted by D. Caddick (SAP
> > > > NetWeaver/BASIS Consultant)
> > > > on Mar 25 at 12:11 PM
> > > > Hi Mridul,
> > > >
> > > >
> > > >
> > > > Your best option is to use the SAP supplied System Copy Guide and
SAP
>
> > > note
> > >
> > > > 151603 for SQL Server System copies.
> > > >
> > > >
> > > >
> > > > Regards
> > > >
> > > >
> > > >
> > > > From: mridulg via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
> > > > Sent: 25 March 2010 14:39
> > > > To: D. Caddick
> > > > Subject: Re: [sap-basis] System copy
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Posted by mridulg (Analyst)
> > > > on Mar 25 at 10:40 AM
> > > >
> > > > <http://it.toolbox.com/api/ContentVote/3398487/1/1 /> Mark this
> reply
> > as
> >
> > >
> > > > helpfulMark as helpful
> > > >
> > > > hi snowy,
> > > >
> > > > there is no document over there, I went on the link
> > > > http://www.basisconsultant.com/component/remository
> > > > /Sytem-Copy-Guides/Homogeneous-System-Copy-for-Win do
ws--and--MSSQL/
>
> > > > but
> > > > there was nothing other than a child pic enjoying music on ipod :D
> > > >
> > > > rgds,
> > > > Mridul
> > > >
> > > > On Thu, Mar 25, 2010 at 6:38 PM, Snowy via sap-basis <
> > > > sap-basis@groups.ittoolbox.com> wrote:
> > > >
> > > > > Posted by Snowy(Certified Netweaver '04/Oracle Basis consultant)
> > > > > on Mar 25 at 9:34 AM
> > > > > Hi,
> > > > >
> > > > > there is a user based document that could help you on your
> questions.
> >
> > > > >
> > > > > search google with these keywords:
> > > > >
> > > > > Homogeneous System Copy for Windows/MSSQL - SAP Basis Community
> > > > >
> > > > > ---------------Original Message---------------
> > > > > From: A Prasad Rao
> > > > > Sent: Friday, November 01, 2002 5:33 AM
> > > > > Subject: System copy
> > > > >
> > > > > > Hai
> > > > > > We are planning to replicate from SAP Production to SAP testing
> > > server.
> > > >
> > > > > > After database copy, the transport request will be reset
> (provided
>
> > > same
> > > >
> > > > > SAP
> > > > > > <sid> is used ). We would like to restore the last transport
> > request
> >
> > > > into
> > > > >
> > > > > > the testing server after database copy. For this purpose, all
the
>
> > > > > transport
> > > > > > requests created in Testing Server before database copy is to be
> > > backed
> > > >
> > > > > up
> > > > > > and then restore after database copy so that last transport
> request
> >
> > > > > created
> > > > > > before database copy will be restored. .
> > > > > > I don't know which tables (where all transport requests
> information
> >
> > > > > resided)
> > > > > > and the procedure to restore the last transport request in the
> > > Testing
> > >
> > > > > > Server after database copy
> > > > > >
> > > > > > Thanks and regards
> > > > > > APR
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
D. CaddickSAP Basis Top Contributor
Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
