no errors in errorlog.

The database is in recovery mode since 3months.so i am not able find any logs in sqlserverlog.

There is enough space in the drive.

select * from sys.databases where name = 'dbname'

state_desc = RECOVERING

yes, i am still not able to open the url.

that url is not opening.

so how to move the table to another filegroup?

yes, i need a backup of the database excluding some tables.

thanks..........

there is only one primary filegroup in my database.

i have created one file group FG1.

how to move tables to FG1.

thanks..........

can you please explain clearly..........

Please correct the below query..........

select max(myDate) from

( select field_1 myDate from myTable

union all

select field_2 myDate from myTable

union all

select field_3 myDate from myTable)

I am not able to provide the sample data.

can you pls provide the sample query?

selecting one greatest value from 3 coloumns in a table.?

selecting one greatest value from 3 coloumns.?

currently my templog.ldf is 120gb.

i am not able to shrink the file because the tempdb is not responding properly.

what is the default size of temp db?

my problem is temp db is growing continuously.

how to restrict the size.