How can i make sure that my backup job(starts @ 7pm) should run only during nights on a schdueled day and if it takes more than 9 am the job...

Craig

Its not the link server connection, I am trying to connect to 2008 database engine from the sql 2005 interface.

yes i can ping to 2008 server, its not just with this server all my sql servers(2005) can not connect to 2008 database engine but i can not the other...

its an enterprise edition and TCP\IP is Enabled

Derrick

I understand your concern and my database has only 5 tables which are huge and all 5 of them are condidates for compression as i am restoring a 2005 database...

Is this persistent or just after a server startup?

-- Yes problem persists all the time

Have you rebooted the server?

-- Many times

How much free disk space do you have?

-- so much...

I am having this problem in 2005, how about this?

I do save trace files to a dataabse every 10 min but still i dont find any information for this particular database from the last 3 weeks, this is weired...

I am into the same situation but the aboce script didnt help me find out the culprit. All of a sudden one of the database disappears which was available 3...

Actually i created that job some time back but i did not schduleed it some one else has shcduled yesterday which messed up a database. I would look to pull...

any idea how to achieve this?

ok here is the thing..

I want ot use this query for my backup jobs so both of these queries would go into 2 diffferent jobs and like your example if...

how would you get the rest of the databases?

i tried "top 50 percent" but i does not work with distinct and also for bottom 50%

Here is the logic i am looking for.

ServerA.RevProd (Column1,Column2,Column3,Column4,EmpNo) - Column1-4 are composite key

ServerB.BudProd (EmpNo,EmpNo_Old)

Here EmpNo on serverA is same as EmpNo_Old on ServerB so by mapping them i have...