then what is the meaning of your secondary if you have to restore this much?

hi Sushant,

copying backup file to safe location I suggested for , incase something happen your secondary and get corrupted.

Anyway, yes so to bring your seconday as primary, you need...

as i replied

http://www.sqlservercentral.com/Forums/Topic987793-146-1.aspx

you need to create linked server for this.

you cant reduce your database less than the data it consuming physically now which you can check by sp_spaceused.

because its friday so....alternate answer of your question is :-

you cant sqeeze...

then this article will help you

http://www.mssqltips.com/tip.asp?tip=1555

if your query about finding a specific column in related tables then

SELECT t.name AS table_name,

SCHEMA_NAME(schema_id) AS schema_name,

c.name AS column_name

FROM sys.tables AS t

INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID

WHERE...

if you can explain further that what exactly your table should be look like after running the query, i can try to write the query

have you tried by this :-

update table1 set city = a.inputcity

from table2 a

where ...... whatever condition you have

as mentioned in BOL

Performs a bitwise exclusive OR operation of two integer values. It compares each bit of its first operand to the corresponding bit of its second operand. If...

you need to create the linked server first with your remote server and then you can specify in your job step as :-

use msdb

go

exec linkedservername.msdb.dbo.sp_start_job

...

because ssis is not available in sql server 2000. Please refer original post.

interested to know about edition of sql server.

sqldoc is one of the tool from redgate.

DTS may fulfill your requirememnt and then that DTS can be scheduled in job

Thanks for correcting me gail.

yes, we can continue with log restoration on secondary even if we take the full backup on primary in between.