sarvesh singh (6/19/2009)

---

Guys,

I didn't explain it right in my previous post. My bad.

the problem was resolved by restarting the sql server.

We've run dbcc checkdb with estimateonly on the client...

tosscrosby (6/19/2009)

---

george sibbald (6/18/2009)

---

sarvesh singh (6/18/2009)

---

Thank you all again for ur responses;

Managed to get a planned downtime to restart the sql server.

Also i added the estimate only clause...

To enable

exec sp_addextendedproc 'xp_cmdshell', 'xplog70.dll'

To disable

exec sp_dropextendedproc 'xp_cmdshell'

It should be disabled. people will often...

sarvesh singh (6/18/2009)

---

Thank you all again for ur responses;

Managed to get a planned downtime to restart the sql server.

Also i added the estimate only clause to CheckDB on...

because checkdb uses tempdb heavily. I am not sure of details but I would hazard a guess this is to help maintain concurrency whilst checkdb runs. That is why I...

To solve this situation in the past where the file is definitely there but you get error 2 (file not found) I have had to physically delete the file from...

To solve this situation in the past where the file is definitely there but you get error 2 (file not found) I have had to physically delete the file from...

ggrimberg (6/16/2009)

---

We setup 3 servers for sql 2005 database backup, primary server, backup server and witness server. We do full backup every night, after a short time we noticed that...

continue to monitor the sizes of the files, just because they have grown to their present size does not mean they will continue to grow.

for checkdb run it with the...

Mani Singh (6/16/2009)

---

As previously said, if you system is a highly transactional system, shrinking it will have no affect on filesize and in return might have significant performance impact as...

potential performance impact, but it won't break them.

If you have to shrink tempdb try to do it when system is quite and don't shrink it right down to 8mb again,...

ok, immediately after this post I am going to unsubscribe because no way am I going to get sucked into 'the thread'. 🙂

Despite that I think it very important that...

tempdb files can be shrunk with dbcc shrinkfile like any other. However this will have an impact on performance of the instance and should not be done unless you have...

there is nothing about adding a filegroup that should make logshipping fail. Ians suggestion sounds like a good one.

what does table msdb..log_shipping_monitor_error_detail say?

Possibly your tran log was truncated or...

There is nothing about adding a filegroup that should make log shipping fail. Ians suggestion sounds like a good one.

what does table msdb..log_shipping_monitor_error_detail say? Perhaps the log was truncated or...