check the complete job, it might be having some other steps or there could be something else in your backup job script kind of copying backup to some other location,...

definately interview question.... 🙂

but as per my thoughts :-

1) unattended itself clearify the setup which left in between

2) to build 1000 server, you can restore the image of working server

http://www.sqlservercentral.com/articles/Database+Administration/62480/

when you saying connecting to server local, is that mean thats what you mentiong while connecting. Try to change it to actual servername istead of local.

i am able to get the result from both way using exec tablevariabletest(your sp)

There is no clustered index on the table and I need to create one, will fill factor 0.

How will this impact space utilization on disk? What about white space...

unfortunately I dont have 2000.

but once you open query analyser and on your left if you open object browser, you will be able to do whatever I already suggested...

Thanks Gail.

But I read the question as :-

Can any one clarify what will happen when we execute the below query..

And I consider that they are well aware of...

And as well once resolved put it back to Full recovery.

I dont like blame game so ...... :w00t: :w00t: 😀

it means you know how to do it in 2005/2008. Why not use that database in SSMS instead of EM.

In EM, you can try this :-

1) Right Click on table...

I will suggest, instead of shrinking the log you should go for changing the recovery option to simple because if you search further, you will come to know that with...

I am learning new things on Stock market trading....which is totally different of IT but interested.

I like it because it need the deep analysis like DBA work and if...

do you have any other small database for test?

just for test, can you try this:-

backup source database

resotre on destination.

configure distributor on both if its merge,peer-to-peer or transactional replication.

then configure publisher...

i will suggest insetead of shrinking the log, change the DB to simple recovery.

are you not getting it in result pane?