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...
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...
January 21, 2011 at 3:22 pm
CirquedeSQLeil (1/20/2011)
Thanks for the article Perry.
Thank you Jason
January 21, 2011 at 2:43 am
Chris Mathews (1/20/2011)
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.
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...
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...
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...
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...
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...
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...
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...
January 19, 2011 at 12:44 pm
alen teplitsky (1/19/2011)
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...
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...
January 19, 2011 at 10:56 am
Viewing 15 posts - 7,306 through 7,320 (of 9,244 total)