guptaajay1985 (6/30/2009)

---

I have successfully implemented Transactional replication yet only tables which has primary key has populated on subscriber and the data is also not replicating on subscriber. I have used...

Can you clarify more on your requirement pls? Do you want to take backup of...

Thanks Gail for the reply.

Will try out your suggestions tommorrow at office and post the results.

Also, will try out DBCC PAGE as mentioned in Paul's blog to see if there...

Thanks for the reply Abhay.

Rebuilding the index stopped with the following error.

====================

Server: Msg 823, Level 24, State 2, Line 1

I/O error (torn page) detected during read at offset 0x0000004f066000 in...

On Checking system event viewer, i found that there was a disk related error on 20th May.

Error1 - The driver detected a controller error on \Device\Harddisk0.

Error2 - The device, \Device\Scsi\vmscsi1,...

Thanks Gail for writing such a great article series, undoubtedly the best on the subject one could ever find anywhere:-).

paksyeet (6/24/2009)

---

actually its a new server that was turn over to me.. which has NO(you've read it right) backup at all..

and looking forward, i'm planning to chunk that one .mdf...

The foremost thing to lookout for is having indexes on the...

You may want to go through this blog for details on memory management by Sql Server.

http://blogs.msdn.com/slavao/archive/category/9005.aspx

Also you can try to increase the login timeout.

sp_configure 'remote login timeout', 60

go

reconfigure with override

go

This will set the login timeout value to 60 seconds

naimshad (6/27/2009)

---

Following error occured on ML 350 server.

-214721781 [Microsoft][ODBC SQL Server Driver]Timeout expired

My database size in 30 GB.

I have checked everything and all the settings are ok.

DBCC check db

dbcc updatestats

query...

It...

why do u need to restore msdb? is it corrupted?

This link may help u a bit.

http://technet.microsoft.com/en-us/library/ms190749(SQL.90).aspx

rambilla4 (6/26/2009)

---

Hi,

We have sql server 2000 databases and have full backups. Unfortunately some updates on the databases went wrong and we need to restore all the databases to last night...

parthi (6/26/2009)

---

Thanks Williams

How to check the service account running SQL Server and SQL Server Agent has access to the shared...