Viewing 15 posts - 8,641 through 8,655 (of 9,241 total)
ensure the virtual DC's clock is constantly in sync otherwise it could become orphaned from the domain
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2008 at 11:30 am
just use the update, dont rely on the updates being correct when done in the 2000 database. When moving from SQL2000 to 2005 always update stats and usage.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2008 at 10:39 am
when you share a folder in windows you have a share tab and a security tab. Share permissions and security permissions are different and need to be configured correctly...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2008 at 10:36 am
update stats using
sp_updatestats
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2008 at 6:22 am
ps (12/14/2008)
Though i consider attaching a database the simplest option to put the database back in action
that is the option that should used
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2008 at 12:44 pm
if for some reason you dont bring the logins across all is not lost
example.
database A has a user called BOB and there is a login called BOB on SQL server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2008 at 12:28 pm
Nicholas Cain (12/14/2008)
Kudos Perry, much kudos. 😎
thanks m8tey, at least i learnt something at school all those years ago.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2008 at 12:24 pm
matt stockham (12/14/2008)
because you restored the database in QA and started with an empty cache
exactly my thoughts
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2008 at 12:22 pm
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 14, 2008 at 5:16 am
ps (12/13/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"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
Viewing 15 posts - 8,641 through 8,655 (of 9,241 total)