Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.1

(Build 2600:...

Both the servers are SQL Server 2005 32bit with SP2.

You mean to say I can remove ";-T1400" from startup parameters.?

I donno why, I was getting error when I was configuring...

No, both are different servers and NOT same.

I was having the following

-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;

-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;

-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf

Anyways now I uninstalled and reinstalled...

Thank you somuch.

I do take backup of LOG every 4 hours in my production server.

Was just cleaing my doubts.I will do some testing on my home PC and will see...

....Also make sure that SQL Server service is started..

mmm...Typing mistake can't happen. I had copied and pasted.

Hi,

Thanks for your quick reply.

I added those parameters back. But still it's nto working.

What should I do now..?

By the way, it's SQL Server 2005 Standared edition

with SP2 installed. Why...

Adi Cohn (5/25/2009)

---

The size of the transaction log is affected by the number of transactions and also by the size of the transactions.Also you should remember that maintenance jobs such...

Allocate the rights to "ROLE", not user.

Can you explain in detail pls..

What's there in the script..?

Is it updating any table which has got triggers..?

You said it's executing properly when u restart the PC...What have you done...

50 instances on a stand-alone server for all SQL Server editions except for Workgroup. Workgroup supports a maximum of 16 instances per computer.

Plese see the beloq link

http://msdn.microsoft.com/en-us/library/ms143432.aspx

Thank you all...Thank you so much.

Thank you somuch.

Please don't cross post.

Direct replies to: http://www.sqlservercentral.com/Forums/Topic713653-357-1.aspx