Problem whit Logshipping Error 952

Hi,

I have a problem with Log Shipping.

I implement Log Shipping in 2 servers with Sql 2005, but when i drop log shipping at the first server the second server locks the DB. I can not copy, drop or select any table, object...

The second server displays the following messaje

Error 952 - Database '%.*ls' is in transition. Try the statement later.

Any help you can give to me to the resolve this cuestion?

Thanks

>> " i drop log shipping at the first server"

Did you do that from the LS UI or running the LS stored precedures ?

thanks

Yunwen

Problem while restoring my Backup

This is my problem
I do a full Database BackUp with INIT at 01h30
Then I do a Full Transation Log with INIT at 7h00
Then each hour between 8h00 to 22h00 I do a Full Transaction Log with NO_INIT
When i ask to recover one of my Bakcup between 7h00 to 22h00
I got this message:
The log in this backup set begins at LSN 127000000005700001, which is ...
What's the problem (I use a SQLServer 2000)You need to apply all the log backups, in sequence, sine the latest database
backup:
RESTORE DATABASE... WITH NORECOVERY
RESTORE LOG ... WITH NORECOVERY
RESTORE LOG ... WITH NORECOVERY
...
RESTORE LOG ... WITH RECOVERY
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Guy Tanguay" <guy_tanguay@.hotmail.com> wrote in message
news:3b53412a.0402061042.cdfe4b1@.posting.google.com...
> This is my problem
> I do a full Database BackUp with INIT at 01h30
> Then I do a Full Transation Log with INIT at 7h00
> Then each hour between 8h00 to 22h00 I do a Full Transaction Log with
NO_INIT
> When i ask to recover one of my Bakcup between 7h00 to 22h00
> I got this message:
> The log in this backup set begins at LSN 127000000005700001, which is ...
> What's the problem (I use a SQLServer 2000)

Problem while restoring my Backup

This is my problem
I do a full Database BackUp with INIT at 01h30
Then I do a Full Transation Log with INIT at 7h00
Then each hour between 8h00 to 22h00 I do a Full Transaction Log with NO_INI
T
When i ask to recover one of my Bakcup between 7h00 to 22h00
I got this message:
The log in this backup set begins at LSN 127000000005700001, which is ...
What's the problem (I use a SQLServer 2000)You need to apply all the log backups, in sequence, sine the latest database
backup:
RESTORE DATABASE... WITH NORECOVERY
RESTORE LOG ... WITH NORECOVERY
RESTORE LOG ... WITH NORECOVERY
...
RESTORE LOG ... WITH RECOVERY
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Guy Tanguay" <guy_tanguay@.hotmail.com> wrote in message
news:3b53412a.0402061042.cdfe4b1@.posting.google.com...
> This is my problem
> I do a full Database BackUp with INIT at 01h30
> Then I do a Full Transation Log with INIT at 7h00
> Then each hour between 8h00 to 22h00 I do a Full Transaction Log with
NO_INIT
> When i ask to recover one of my Bakcup between 7h00 to 22h00
> I got this message:
> The log in this backup set begins at LSN 127000000005700001, which is ...
> What's the problem (I use a SQLServer 2000)

Problem when trying to deploy a web site built with asp.net 2.0 and using SQL EXPRESS

Hi,

Plz help!

I built a web site using IIS and ASP.NET 2.0.

My web site has a log on screen and I only configured it with one user without any roles. This web site uses the SQL EXPRESS.(I Have 2 databases: 1 for the security required by the application and the other for my application. for the connectionstring I used a windows authentication security with an instance = true.)

Everything went well on my PC.

When I tried to deploy the web site on another PC, there was a big problem.

When I tried to login with the same user I created, then I have a problem.

The password is incorrect(Why? I don't know).

Maybe there is a problem with the IIS or with the SQL SERVER.

pLZ HELP!!

You should take a look at the forum at http://forums.asp.net/54/ShowForum.aspx, which covers Visual Web Designer. They will have a better idea how to address this.

Mike

problem when activating the replication

Hi,
as soon as I enable the replication, I get an red X on
replication Monitor\agents\log reader agents
replication Monitor\agents\distribution agents
publishers\machinename
I use to replicate on this machine but since I disabled it once, can't
re-enable it.
SQL 2000 sp3
thanks
Alex
Can you post any error details that show up in the agents to help us to
track this down?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Alexandre" <nospam@.nospam.net> wrote in message
news:%23PdgoSC9EHA.960@.TK2MSFTNGP11.phx.gbl...
> Hi,
> as soon as I enable the replication, I get an red X on
> replication Monitor\agents\log reader agents
> replication Monitor\agents\distribution agents
> publishers\machinename
> I use to replicate on this machine but since I disabled it once, can't
> re-enable it.
> SQL 2000 sp3
> thanks
> Alex
>
|||There are no errors anywhere in the agents and now the replication works but
I still have the red X as mentionned below...
anywhere else I can look for errors?
Alex.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:e9fB6VC9EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Can you post any error details that show up in the agents to help us to
> track this down?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "Alexandre" <nospam@.nospam.net> wrote in message
> news:%23PdgoSC9EHA.960@.TK2MSFTNGP11.phx.gbl...
>
|||you probably have a phantom error.
run sp_MSload_replication_status
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Alexandre" <nospam@.nospam.net> wrote in message
news:Oun0gpC9EHA.2180@.TK2MSFTNGP12.phx.gbl...
> There are no errors anywhere in the agents and now the replication works
but
> I still have the red X as mentionned below...
> anywhere else I can look for errors?
> Alex.
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:e9fB6VC9EHA.3416@.TK2MSFTNGP09.phx.gbl...
>