Viewing 15 posts - 4,816 through 4,830 (of 9,244 total)
have youi checked the event logs for details of any errors\warnings?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2012 at 2:12 am
ankur_libra (10/10/2012)
Restore job runs after every 15 minutes.
OK, so you probably don't need a 3 day retention period
ankur_libra (10/10/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2012 at 3:04 pm
GilaMonster (10/10/2012)
Nope. Not for almost 2 years now. That was the old form, 3 weeks training and exams in Redmond.
Ah right, gotcha.
But, back to my original quote, no study material...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 10, 2012 at 7:49 am
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
Viewing 15 posts - 4,816 through 4,830 (of 9,244 total)