Viewing 15 posts - 4,561 through 4,575 (of 9,241 total)
DKlein (11/26/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 12:34 pm
To ensure in the future that the option persists you could use policy management to create a new policy enforcing the snapshot isolation state. You'll need to select the Database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 12:22 pm
SQL_ME_RICH (11/26/2012)
This is what happens when I respond to posts before coffee - thanks for that Gail!:crazy:
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 11:44 am
Spooky huh!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 8:15 am
sanath.kumar.kura (11/26/2012)
If i changed the frequency it would solve the issue.
Not on its own but it's a start!
The links posted will guide you further
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 7:48 am
shohelr2003 (11/26/2012)
actually witness server is an optional requirement in mirroring. If you choose "High Safety With Automatic Failover" option, then you need a witness server.
It's an option for Syncrhonous mirroring,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 7:45 am
as a side note, have you changed any CPU settings in the BIOS, the reason i ask is because the stack dump occurs right after CPU detection
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 7:20 am
The database master key is itself a symmetric key. Assymetric keys provide increased security, the symmetric key is purely used to protect the main (or Assymetric key) while it is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 6:45 am
you can also use xp_regread to query the apprpriate registry values for your SQL server instance.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 5:57 am
shohelr2003 (11/26/2012)
Thank You, Perry Whittle. But what does "database will be totally out of sequence" mean?
The LSNs and hence restore points will be completely different between databases, it would make...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 5:55 am
mahesh.dasoni (11/24/2012)
Now when it been moved to another domain we are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 5:52 am
SQL_ME_RICH (11/21/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 5:13 am
sanath.kumar.kura (11/26/2012)
The log file is grown to five times the database size.
Transaction Log file size 3.1GB
Database file size is 700 MB
Recovery Model : Full
backup strategy : Daily full database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 4:37 am
shohelr2003 (11/23/2012)
Now for some reason I wanna restore database to my principal from another databse.Will it cause any inconsistency in mirror databse?
Yes, of course the databases will be totally...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2012 at 1:27 am
Follow my guide at these links
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2012 at 4:56 am
Viewing 15 posts - 4,561 through 4,575 (of 9,241 total)