Viewing 15 posts - 8,881 through 8,895 (of 9,253 total)
as a side make sure you change the account details via SQL configuration manager 😎
September 30, 2008 at 6:21 am
the datareader role should grant select to all tables
September 30, 2008 at 6:16 am
you should be able to patch both instances at once, did you select both detected instances?
Have you checked the patch log file to find out why it failed?
September 30, 2008 at 6:14 am
Mike (9/29/2008)
My current VM Instances are configured with 20 gig of hd space and 2 gig of memory
wow as little as that. 20GB will just about home the OS,...
September 29, 2008 at 2:16 pm
ramyours2003 (9/15/2008)
how can we solve space issue in sql server?
stick it on the moon then its got all the space it needs.
September 26, 2008 at 9:52 am
dakshinamurthy (9/26/2008)
I would like to start and store the sql profiler trace in a location, but it should be automated, i mean to say instead of...
September 26, 2008 at 9:47 am
onlo (7/2/2008)
However, I found both of its "Total Server Memory" & "Target Server Memory" are far below the physical...
September 25, 2008 at 4:54 pm
steveb (9/22/2008)
You will need a different maintaince plan for T-Logs and Full Backups.
you can use 1 maint plan if you like, launch the wizard and it asks "schedule for each...
September 23, 2008 at 2:21 pm
Ray Herring (9/23/2008)
September 23, 2008 at 2:11 pm
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...
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...
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...
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...
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...
September 18, 2008 at 10:52 am
you would probably need the latest MDAC update for the SQL driver
September 18, 2008 at 10:49 am
Viewing 15 posts - 8,881 through 8,895 (of 9,253 total)