Can be done using SELECT INTO

Example:

use pubs

go

select * into dbo.Trial from master.dbo.Trial

Copy the .LDF file also.

.MDF file is data file. LDF file is Log file.

GilaMonster (7/8/2008)

It is not normal to have 10 deadlocks a day...

Run DBCC UPDATEUSAGE.

BOL has following remarks:

In earlier versions of SQL Server, the values for the per-table and per-index row count and page counts can become incorrect. Under certain circumstances,...

How about

1. Using third party backup tool which creates compressed backup file.

2. Writing a stored procedure to take backup which will retry if the backup fails.

Yes.

Example:

create procedure spEmployeeUpdate

(

@EmpId integer,

@Name char(75),

@Salary decimal(8, 2)

)

as

update employee set [name] = @Name, Salary = @Salary where empid = @EmpId

Do you go to different clients site to fix when they have issues?

Or do you...

Thanks Terry for the link.

Thanks Mani Singh.

I restarted the SQL Server service. But it didn't get restarted. Status was "Stopping".

Non-administrator users were not able to login.

So, I rebooted the server.

Suresh

Thanks Terry,

Do you have the link?

Suresh

1. A simple example for BACKUP LOG command:

BACKUP LOG DatabaseName

TO DISK = 'BackupFileName.TRN'

2. Use Maintenance Plan schedule the job.

3. Third party tools are available which create compressed backup file.

4. Crosscheck...

Thanks to all those who replied.

Thanks to Mani Singh for the link.

Suresh

>>I get this exact message whether or not the job succeeds or fails.

I think, you have selected "When the job COMPLETES".

Change it to "When the job FAILS"

It is integer operations issue. Write as follows

(MostLikelyCost / 100.0) * MinimumPercentage

>> i am accessing through my .NET Application, that time its giving error like that, but if i am Executing any query from my Managememnt Studio then its working...