Question is tricky. At a glance, it seems to have syntax error as there in no GROUP BY clause.

But, if we ignore it then 🙂

Thanks Manu.

Yes, the PRIMARY filegroup will be restored before restoring the target filegroup. But it marks the other filegroups offline.

So, how to take these filegroups back online?

I have tried partial restore but it is making other filegroups offline.

You can use sys.sysaltfiles view, it would give all the required fields. But instead of giving filegroup name it would give groupid.

Another way...you can run system procedure xp_helpdb to get all the db sizes in an instance.

Check if it helps:

http://social.msdn.microsoft.com/Forums/en/sqldatabasemirroring/thread/4bc8ce58-61e9-4ee2-82c8-48556f8e4ae1

Before doing anything please modify your select query to

SELECT fielda,fieldb,fieldc ...

FROM TableB b

JOIN TableC c

ON b.fieldb = c.fieldx

AND fielda <>0

Using IN clause in SELECT would causing a full...

I have little doubt on the second option 'When the session that created it ends'.

If the global table is referenced by some other session at that time (like the...