i face similar issues...

Barry suggested me some alternative to check for proper settings.... i'm yet to do that...:doze:

May be u can test it too...

http://www.sqlservercentral.com/Forums/Topic722842-146-1.aspx

Thanks Eswin,

I enabled service broker...

from BOL :

GO

USE master;

CREATE ENDPOINT BrokerEndpoint

STATE = STARTED

AS TCP ( LISTENER_PORT = 4037 )

FOR...

Aatish,

There are plenty of articles on this site which explain clearly on managing transaction logs, you shud start wit Gail's article first, understand the pros n cons of doing what...

what are the sizes of mdf and ldf seperately?

Also, are you taking tran log backups?

Go through the forum posts and you'll get a fair idea.

just curious, are you tring to pursue a dba career?

julie.tilley (3/16/2009)

---

USE Ztest

GO

Select * from

HistCMSCallHist as hc Join oa.cmsCallHistory as ch

On ch.CallID = hc.CallID

Msg 208, Level 16, State 1, Line 1

Invalid object name 'HistCMSCallHist'.

Any help would be great I am...

kllrbeas (2/20/2009)

---

I am in my first sql class, I am trying to find out if sql server 2005 supports this syntax

Insert Into dbo.employees (ID, FirstName, LastName, Age)

Values('1018','Neeraj', 'Shivasam',18)

Values('1118','Neeraj', 'Huda',38)

Values('1028','Gaurav',...

snehal.gamaji.career (2/19/2009)

---

Hi,

i want to purge data from one of table.. i want to retain ony 1 year data .. i want to purge all data older than 1 year .I...

Richard M (2/19/2009)

---

um....

sp_dropserver will "remove a server from the list of known remote and linked servers on the local instance of SQL Server"..... so it will not affect at all...

keep recovery model of the database Simple. this will keep on removing inactive log entries at regular frequent intervals.

both are identical.

refer BOL.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/15f1a5bc-4c0c-4c48-848d-8ec03473e6c1.htm

you can also check if some bulk upload is happening.... if yes, you can switch the recovery to bulk-logged for the period of bulk upload to prevent the log file...

the last tran log file was restored without norecovery/standby clause.

You'll need to restore the latest full backup from your production( in norecovery/standby mode) and then apply succeeding tran log backups.

Looks...

Paula (2/16/2009)

---

Hi all,

I have ran the nested select below and it produces a list of 150 records. However when I then run the update it updates 5600 records. ...

there are lots of backup scripts on this site.

you can have two different jobs for backups. one for weekly backup(and delete them after a week using same job) and...