Viewing 15 posts - 4,816 through 4,830 (of 9,241 total)
Don't they run a boot camp in Redmond?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2012 at 7:24 am
shiv-356842 (10/10/2012)
WE are adding new witness server sql server 2008 R2 SP1 Standard Edition.
Prinicipal & Mirror servers Sql server 2008 Standards Edition only. we are adding this witness...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2012 at 7:09 am
OK, so how often are the restores being applied by the restore job?
If they're restored hourly you could probably reduce the retention on the secondary, either that or get more...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2012 at 7:06 am
d.curtin (10/10/2012)
2008
Standard, Enterprise, Web, workgroup, Developer, Express.....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2012 at 4:55 am
Which version\edition of SQL Server are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2012 at 4:48 am
sql.com (10/10/2012)
@ Gail - I was waiting for a MCM 😉
Why??
i could be wrong but i'm sure I'm not. I wouldn't think that the MCM course will teach you hex,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2012 at 4:44 am
GilaMonster (10/10/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2012 at 4:40 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2012 at 1:28 am
pwillemsen (10/9/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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:...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2012 at 1:14 am
Viewing 15 posts - 4,816 through 4,830 (of 9,241 total)