Viewing 15 posts - 8,656 through 8,670 (of 9,248 total)
when you run the SP it gives you the details of any database instances and comonent tools. Re run it and post a screenshot can you
December 14, 2008 at 5:16 am
ps (12/13/2008)
December 14, 2008 at 5:09 am
ensure you set the min and max memory to the required settings for the RAM you are using
December 14, 2008 at 5:07 am
query plans are held in cache memory, are the machines the same spec or different (cpu and memory)
December 14, 2008 at 5:06 am
madhu.arda (12/13/2008)
From the system monitor I got the max value for the Page File Bytes Peak as 1.7276e+010.could you plz tell me to calculate this into GB.
i havent done this...
December 14, 2008 at 4:58 am
can you post the complete error message?
aside Gails recommendation, why pre create the databases before restoring the backups.
detach, copy and attach would be my preference. Drop the existing databases you...
December 13, 2008 at 5:14 am
madhu.arda (12/11/2008)
getting free space in virtual memory is less.
it would be more important to try and ascertain what is causing the paging
December 13, 2008 at 5:07 am
ahenderson (12/12/2008)
gave permission to everyone.
your talking share permissions here right?
What "security" permissions did you set?
December 13, 2008 at 4:58 am
vickiy (12/11/2008)
AWE only applies to Enterprise, doesn't it?
no, under sql2005 AWE applies to 32bit Std, Dev and Ent as does the lock pages in memory option.
http://msdn.microsoft.com/en-us/library/ms175581(SQL.90).aspx
Under sql2005 64bit only Ent...
December 13, 2008 at 4:52 am
the white icons mean you do not have permissions on that server to manage the sql services (stop,start, etc)
December 13, 2008 at 4:21 am
dont forget to carry out the post 2005 migration tasks.
run dbcc update usage and rebuild all indexes\stats
December 11, 2008 at 5:01 pm
attach the databases first as when the script is applied to add the logins it will fail as the users default database does not exist. Maybe it doesn't really matter...
December 11, 2008 at 4:00 pm
Jeff Moden (12/9/2008)
... heh... or some very high velocity pork chops fired at point blank range. 😉
tee hee hee ROTFL
December 11, 2008 at 2:24 pm
awp (12/11/2008)
I have decided to do a side by side installation:
undoubtedley the best way to go
awp (12/11/2008)
- script all the logins from sql 2000 instance and...
December 11, 2008 at 1:51 pm
Viewing 15 posts - 8,656 through 8,670 (of 9,248 total)