Viewing 15 posts - 7,231 through 7,245 (of 9,244 total)
jpSQLDude (3/15/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2011 at 4:31 pm
Alexander G. (3/14/2011)
Are you sure? I have 2 VMs (each 8 GB RAM) running on one physical machine, but each VM has just one db instance.
how much memory does the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2011 at 4:14 pm
suri.yalamanchili (3/15/2011)
I followed the exact same steps as in your document and I am getting the following error where I install FreeNAS .When I ping Host from the VM....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2011 at 4:04 pm
TST1 (3/15/2011)
Thanks for the info, Henrico do you have any articles of how I could implement the physical/vm side? I know I will need to present the VM as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2011 at 4:01 pm
Sql Smith (3/13/2011)
Old Hand is correct. This is a native SQL backup.
Ok can see that now. Is there any particular reason why you included NOUNLOAD, you're not restoring from...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 14, 2011 at 12:13 am
DTC or quorum 512MB, or 1GB max. Requires no more than this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2011 at 9:03 am
So this is a backup that was taken with Redgate SQLBackup is that correct?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2011 at 1:22 am
Sql Smith (3/11/2011)
The restore gets to 100%, but never actually finishes. I've used RESTORE VERIFYONLY to check the backup. It reports "The backup set on file 1 is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 12, 2011 at 12:50 pm
my guess is the passive node was actually the active node. If the service didnt restart you need to find out why the group did not failover correctly
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 12, 2011 at 12:39 pm
JKG (3/8/2011)
I found this really helpful: http://www.mssqltips.com/tip.asp?tip=1687
That guide's good, but mine's better 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 9, 2011 at 12:40 am
rjohal-500813 (3/8/2011)
Perry Whittle (3/6/2011)
yes it is. message me an email address and i'll send you my guide
Any chance of turning this into a SSC article? I'm sure there are plenty...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2011 at 9:36 am
suri.yalamanchili (3/7/2011)
My email address is suri.yalamanchili@gmail.com. I appreciate your help in providing the guide.Thanks,
Suri
Mahommed can you supply more info on the set up you were using?
What hypervisor software were...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2011 at 8:46 am
no need for xp_cmdshell or any other nasties. Create a sql server job step as activex script and set to VBS. The code i use is as follows
Option Explicit
'Delete all...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2011 at 1:10 pm
totally possible, ensure the new server is the same build\version
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2011 at 1:04 pm
SqlRandall (3/3/2011)
I've granted ALTER TRACE to the account, per BOL for that function, but to no avail. Any ideas?Thanks in Advance,
my guess is the domain account doesnt have permissions...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2011 at 12:59 pm
Viewing 15 posts - 7,231 through 7,245 (of 9,244 total)