Viewing 15 posts - 7,966 through 7,980 (of 9,253 total)
george sibbald (5/14/2010)
Mirroring would be too risky with the poor latency you are likely to have.
i couldnt agree more, that would be my concern!
May 14, 2010 at 5:45 am
BharatBhushan (5/13/2010)
May 13, 2010 at 3:57 pm
Rome1981 (5/13/2010)
Mirroring.
if you have unreliable band width then this is not the best solution
Is it that much of an issue if it takes an hour and a half. How much...
May 13, 2010 at 3:23 pm
something along the lines of the following should work
use yourdb
select t.name as TableName, c.name as ColumnName from sys.tables t
inner join sys.columns c on t.object_id = c.object_id
where c.name = 'Yourcolumnname'
May 13, 2010 at 5:33 am
If the SAN goes down chances are the whole business is down too, while it's a good scenario to plan for it's more realistic that a disk in your array...
May 13, 2010 at 1:26 am
Grant Fritchey (5/12/2010)
May 13, 2010 at 1:15 am
Have any other hotfixes been applied at all?
May 13, 2010 at 1:04 am
Sourav-657741 (5/12/2010)
Thank Perry Whittle. However, will the above sugestion work file for SQL Server 2000?
no, i would try posting in the sql server 2000 forum in the future 😉
May 12, 2010 at 2:15 pm
lcibert (5/12/2010)
And I cannot upgrade it because it's not supported by the application vendor for what I'm...
May 12, 2010 at 2:13 pm
Icibert
what version and SP of SQL Server 2005 are you using? (e.g. 9.00.1399, etc)
May 12, 2010 at 12:33 pm
Hi
For SQL Server 2005 move the master first using the following
Edit the SQL server service and change the paths for the MASTER data and log files to the new location....
May 12, 2010 at 12:29 pm
sqlquery-101401 (5/12/2010)
May 12, 2010 at 12:02 pm
your welcome
May 12, 2010 at 3:19 am
have you rebooted after installing the hotfix?
May 11, 2010 at 2:40 pm
Viewing 15 posts - 7,966 through 7,980 (of 9,253 total)