Viewing 15 posts - 4,831 through 4,845 (of 9,253 total)
ananda.murugesan (10/10/2012)
can we configure database mirroring on different service account, will it be work without any issues?Thanks
ananda
You can, in fact each instance should use a separate user account.
Whether you...
October 10, 2012 at 4:06 am
Ajdba (10/9/2012)
Hello,While right clicking on replication in SSMS, "configure distribution" option is not showing up in SQL Server 2008 r2 version. Any suggestions?
Thanks
Aj
Have the replication components been installed?
Check this link...
October 10, 2012 at 2:31 am
Firstly, why would you want to deploy a mirror session acros instances with differing SP levels?
Books Online does state the they should be the same version, i've never tried to...
October 10, 2012 at 2:20 am
sqlfriends (10/9/2012)
Thanks,I got this:
nametypetype_descphysical_name
RenaissanceServer2DISKE:\MSSQL\DataRenaissanceServer.bak
RenaissanceServer_LOG2DISKE:\MSSQL\DataRenaissanceServer_log.bak
MASTER_MSDB2DISKE:\MSSQL\DataMASTER_MSDB.bak
I noticed the vendor didn't put the device to our backup drive which is G:\Backup,
How can I change the device to it?
Thanks,
Use sp_dropdevice to delete the...
October 10, 2012 at 1:37 am
Is this related by any chance?
If it is, keep all replies to the link provided, this will make it easier for you and me 😉
October 10, 2012 at 1:28 am
pwillemsen (10/9/2012)
October 10, 2012 at 1:17 am
ankur_libra (10/9/2012)
SQL Server 2008 Std Edn 64 bit on both servers
Database X State at Secondary Server (B): Restoring
Problem:...
October 10, 2012 at 1:16 am
You don't need any downtime for the full and log backup\restore from the principal to initialise the mirror.
Terence Keys (10/10/2012)
October 10, 2012 at 1:14 am
Thanks, if you found the article helpful please don't forget to rate it 😉
October 10, 2012 at 1:10 am
darrenstokes (10/9/2012)
With mirroring I wont have any outage when the above quite likely scenarios occur.
Depends on the mirroring mode you are using.
In any mode other than High Safety with auto...
October 9, 2012 at 7:29 am
Ratheesh.K.Nair (10/9/2012)
Hi Experts,I know we have to run a full backup if we change the recovery model from full--> simple-->full.
No, you can just run a differential to restart the...
October 9, 2012 at 5:42 am
to add to Gail, in fact in some cases if you have a large number of files per filegroup the file switching can be a performance issue. SQL Server attempts...
October 9, 2012 at 5:38 am
I have, in the past restored a master database to anohter instance as a user database, then detached it and renamed the disk files to their original names and then...
October 9, 2012 at 5:31 am
Network DTC access needs to be enabled, was it working\enabled before?
Without knowing a lot more about the system and access to the logs it's very difficult to say. MSDTC is...
October 9, 2012 at 5:10 am
darrenstokes (10/9/2012)
October 9, 2012 at 5:06 am
Viewing 15 posts - 4,831 through 4,845 (of 9,253 total)