Viewing 15 posts - 7,951 through 7,965 (of 9,241 total)
you have the option to provision accounts during the install, why not use that?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 15, 2010 at 1:35 pm
use the following to ascertain backup sets that have been initaited against the database. Check the output to see if there are any unexpected\manual backups outside of the regime you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 14, 2010 at 3:40 pm
Edogg (5/14/2010)
Also AWE does not need to be enabled on 64 bit systems.
No, but lock pages in memory probably should be!
If you start seeing the following in the SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 14, 2010 at 3:31 pm
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!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 14, 2010 at 5:45 am
BharatBhushan (5/13/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 13, 2010 at 5:33 am
What version\service pack are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 13, 2010 at 1:30 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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 13, 2010 at 1:26 am
Grant Fritchey (5/12/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 13, 2010 at 1:15 am
Have any other hotfixes been applied at all?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 12, 2010 at 12:29 pm
Viewing 15 posts - 7,951 through 7,965 (of 9,241 total)