My question is when we execute a select query how server came to know that in which file is that particular data.....

Better try to find out the reason as Maverick said ,If ur sole aim is to shrink the log the best way is

change ur database recovery model to...

If u r still getting the error change ur database recovery model to 'SIMPLE' then run the DBCC SHRINKFILE command

dbcc shrinkfile (log_file_name,size)

Thanks for those words..Keep viewing the forum for more such error you have ever seen or heard.

USE [master]

GO

CREATE DATABASE [Adventureworks] ON

( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf' ),

( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Log.ldf' )

FOR ATTACH

GO

if not exists (select name from master.sys.databases sd where...

In SQL Server 2005 you can simply rename the database using GUI or using the command sp_renamedb old_name,new_name.

Hi JO thanks for ur reply ..

How to check the service pack in client machine????Is there any service pack for client machine???

In sql server 2005 enterprise edition you have the option for generating reports.If ur using sql express 2005 then upgrade to sql server 2005 express with advanced services ,this advanced...

Mike

Thanks for that tip....

Issue check point that will commit the uncommited transactions.

Backup the databse will do the same.

dbcc shrinkfile('log file path',size)....

If all these are not working then

take a full backup,change the recovery...

Definitely u can choose other locations..Not only in other folders u can also give ur mdf and ldf in other drive also...Alll ur mdf and ldf files are safe even...

The best third party tools is DBARTISIAN.It will definitely help u in all aspects .

Restore Last Full Backup with no recovery

then restore last differential backup with norecovery

finally restore log backup with recovery

There is an option 'NEW QUERY' option in management studio ..use that

check this http://www.exforsys.com/tutorials/sql-server-2005/sql-server-2005-architecture-overview.html