Viewing 15 posts - 2,416 through 2,430 (of 9,253 total)
what exactly did you do to fix your master db corruption?
February 5, 2015 at 9:08 am
gwellbrock (2/5/2015)
February 5, 2015 at 8:37 am
gwellbrock (2/4/2015)
The database takes 4 hours to backup after tuning extensively(I hate TDE!!)
Yep, unfortunately TDE negates backup compression 😉
gwellbrock (2/4/2015)
February 5, 2015 at 3:45 am
Adam Bean (2/4/2015)
Hey all,Experimenting in a local lab with an always on setup and have some questions. The setup is pretty easy. 3 node cluster with a file share witness.
If...
February 5, 2015 at 3:11 am
a page has 8096 bytes of usable space
you have an overhead if fully populated of around 98 bytes per row.
It's not exact as each row may not be fully populated
February 4, 2015 at 9:56 am
Jampandu (2/4/2015)
I have a table like below,
CREATE TABLE Student
(
Id BIGINT not null
,Name NCHAR(20) not Null
,Branch NVARCHAR (64) null
)
The table contains : 100000 rows .
Can you please...
February 4, 2015 at 9:17 am
Hadrian (2/4/2015)
Thanks Perry,Is just for test(managers asked to try this operation) .Please could you me an argument why?
It is not supported by Microsoft. The master database is unique...
February 4, 2015 at 9:00 am
what are the connections doing?
February 4, 2015 at 6:20 am
do not restore the master database from one instance to another, you have been warned!!!!
February 4, 2015 at 6:18 am
Hadrian (2/3/2015)
TDE could not be turn off.
Did you receive any error message??
February 3, 2015 at 4:27 pm
Let's start with the following
How many databases in the group?
How many secondarys, are they readable?
Are they synchronous or asynchronous mode?
Whart sql server version is in use on the replicas?
February 3, 2015 at 4:22 pm
Yes it possible. The link I provided and other articles linked within it detail this
February 3, 2015 at 4:11 pm
Joy Smith San (2/3/2015)
If I add an NDF file on this second drive, will SQL server start writing into this new NDF *** soon its added ?
Are you creating the...
February 3, 2015 at 9:46 am
it seems clear that you do not understand the situation you are dealing with, I would highly recommend you seek help before you render the database inaccessible, you likely won't...
February 3, 2015 at 9:32 am
Ste_P (2/2/2015)
Which forum would you have expected this post to go in? :ermm:
Ste_P (1/20/2015)
February 3, 2015 at 9:30 am
Viewing 15 posts - 2,416 through 2,430 (of 9,253 total)