I was facing same problem once after shrinking log files(reducing VLFs) recovery is fast.

Sorry,I mean recovery phases

We have Enterprise Evalation edition for 180 days trail,Further i dont think there is Enterprise edition or Standard Edition.

Truncate log command will not work on SQL 2008.

I tried this option and worked for me DBCC Shrinkfile(logfile number,space in mb,truncateonly)

I too have facedSimilar problem ,

I restored the database with another database backup which is too less in size(100Mb).Further i dropped the database it worked from SQL console as well...

Yep,I too agree 2Gb is OK for OS.

If you are on 32bit need to enable 3Gb switch in boot.ini file and AWE on SQL Server.max 6.5 GB and minimum 1.5 GB server memory is OK.

Chandra

Please try repair option once.

Database mirroring or logshipping is a good suggestion but problem is we are doing data center migration along with DB servers and there are other application servers as well.

But source...

Thanks everybody,

Storage team is performing SNAP mirror a NETAPP tool,The snap mirror is not freezing I/O on drives while copying data. In be in safer end i will take backups...

I too agree same as of above.

Once SQL Server 2005 SP3 has been applied, it cannot be removed without uninstalling the entire SQL Sever.

To remove SP3 and revert to the...

Hi Shiv

I hope you are upgrading your SQL Server from RTM version to SP2 or SP3.

The below are the steps followed.

1.Make sure you have recent backups for all databases(system,user dbs).

2.A...

hey needs to be performed by using T-SQL method.

hmmm

Some times in these cases Continue_After_Error option will be work.

Basically database restore process will continue when we use Continue_After_Restore it instucts backup to continue despite of encountering the error such...

Yes,SSAS and SSRS can be installed latter also.

The only difference in SSRS is ReportServer and ReportServerTempdb needs to be created using SSRS configuration manger.But the ReportServer,ReportServerTempdb will be created in...