Viewing 15 posts - 4,171 through 4,185 (of 9,241 total)
prettsons (3/26/2013)
Simple recovery model allows restore database only up to the last full backup
Up to the last differential backup actually, as long as you're taking diff backups of course 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2013 at 10:06 am
TheSQLGuru (4/18/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2013 at 8:45 am
The whole point of AlwaysOn is that you don't have shared storage. There's nothing to say that the disks cant be SAN based but they're not shared across the windows...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2013 at 6:56 am
gamit124 (3/28/2013)
hiwhen i am taking full backup and i am restoring full back up
i am getting error like "the database is not accessible"
please help me
regards,
gamit
Are you getting this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2013 at 12:15 am
Markus (4/17/2013)
Throwing hardware at an issue sometimes is just not the answer.
It's something you see time and time again and you're right it's a futile\costly exercise.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2013 at 11:19 am
dan-572483 (4/17/2013)
Does pausing the passive node you're installing on have the same effect and is an equally valid action?
This was only really necessary under Windows 2003 clusters. Windows\sql 2008 have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2013 at 7:47 am
the reason for removing the passive node as a possible owner on the networkname resource is to avoid the situation where you're patching the passive node and half way through...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2013 at 7:12 am
has the user been added as an explicit server login on the sql server.
What are the resultsd of the following query
select name, SID
from sys.server_principals
where type = 'U'
and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2013 at 7:08 am
uninstall the cu and reboot then try re applying
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2013 at 7:03 am
In that case you use CREATE INDEX specifying the new file group with the DROP_EXISTING = ON clause
See here for more detail
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2013 at 12:16 am
No problem, don't forget to check the pre reqs and restrictions carefully, it can save you a whole lot of time later on.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2013 at 12:13 am
Google??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2013 at 10:44 pm
Does the PK have a clustered index upon it at present?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2013 at 10:14 am
yes but i'm assuming you'll have other databases that are not part of the AO group or even other instances that may use DTC, if you don't then don't worry....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2013 at 5:35 am
SQLSACT (4/16/2013)
Because Node1 has SQL installed as nonclustered, is it safe to say that it's not absolutely necessay to share DTC across all 3 nodes.
yes you could argue that....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2013 at 4:59 am
Viewing 15 posts - 4,171 through 4,185 (of 9,241 total)