is there any Best practice from Microsoft recommending one of the 2 above options?

Hi,

changed the full backup schedule 1 hr later, then also Iam getting the same error while backup is running

Could you please give some idea on how to diagnose this

thanks

Thanks,

Iam taking the backups directly to the local drive in the server. Iam using the below procedure for backups.

USE [master]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE BackupDB

@DBName VARCHAR(100),

@BackupPath VARCHAR(2000),

@BackupType VARCHAR(4)...

Could you please explain how you gather the statistics, I mean Index fragmentation on a production sq server 2005 continuously checking for index fragmentation which will occurring because of...

Some clarification here,

If the second condition is not talking about the wild card mapping then Iam good to go. Please advice the second condition aslo talking about wild card mapping...

Thank you,

the other jobs in SQL Server agent are running fine with user abc\admin. Only this one job is failing, which has also the same user abc\admin.

SO where exactly I...

Could you please provide some info on this as Iam stuck here whether I can go head with the in-place upgrade or not?

how to resolve this issue?

thanks in advance

Mani

Cou you please advise me about this issue to resolve...

Thank you,

Could you please tell me where can I found(path location) this cluster.log file?

thanks

Server A is WINDOWS 2003 Standard edition with Servicepack2.

I followed the given link and Iam able to Migrate and upgrade to SSRS in Server B. But my question is

why in Server A (Production)has NO NT AUTHERUTY\NETWORK SERVICE and...

Could you please give me some idea in configuring Logshiiping for this scenario?

is this possible? or Do I need to choose any otherway? please advice me..

thank you

Hi,

Drives:

C->OS

D->datafiles

E->Secondary files

F->Log files

G->TempDB

Z->Backup

I attached the excel sheets with above mentioned perfmon...

Thank You..

What about the message The database 'Mydb' is marked RESTORING and is in a state that does not allow recovery to be run.

was this an issue or its...

hi,

When I restored the backups from sql 2000 in sql 2005, I did find the below messages in the error log.

What is the meaning of the quoted lines below.

2009-02-19...