Viewing 15 posts - 3,001 through 3,015 (of 4,745 total)
just noticed you have enterprise edition. You can use asynchronous mirroring with that. Unless you need automatic failover you should consider changing to asynchronous mode (high performance or safety off).
January 29, 2010 at 1:01 pm
its not a problem, its by design.
with synchronous mirroring the transaction has to be committed on the partner before it can be committed on the primary. so whilst the partner...
January 29, 2010 at 12:59 pm
can I suggest that once you get you master database back you copy the system database files off to another location. then if you are in this situation again you...
January 29, 2010 at 12:51 pm
I'd certainly want to test it first in a sandpit environment.
Only sensible to have scripted out objects as a fall back position, and backup the x64 system dbs first. I...
January 29, 2010 at 10:07 am
don't know about heavy hitter, does the occasional home run count? 🙂
This blog would suggest you can restore X86 system dbs to 64bit
http://blogs.technet.com/keithward/archive/2009/10/15/upgrading-sql-server-from-32bit-to-64bit.aspx%5B/url%5D
there seems to be a possible msdb bug,...
January 29, 2010 at 9:12 am
luckysql.kinda (1/28/2010)
But one question... What about HIGH SAFETY (WITHOUT WITNESS). This is also sync. So according to me we can use ALTER DATABASE SET PARTNER FAILOVER. M I Correct?
-Lucky
you are...
January 28, 2010 at 8:02 am
if the disk is raided create a new file, it will fill, you will still see a performance benefit.
If you can have the file on a different drive will see...
January 28, 2010 at 6:45 am
SQL fills files on a proportional fill basis. i.e it tries to keep all files in a filegroup equally full, which means it would tend to write more to a...
January 28, 2010 at 6:31 am
either use 'allow data loss' or if that is not acceptable switch to high safety mode, allow it to synchronise and then do alter database set partner failover
January 28, 2010 at 6:14 am
If you want to define which object goes to which file, specifying new filegroups is the only way.
If files are all part of the same filegroup SQL will just spread...
January 28, 2010 at 6:10 am
If you start logshipping the log backups done as part of that process should be the only log backups you do.
If you have other log backups not done by the...
January 27, 2010 at 3:21 pm
what about asynchronous mirroring? Perhaps they should improve their network.
I would never use replication for DR, thats not really what it is intended for.
which leaves log shipping or replication at...
January 27, 2010 at 6:40 am
crossmj (1/26/2010)
If I removed the new sql services account from the Builtin Admins group, would that compromise the account's credibility with Sql Server?
No. You should find the account is...
January 27, 2010 at 3:07 am
builtin\administrators is more rights than it strictly needs.
did you use SQL configuration manager to assign the new user as the service account? That would automatically assign it all rights it...
January 26, 2010 at 12:12 pm
I agree too.
What are the 'current circumstances'?
January 26, 2010 at 7:51 am
Viewing 15 posts - 3,001 through 3,015 (of 4,745 total)