I got this question in a interview.

So we cannot get the size of database when we created it if we provide other than model database size ?

We can restore the file group or files, but what about other tables which are in that file group. they will get effected ?

If this table only resides on that...

Do we have any other solution rather than restore and import\export, as it is a big database, it will take lot of time etc....

GUYS FYI: I am not a fake guy, jst asked if I get any help from you guys or not.

if you think this will encourage the fake guys, np, I...

Thanks All for your valuable suggestions, it was nice discussion.

If possible can you please provide the SQL Server interview questions ?

Yes, but also tried with GUY, no use. still failed.

Grant Fritchey (2/1/2011)

---

If I were running the interview I'd want to hear a lot more than just that you'd taken the tail backup. I'd want to know which backups you...

its using sqlagent service accounts, which is same for both the servers, as we use same service accounts for all the systems which are in same domain.

Thank You EveryOne for your help.

Its an cluster node and having the sqlagent issue on 3 instances out of 15 instances.

I think if its due to kerbos every instance should affect by that one.

Let me...

Indirectly, background operation when we run the bulk insert operation ?

Guys,

Still no replies.

please do the needful.

Yes....

how to create that object ?

above solution is not working.

below is the error:

Msg 208, Level 16, State 1, Procedure IndexOptimize, Line 187

Invalid object name 'dbo.DatabaseSelect'.