Viewing 11 posts - 91 through 101 (of 101 total)
ESAT ERKEC (11/10/2012)
Why you don t use database mirroring
In database mirroring, if the primary database is corrupted for any reason other than hardware failure, then the mirror database will be...
November 10, 2012 at 4:45 am
GilaMonster (11/10/2012)
The first one won't work on SQL 2008, the second one will. Otherwise they're the same, both bad forms of log mismanagement.Please read through this: http://www.sqlservercentral.com/articles/Administration/64582/
Would you please tell...
November 10, 2012 at 4:09 am
Thank you, SSC Veteran for your co-operation.
November 8, 2012 at 4:05 am
Hi thats just a informational message ..
I think link below will help you more
I have gone through the above link. But I am using SQL Server 2008 R2. Will...
November 8, 2012 at 1:57 am
sanket kokane (11/7/2012)
please check if there any db_owner for your database used in replication.if there is no change it to SA or any other active login
use Yourdatabase
go
sp_changedbowner 'sa'
pls can u...
November 8, 2012 at 12:19 am
GilaMonster (11/5/2012)
shohelr2003 (11/5/2012)
Actually I need to shrink my log file. As my database increases regularly, it slows down my application system.
A large transaction log will not cause performance problems. Free...
November 6, 2012 at 12:05 am
Thank you for your kind help.
Actually I need to shrink my log file. As my database increases regularly, it slows down my application system.
Pls suggest me.
November 5, 2012 at 9:07 pm
please suggest me, what can I do. Which approach should I practice?
November 5, 2012 at 5:04 am
Yes, I am asking how to restore database automatically.
1. Actually I am taking backup of database using Database Maintenance Plans in a remote pc's disk.
2. The backup schedule runs two...
October 2, 2012 at 11:54 pm
Thank you for your reply. I got the point. That's the reason.
September 29, 2012 at 12:32 am
Viewing 11 posts - 91 through 101 (of 101 total)