if you backup...

Jagger (7/14/2009)

---

Just I have table with customer data, where I have column zip code and city.

I'd like to create new table with customer data where this column should be in...

Yes this could be a possible reason. Since transactions are not read by the logread.exe, logs on publisher wont be truncated and will continue to grow.

There is a seperate thread running for status of dbs. Please post your replies Here

Well, Not much idea of how u implement it in integration services.

Someone with better knowledge should help you out 🙂

declare @str1 varchar(100)

set @str1='60601 Chicago'

select left(@str1,charindex(' ',@str1)-1) as ZIP, right(@str1,len(@str1)-charindex(' ',@str1))as City

OUTPUT:-

----------

ZIP City

--------- ---------

60601 Chicago

(1 row(s) affected)

Assumption: ZIP and...

This can happen if your log reader agent is not running OR coz of any issue...

I suppose by mistake you added a Poll instead of Topic.

Anyways, can you copy the backup file to a different location and then try to restore the database?

declare @str1 varchar(100)

set @str1='ServerName1\Dev'

select left(@str1,charindex('\',@str1)-1)

I've assumed there is only one backslash in the string!!

It'd be great for everyone if you share the solution here 🙂

There are many tools available like SQL Compare, if you dont have one, you can use Microsoft's TableDiff utility.

see Here

This may happen as the full backup consists of transactions from the log which are not written to datafile at the time of backup completion.

Thanks but i dont require the patch.

I need some docs/links on best practices on patch upgradation.

Perhaps he's getting data as...

select id, left(ivalue,charindex(';',ivalue)-1) as ivalue1, right(ivalue,len(ivalue)-charindex(';',ivalue)) as ivalue2 from Results

OUTPUT

-------

id ivalue1 ivalue2

----------- --------- ---------

1 ...