Viewing 15 posts - 8,881 through 8,895 (of 9,244 total)
yes VS 2005 Ent was what i used for local VM's. As i said i wouldnt attempt to run a SQL VM in anger on these platforms due to the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2008 at 2:06 pm
bkDBA (9/23/2008)
Perry Whittle (9/23/2008)
bkDBA (9/23/2008)
Microsoft VM,
are you using the Windows 2008 hyper V or Virtual 2005 Enterprise?
I had a 2 node SQL cluster running on my machine sometime ago...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2008 at 1:56 pm
bkDBA (9/23/2008)
SQL Server on a VM can be VERY slow due to poor VM I/O performance. My VM I/O is about 8 times slower than my production hardware.
what virtualisation platform...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 23, 2008 at 12:36 pm
Use something along the following lines
RESTORE DATABASE MYNEWDBNAME FROM DISK = 'D:\PATHTOFILE\BACKUPFILE.BAK'
WITH MOVE 'MDF LOGICAL FILENAME' TO 'F:\NEWPATH\NEWFILENAME.MDF',
MOVE 'LDF LOGICAL FILENAME' TO 'E:\NEWPATH\NEWFILENAME.LDF',
RECOVERY
Replace shouldnt be needed as the new physical...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2008 at 11:01 am
when setting up log shipping it can have 1 of 2 states, WITH STANDBY or WITH NO_RECOVERY
STANDBY is the first. The database is in a read only state and clients...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2008 at 10:52 am
you would probably need the latest MDAC update for the SQL driver
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2008 at 10:49 am
you could also run a repair of the .NET framework via add\remove programs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2008 at 10:41 am
might i suggest if you have access to a virtualisation technology have a go at clustering on a couple of test servers before implementing. Virtual server Enterprise 2005 will happily...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2008 at 7:57 am
generally consult your application vendor!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2008 at 6:59 am
sandhyarao49 (9/16/2008)
Hi,I want to move the logins from one server to another server.
Could anyone suggest on this in a simple way.
Thanks,
Sandhya
depends on the flavour of source and target sql server
the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2008 at 6:57 am
Hi
you can also do this by setting the database to offline, use the alter database modify file statement and then set back to online after.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2008 at 6:50 am
sunshine (9/15/2008)
the previous statement must be terminated with a semicolon.
this message is fairly descriptive!! The USE statement and exec must be separated by a semi colon like so
SELECT @execmd =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2008 at 5:22 am
also, SQL2005 is able to address as much RAM as the NOS will allow 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 15, 2008 at 1:38 pm
Ninja's_RGR'us (9/15/2008)
Like I tested it and in this case exists is faster than in?
thats what i'm asking
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 15, 2008 at 10:33 am
Dana Bibeault (9/15/2008)
Can I install Windows Enterprise and run SQL 2005 Standard Edition?
that will be just fine, you'll need Enterprise edition of Windows server to address the extra RAM as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 15, 2008 at 10:30 am
Viewing 15 posts - 8,881 through 8,895 (of 9,244 total)