Viewing 15 posts - 8,656 through 8,670 (of 9,244 total)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2008 at 4:58 am
can you change it back again?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2008 at 8:52 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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2008 at 1:51 pm
the dis advantage of log shipping is that the best state you can get is read only, the database will be unavailable when log restores take place. Replication will produce...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2008 at 1:43 pm
dont forget to rebuild all the indexes afterwards too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2008 at 1:33 pm
run a repair on the .NET2 framework via add\remove programs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2008 at 1:24 pm
or just click start then run and type
odbcad32
then hit return 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2008 at 3:15 pm
Viewing 15 posts - 8,656 through 8,670 (of 9,244 total)