Viewing 15 posts - 9,046 through 9,060 (of 9,244 total)
SQLCMD is the preferred command line connector for SQL2005
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 5, 2008 at 4:06 pm
SQL server has a set of services that install to the host machine as well as specific program files, etc, so a virtual cd drive will not help i'm afraid
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 5, 2008 at 4:04 pm
i would go the SQL2005 route first, by that time SQL2008 will be stable and become a viable upgrade platform
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 5, 2008 at 3:56 pm
Michael Valentine Jones (8/5/2008)
400 TB would make it one of the world’s largest databases...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 5, 2008 at 3:44 pm
Lee Hart (8/5/2008)
forgetting for a moment that SQL server Enterprise edition uses more than the standard install...
both SQL 2005 Std and Ent address RAM up to the OS limit.
Lee Hart...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 5, 2008 at 3:21 pm
just ensure that MSSQLSYTEMRESOURCE and DIST are in the same location as your MASTER database and all should be well
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 5, 2008 at 9:17 am
begs the question,
if you're implementing log shipping, why are you truncating the log?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 3, 2008 at 11:51 am
sounds like these guys had the problem as you, give it a shot
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=2968469&SiteID=1
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 3, 2008 at 3:16 am
i was involved in an upgrade from a sql2000 instnce to a sql2005 instance early last year. The point raised was how do we get the databases onto the new...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 3, 2008 at 3:02 am
as stated in your case no.
if you were SAN based for instance for your VM storage then you could use different LUNs.
With regards to licensing if you licence your host...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2008 at 12:57 pm
are you experiencing page splits on your server?
SQL server default is 0 which means the same as 100% (you can alos specify when rebuilding an index which overrides the default),...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2008 at 12:45 pm
you wouldbe best to set the default paths after installation.Its a lot easier or use custom scripts to set the paths
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2008 at 9:27 am
New_to_being_DBA (7/31/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2008 at 3:21 am
what are you expecting to see?
what is the reason for executing dbcc opentran?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 2, 2008 at 3:11 am
the 2 HBA's should be multi homed so that in the case of an HBA failure you dont lose any of your data drives.
In the options you are quoting loss...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 31, 2008 at 4:17 pm
Viewing 15 posts - 9,046 through 9,060 (of 9,244 total)