Perry Whittle

Forum Replies Created

Viewing 15 posts - 6,076 through 6,090 (of 9,253 total)

RE: SQL server 2008 R2 log shipping wizard not showing backup compression option

What version is the secondary?

January 13, 2012 at 1:07 am

#1433047
RE: Existing standalone SQL 2008 R2 server to failover cluster question...

garthwaimr27 (1/12/2012)
I was hoping you wouldn't say that : ).
What's the purpose of reinstalling the OS on the old node? Could I just reinstall SQL?
Reinstall to get a clean...

January 13, 2012 at 1:04 am

#1433045
RE: Existing standalone SQL 2008 R2 server to failover cluster question...

garthwaimr27 (1/12/2012)
1. Just run the cluster setup on the existing server? Can I keep my existing server\instance name if I do this?
No, it doesn't work like that.
garthwaimr27...

January 12, 2012 at 2:17 pm

#1432889
RE: Security error when adding a second node

Least you got it sorted. Time to give the AD admins a grilling.

January 12, 2012 at 1:12 pm

#1432854
RE: SQL server 2008 R2 log shipping wizard not showing backup compression option

ss-457805 (8/13/2010)
log ship wizard in 2K8R2 Std not showing compression option,but compression column is present in log_shipping_primary_databases. The option should still show in the wizard rite? Am i missing something?
Did...

January 12, 2012 at 7:45 am

#1432520
RE: .ldf deleted and now cant attach database

GilaMonster (1/11/2012)
Perry Whittle (1/11/2012)
To re attach a database with a missing log file just use either
sp_attach_single_file_db
CREATE DATABASE .... FOR ATTACH_REBUILD_LOG
Which only works if the database was shut down cleanly...

January 12, 2012 at 5:54 am

#1432390
RE: ShrinkDatabase doesn't shrink the data file

MarkThornton (1/12/2012)
We do have regular index maintenance - a weekly scheduled job, each sunday.
My current theory is that this isn't working, due to the presence of an ntext field in...

January 12, 2012 at 4:28 am

#1432359
RE: SQL 2008 R2 Report services won't start

s_osborne2 (1/12/2012)
I let the installer configure with the defaults. Maybe that was my error! 😉
Hope to be able to give this another go at some point later today.
I always prefer...

January 12, 2012 at 4:04 am

#1432344
RE: How to create database from .mdf file only

Chris Shaw (1/11/2012)
I don't think you can rebuild the log when using the UI, however this is off the top of my head, and well age is not doing...

January 12, 2012 at 1:18 am

#1432281
RE: RAID recomendations

@SQLRNNR exactly, although if you were to lose half the drives performance would suck in a big way. Your data is still intact though.
@steve-2 Jones that is, unfortunately...

January 12, 2012 at 12:16 am

#1432269
RE: RAID recomendations

The big advantage of Raid 10 is you can lose up to half the disks as long as no mirrored pair fail and the array will still operate, albeit with...

January 11, 2012 at 5:10 pm

#1432221
RE: clone SQL server?

clare.xia (1/11/2012)
My company is going to create a new test environment, which will clone from servers in Production.
The server team plan to copy only the drive that has SQL installation...

January 11, 2012 at 4:58 pm

#1432217
RE: RAID recomendations

Kenneth.Fisher (1/11/2012)
I appreciate ya'lls help with this. RAID has always been a difficult subject for me but I think I'm finally getting it down.
Just as an aside, we have...

January 11, 2012 at 4:55 pm

#1432215
RE: SQL 2008 R2 Report services won't start

How did you install the instance, did you select configure later or to let installer configure

January 11, 2012 at 1:28 pm

#1432092
RE: DB MIRROR Error

Dhirju (1/11/2012)
tomorrow i'll do it and get back to u for the same.
Ensure all nodes are well connected and confirm.

January 11, 2012 at 1:22 pm

#1432087

Viewing 15 posts - 6,076 through 6,090 (of 9,253 total)