Viewing 15 posts - 8,881 through 8,895 (of 9,248 total)
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
you could also run a repair of the .NET framework via add\remove programs
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...
September 16, 2008 at 7:57 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...
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.
September 16, 2008 at 6:50 am
Viewing 15 posts - 8,881 through 8,895 (of 9,248 total)