Hi,
I have Production database that needs to copied over to Developement
envirnoment where our developers can debug the issues we have in production.
I decided to go with log shipping and scheduled it to copy log every night to
Developemnt from Production.It worked fine...but the database was on
developement(seondry server)in read-only mode which when I tried to remove
gave me an error "database is in warm standby mode, alter database option
fails"
How do I do that developer would have full access (Not in Read-Only)to that
database on secondry server.
I tried to delete the log shipping (with the fear if the changes made to
seondry appear in primary database) and delete the log shipping from
maitenance plan but still not able to bring the database on secondry out of
read0only mode.
Thanks
ShanRESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
restore any further transaction log backups after this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
> Hi,
> I have Production database that needs to copied over to Developement
> envirnoment where our developers can debug the issues we have in production.
> I decided to go with log shipping and scheduled it to copy log every night to
> Developemnt from Production.It worked fine...but the database was on
> developement(seondry server)in read-only mode which when I tried to remove
> gave me an error "database is in warm standby mode, alter database option
> fails"
> How do I do that developer would have full access (Not in Read-Only)to that
> database on secondry server.
> I tried to delete the log shipping (with the fear if the changes made to
> seondry appear in primary database) and delete the log shipping from
> maitenance plan but still not able to bring the database on secondry out of
> read0only mode.
> Thanks
> Shan|||Thanks for your reply, It worked. Then what kind of approach I should be
adapting when I have to backup database from one server to another server on
regular bases provided that databases on secondry server available to user
for all activities(Not Read-Only). Through the wizard the only two options I
see is "No Recovery" and "Standby".
Thanks
Shan
"Tibor Karaszi" wrote:
> RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
> restore any further transaction log backups after this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Shan" <Shan@.discussions.microsoft.com> wrote in message
> news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
> > Hi,
> >
> > I have Production database that needs to copied over to Developement
> > envirnoment where our developers can debug the issues we have in production.
> > I decided to go with log shipping and scheduled it to copy log every night to
> > Developemnt from Production.It worked fine...but the database was on
> > developement(seondry server)in read-only mode which when I tried to remove
> > gave me an error "database is in warm standby mode, alter database option
> > fails"
> >
> > How do I do that developer would have full access (Not in Read-Only)to that
> > database on secondry server.
> >
> > I tried to delete the log shipping (with the fear if the changes made to
> > seondry appear in primary database) and delete the log shipping from
> > maitenance plan but still not able to bring the database on secondry out of
> > read0only mode.
> >
> > Thanks
> >
> > Shan
>
>|||'That is not possible using backup and restore (which is what log shipping is using). How would you
expect to restore a backup based on a prior backup if you have done modifications in the database
since you restored that prior backup? You might want to look at replication instead. I suggest you
read:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:60664FEF-29FD-4F97-AEC9-F3AA4654586B@.microsoft.com...
> Thanks for your reply, It worked. Then what kind of approach I should be
> adapting when I have to backup database from one server to another server on
> regular bases provided that databases on secondry server available to user
> for all activities(Not Read-Only). Through the wizard the only two options I
> see is "No Recovery" and "Standby".
> Thanks
> Shan
> "Tibor Karaszi" wrote:
>> RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
>> restore any further transaction log backups after this.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "Shan" <Shan@.discussions.microsoft.com> wrote in message
>> news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
>> > Hi,
>> >
>> > I have Production database that needs to copied over to Developement
>> > envirnoment where our developers can debug the issues we have in production.
>> > I decided to go with log shipping and scheduled it to copy log every night to
>> > Developemnt from Production.It worked fine...but the database was on
>> > developement(seondry server)in read-only mode which when I tried to remove
>> > gave me an error "database is in warm standby mode, alter database option
>> > fails"
>> >
>> > How do I do that developer would have full access (Not in Read-Only)to that
>> > database on secondry server.
>> >
>> > I tried to delete the log shipping (with the fear if the changes made to
>> > seondry appear in primary database) and delete the log shipping from
>> > maitenance plan but still not able to bring the database on secondry out of
>> > read0only mode.
>> >
>> > Thanks
>> >
>> > Shan
>>
Showing posts with label debug. Show all posts
Showing posts with label debug. Show all posts
Monday, March 26, 2012
how delete Log Shipping?
Hi,
I have Production database that needs to copied over to Developement
envirnoment where our developers can debug the issues we have in production.
I decided to go with log shipping and scheduled it to copy log every night t
o
Developemnt from Production.It worked fine...but the database was on
developement(seondry server)in read-only mode which when I tried to remove
gave me an error "database is in warm standby mode, alter database option
fails"
How do I do that developer would have full access (Not in Read-Only)to that
database on secondry server.
I tried to delete the log shipping (with the fear if the changes made to
seondry appear in primary database) and delete the log shipping from
maitenance plan but still not able to bring the database on secondry out of
read0only mode.
Thanks
ShanRESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But y
ou won't be able to
restore any further transaction log backups after this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
> Hi,
> I have Production database that needs to copied over to Developement
> envirnoment where our developers can debug the issues we have in productio
n.
> I decided to go with log shipping and scheduled it to copy log every night
to
> Developemnt from Production.It worked fine...but the database was on
> developement(seondry server)in read-only mode which when I tried to remove
> gave me an error "database is in warm standby mode, alter database option
> fails"
> How do I do that developer would have full access (Not in Read-Only)to tha
t
> database on secondry server.
> I tried to delete the log shipping (with the fear if the changes made to
> seondry appear in primary database) and delete the log shipping from
> maitenance plan but still not able to bring the database on secondry out o
f
> read0only mode.
> Thanks
> Shan|||Thanks for your reply, It worked. Then what kind of approach I should be
adapting when I have to backup database from one server to another server on
regular bases provided that databases on secondry server available to user
for all activities(Not Read-Only). Through the wizard the only two options I
see is "No Recovery" and "Standby".
Thanks
Shan
"Tibor Karaszi" wrote:
> RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But
you won't be able to
> restore any further transaction log backups after this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Shan" <Shan@.discussions.microsoft.com> wrote in message
> news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
>
>|||'That is not possible using backup and restore (which is what log shipping i
s using). How would you
expect to restore a backup based on a prior backup if you have done modifica
tions in the database
since you restored that prior backup? You might want to look at replication
instead. I suggest you
read:
http://www.microsoft.com/technet/pr...oy/sqlhalp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:60664FEF-29FD-4F97-AEC9-F3AA4654586B@.microsoft.com...[vbcol=seagreen]
> Thanks for your reply, It worked. Then what kind of approach I should be
> adapting when I have to backup database from one server to another server
on
> regular bases provided that databases on secondry server available to user
> for all activities(Not Read-Only). Through the wizard the only two options
I
> see is "No Recovery" and "Standby".
> Thanks
> Shan
> "Tibor Karaszi" wrote:
>
I have Production database that needs to copied over to Developement
envirnoment where our developers can debug the issues we have in production.
I decided to go with log shipping and scheduled it to copy log every night t
o
Developemnt from Production.It worked fine...but the database was on
developement(seondry server)in read-only mode which when I tried to remove
gave me an error "database is in warm standby mode, alter database option
fails"
How do I do that developer would have full access (Not in Read-Only)to that
database on secondry server.
I tried to delete the log shipping (with the fear if the changes made to
seondry appear in primary database) and delete the log shipping from
maitenance plan but still not able to bring the database on secondry out of
read0only mode.
Thanks
ShanRESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But y
ou won't be able to
restore any further transaction log backups after this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
> Hi,
> I have Production database that needs to copied over to Developement
> envirnoment where our developers can debug the issues we have in productio
n.
> I decided to go with log shipping and scheduled it to copy log every night
to
> Developemnt from Production.It worked fine...but the database was on
> developement(seondry server)in read-only mode which when I tried to remove
> gave me an error "database is in warm standby mode, alter database option
> fails"
> How do I do that developer would have full access (Not in Read-Only)to tha
t
> database on secondry server.
> I tried to delete the log shipping (with the fear if the changes made to
> seondry appear in primary database) and delete the log shipping from
> maitenance plan but still not able to bring the database on secondry out o
f
> read0only mode.
> Thanks
> Shan|||Thanks for your reply, It worked. Then what kind of approach I should be
adapting when I have to backup database from one server to another server on
regular bases provided that databases on secondry server available to user
for all activities(Not Read-Only). Through the wizard the only two options I
see is "No Recovery" and "Standby".
Thanks
Shan
"Tibor Karaszi" wrote:
> RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But
you won't be able to
> restore any further transaction log backups after this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Shan" <Shan@.discussions.microsoft.com> wrote in message
> news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
>
>|||'That is not possible using backup and restore (which is what log shipping i
s using). How would you
expect to restore a backup based on a prior backup if you have done modifica
tions in the database
since you restored that prior backup? You might want to look at replication
instead. I suggest you
read:
http://www.microsoft.com/technet/pr...oy/sqlhalp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:60664FEF-29FD-4F97-AEC9-F3AA4654586B@.microsoft.com...[vbcol=seagreen]
> Thanks for your reply, It worked. Then what kind of approach I should be
> adapting when I have to backup database from one server to another server
on
> regular bases provided that databases on secondry server available to user
> for all activities(Not Read-Only). Through the wizard the only two options
I
> see is "No Recovery" and "Standby".
> Thanks
> Shan
> "Tibor Karaszi" wrote:
>
how delete Log Shipping?
Hi,
I have Production database that needs to copied over to Developement
envirnoment where our developers can debug the issues we have in production.
I decided to go with log shipping and scheduled it to copy log every night to
Developemnt from Production.It worked fine...but the database was on
developement(seondry server)in read-only mode which when I tried to remove
gave me an error "database is in warm standby mode, alter database option
fails"
How do I do that developer would have full access (Not in Read-Only)to that
database on secondry server.
I tried to delete the log shipping (with the fear if the changes made to
seondry appear in primary database) and delete the log shipping from
maitenance plan but still not able to bring the database on secondry out of
read0only mode.
Thanks
Shan
RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
restore any further transaction log backups after this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
> Hi,
> I have Production database that needs to copied over to Developement
> envirnoment where our developers can debug the issues we have in production.
> I decided to go with log shipping and scheduled it to copy log every night to
> Developemnt from Production.It worked fine...but the database was on
> developement(seondry server)in read-only mode which when I tried to remove
> gave me an error "database is in warm standby mode, alter database option
> fails"
> How do I do that developer would have full access (Not in Read-Only)to that
> database on secondry server.
> I tried to delete the log shipping (with the fear if the changes made to
> seondry appear in primary database) and delete the log shipping from
> maitenance plan but still not able to bring the database on secondry out of
> read0only mode.
> Thanks
> Shan
|||Thanks for your reply, It worked. Then what kind of approach I should be
adapting when I have to backup database from one server to another server on
regular bases provided that databases on secondry server available to user
for all activities(Not Read-Only). Through the wizard the only two options I
see is "No Recovery" and "Standby".
Thanks
Shan
"Tibor Karaszi" wrote:
> RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
> restore any further transaction log backups after this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Shan" <Shan@.discussions.microsoft.com> wrote in message
> news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
>
>
|||'That is not possible using backup and restore (which is what log shipping is using). How would you
expect to restore a backup based on a prior backup if you have done modifications in the database
since you restored that prior backup? You might want to look at replication instead. I suggest you
read:
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:60664FEF-29FD-4F97-AEC9-F3AA4654586B@.microsoft.com...[vbcol=seagreen]
> Thanks for your reply, It worked. Then what kind of approach I should be
> adapting when I have to backup database from one server to another server on
> regular bases provided that databases on secondry server available to user
> for all activities(Not Read-Only). Through the wizard the only two options I
> see is "No Recovery" and "Standby".
> Thanks
> Shan
> "Tibor Karaszi" wrote:
I have Production database that needs to copied over to Developement
envirnoment where our developers can debug the issues we have in production.
I decided to go with log shipping and scheduled it to copy log every night to
Developemnt from Production.It worked fine...but the database was on
developement(seondry server)in read-only mode which when I tried to remove
gave me an error "database is in warm standby mode, alter database option
fails"
How do I do that developer would have full access (Not in Read-Only)to that
database on secondry server.
I tried to delete the log shipping (with the fear if the changes made to
seondry appear in primary database) and delete the log shipping from
maitenance plan but still not able to bring the database on secondry out of
read0only mode.
Thanks
Shan
RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
restore any further transaction log backups after this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
> Hi,
> I have Production database that needs to copied over to Developement
> envirnoment where our developers can debug the issues we have in production.
> I decided to go with log shipping and scheduled it to copy log every night to
> Developemnt from Production.It worked fine...but the database was on
> developement(seondry server)in read-only mode which when I tried to remove
> gave me an error "database is in warm standby mode, alter database option
> fails"
> How do I do that developer would have full access (Not in Read-Only)to that
> database on secondry server.
> I tried to delete the log shipping (with the fear if the changes made to
> seondry appear in primary database) and delete the log shipping from
> maitenance plan but still not able to bring the database on secondry out of
> read0only mode.
> Thanks
> Shan
|||Thanks for your reply, It worked. Then what kind of approach I should be
adapting when I have to backup database from one server to another server on
regular bases provided that databases on secondry server available to user
for all activities(Not Read-Only). Through the wizard the only two options I
see is "No Recovery" and "Standby".
Thanks
Shan
"Tibor Karaszi" wrote:
> RESTORE DATABASE dbname WITH RECOVERY will bring it to "normal" state. But you won't be able to
> restore any further transaction log backups after this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Shan" <Shan@.discussions.microsoft.com> wrote in message
> news:73B4BCC5-DED7-48C2-95EA-D289EE3E0BB3@.microsoft.com...
>
>
|||'That is not possible using backup and restore (which is what log shipping is using). How would you
expect to restore a backup based on a prior backup if you have done modifications in the database
since you restored that prior backup? You might want to look at replication instead. I suggest you
read:
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Shan" <Shan@.discussions.microsoft.com> wrote in message
news:60664FEF-29FD-4F97-AEC9-F3AA4654586B@.microsoft.com...[vbcol=seagreen]
> Thanks for your reply, It worked. Then what kind of approach I should be
> adapting when I have to backup database from one server to another server on
> regular bases provided that databases on secondry server available to user
> for all activities(Not Read-Only). Through the wizard the only two options I
> see is "No Recovery" and "Standby".
> Thanks
> Shan
> "Tibor Karaszi" wrote:
Wednesday, March 7, 2012
How can i view the value of a variable during debug?
Thats the question... i can see the value of columns adding viewers, but how can i see variables?
Thanks!
Add a break point to one of your control flow tasks (by right clicking on it) and then when debug stops at that break point, you can go up to the Debug menu and select the Locals window to be displayed.|||Thanks Phil,
I do that, but my variable doesnt appear in the window...
|||Which window are you looking at? It should be in the Locals window; you have to expand the variables node...
|||Sorry for my delay rafael, i was on holidays ;-)
I am looking at "Debug/windows/local variables", but nothing appears in this window.
Edit: I finally found the solution, the problem was taht i didnt insert the break point on control flow. Regards.
How can i view the value of a variable during debug?
Thats the question... i can see the value of columns adding viewers, but how can i see variables?
Thanks!
Add a break point to one of your control flow tasks (by right clicking on it) and then when debug stops at that break point, you can go up to the Debug menu and select the Locals window to be displayed.|||Thanks Phil,
I do that, but my variable doesnt appear in the window...
|||Which window are you looking at? It should be in the Locals window; you have to expand the variables node...
|||Sorry for my delay rafael, i was on holidays ;-)
I am looking at "Debug/windows/local variables", but nothing appears in this window.
Edit: I finally found the solution, the problem was taht i didnt insert the break point on control flow. Regards.
Subscribe to:
Posts (Atom)