Viewing 15 posts - 8,641 through 8,655 (of 9,244 total)
once you have updated usages and indexes\stats run the following against the database
dbcc checkdb (mydatabase) with all_errormsgs, no_infomsgs, data_purity
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2008 at 3:52 pm
what is the version of your sql instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2008 at 3:38 pm
K. Brian Kelley (12/15/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2008 at 3:30 pm
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
Viewing 15 posts - 8,641 through 8,655 (of 9,244 total)