Viewing 15 posts - 5,026 through 5,040 (of 9,253 total)
Rob-350472 (9/13/2012)
perhaps I should think of going:shrink --> backup routine --> move...
no, use the method i showed you. backup and restore is a complete waste of time.
I use this method...
September 13, 2012 at 9:16 am
Rob-350472 (9/13/2012)
Copy files in explorer from source to destination
right click --> 'bring online' (at a...
September 13, 2012 at 9:14 am
take a differential backup on the primary and restore it to the secondary to restart LS
September 13, 2012 at 8:44 am
Rob-350472 (9/13/2012)
Need to wait till I can actually close Management Studio in the first place (and SQLserver process) to move the files first of all though!Thanks 🙂
No, you don't 😉
Issue...
September 13, 2012 at 8:41 am
Rob-350472 (9/13/2012)
Besides a copy/paste of the files from location A to...
September 13, 2012 at 6:34 am
Kwisatz78 (9/13/2012)
September 13, 2012 at 6:20 am
Perry Whittle (9/13/2012)
and certainly shouldn't be used for a geo spacial cluster configuration.
😉
September 13, 2012 at 4:06 am
Kwisatz78 (9/13/2012)
The primary node contains both the data and quorum disks
So you're using Node and disk majority quorum type?
Kwisatz78 (9/13/2012)
September 13, 2012 at 3:58 am
Kwisatz78 (9/13/2012)
Sorry I am not sure I followed what you have said. If I remove voting from one of the nodes is this not the same as removing...
September 13, 2012 at 3:40 am
Sqlism (9/12/2012)
Hope this link helps youhttp://sqlism.blogspot.com/2012/08/finding-port-number-for-particular-sql.html
Finding the Port Number for a particular SQL Server Instance
DECLARE @tcp_port nvarchar(5)
EXEC xp_regread
@rootkey = ‘HKEY_LOCAL_MACHINE’,
@key = ‘SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER\SUPERSOCKETNETLIB\TCP’,
@value_name = ‘TcpPort’,
@value = @tcp_port OUTPUT
select @tcp_port
This is...
September 13, 2012 at 2:55 am
Kwisatz78 (9/13/2012)
We currently have a geo cluster which spans 2 datacentres which are close together. Not having a 3rd location and as we are wanting to use availability...
September 13, 2012 at 2:38 am
SQLSACT (9/13/2012)
What I'm struggling to grasp is why does SQL Server still worry with the Index if all the pages that it needs is already in memory.Thanks
The index key...
September 13, 2012 at 2:07 am
Nater (9/12/2012)
2 drives in RAID1 for backups
2 drives in RAID1 for logs
4...
September 12, 2012 at 11:21 pm
wannabe dba (9/12/2012)
I have a sql 2008 r2 enterprise box which is running on windows 2008 R2 enterprise and the business wants to separate some of the databases from...
September 12, 2012 at 2:43 pm
Nater (9/12/2012)
Thank you so much for your response!!! Thank you so much for mentioning backups . . . cant believe i forgot to mention that. We will definitely...
September 12, 2012 at 12:55 pm
Viewing 15 posts - 5,026 through 5,040 (of 9,253 total)