Hi,

Iam increasing the data file size manually as below.

Enterprise manager->database->properties->datafiles and increasing the size in space allocated(MB) coulmn.

plz tell me, the way Iam doing is right?

Hi Cain,

I think we can do the side-by-side upgrade from sql server 2000 32 bit on windows 2003 32bit to Sql server 2005 64 bit on windows 2003 64 bit...

can I have a sample script to generate a trigger when a dead lock is occured?

Yes, its worked after removing the no_truncate option.

But One thing still confusing me..In BOL, they mentioned tail backup is introduced in SQL Server 2005. But it also working in sql...

Thank you

Iam trying to take the tail backup as you suggested, But Iam getting the following error?

backup log ABC

to disk='d:\abc.trn'

with no_truncate,norecovery

Server: Msg 3031, Level 16, State 1, Line 1

Option 'no_truncate'...

thank you

thanks David,

Its working now. I have to bring the secondary database up, right now it is in restoring mode,every 15 min the log backups are restoring.

If 4:00pm lobg backup is...

Thanks Gail,

I have tried with tail backup in sql server 2000 and Iam able get point in time recovery. But one change I observed,between 2000 and 2005 is, In 2000...

Thanks Mohan...

I think we can not configure one reporting server(4th) for 2 different production servers...because once you configured in sharepoint mode by using report server configuration manager, how can we configure...

anybody has generated n tested the possible restore scenarios? Iam also looking for this information.

thx much

Thanks Jonathan,

I would like to use vb script to delete old backup files. Could plz give me some sample vb script that can delete old backups and how can I...

Thank you very much...

The 1st instance will take the defaul port 1433. So when we install 2nd,3rd do we need to give the port number after the installation of each...

Thanks Jeffrey,

I thoroughly checked, There is no space after the cfg in Spprod_Cfg. It might be other issue,could you plz advice me

Thank You,

I would like to know in which scenaro the both options will be greyed out?

1.Install the default configuration

2.Install but do not configure the server

As I know that if database...