Viewing 15 posts - 7,306 through 7,320 (of 9,244 total)
Alex
i tested this on my mirror setup, adding the filegroup itself was fine. After adding the filegroup FG1, I failed over the principal (the mirror is now principal) and when...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2011 at 1:38 pm
adrian.saunders (1/21/2011)
Established Cluster
OS windows 2003 64 bit sp2
Node 1 installed with sql 2000 32bit enter sp4, sql2005 64 bit ent sp3
Node...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2011 at 3:22 pm
CirquedeSQLeil (1/20/2011)
Thanks for the article Perry.
Thank you Jason
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2011 at 2:43 am
Chris Mathews (1/20/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2011 at 2:42 am
Once you have the backup file you want to restore perform a filelistonly restore to get the filenames and logical names. Use these to restore the database.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2011 at 3:04 pm
my guess is your trace create script looks like this
sp_trace_create @TraceID output, 0, N'InsertFileNameHere', @maxfilesize, NULL
It hits the max file size but does not rollover, it should look like this
sp_trace_create...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2011 at 4:52 am
you could mirror your server builds so disk allocations are always the same, this is the practice most would follow across a SQL Server farm. Other than that, use an...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2011 at 4:43 am
techzone12 (1/19/2011)
I noticed that there is a utility called "Windows Server Backup" that comes with the SQL server OS.
The Windows server backup product built in to Windows 2008 is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2011 at 4:40 am
You should be able to add files to a mirror session, there are some warnings though
From SQL Server BOL
Adding a file during a mirroring session without impacting...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2011 at 4:30 am
TurnerC (1/19/2011)
Can I receive a copy of the VMWare Server\SQL Server 2008 install.
Currently our site has a clustered 2008 R2 sql server instal built by a third party vendor...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2011 at 4:04 am
GRE (Gethyn Ellis) (1/19/2011)
PerryDoes your tutorial cover setting up the cluster on VMware workstation 6.5? if it does please can I take a peek please.
Thanks
Gethyn
Hi Gethyn
yes Workstation will be fine...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2011 at 3:59 am
alen teplitsky (1/19/2011)
i believe it's because you had to add it as a dependency to the SQL service.
yes, i'm with you now that's quite correct you add the disk as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2011 at 12:44 pm
alen teplitsky (1/19/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2011 at 11:33 am
alen teplitsky (1/19/2011)
another plus is that windows clusters are a pain in the *** and changing minor things like IP's can break them.
changing the IP for what a clustered resource...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2011 at 10:58 am
george sibbald (1/19/2011)
maybe it is taken as read but it should be mentioned another drive would be needed to install SQL application files to (i.e. the instance root directory) and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2011 at 10:56 am
Viewing 15 posts - 7,306 through 7,320 (of 9,244 total)