ֵĶԻͿԿSIDͶ˿ںԻпԿݿʵSIDͶ˿ں ҵûSYSTEMҪڲһ¸ûǷ ͼ е ᵯһ ĵ¼quotĽ ûдҪԵûڿдȷص ʾԳɹûǿõ ڿͻȡҪȵӽе ĽдӦӲ дɺ ӦIJᴫĽ û˵оͿԿݿѡݿ߾ͿԿƺͻѡ ڷȡôֱѡ ͼ дݿʵûӾͿԿ ѡݿ߾ͿԿƺͻѡ ע˵SYSTEMsystemoraclemananger 9. ֹȡdzֱͼ ĸԭݿԭֹпĿƹ40ֻѿĿƸĶ̾Ϳԡ 10. 5002ȡʾҵӲ ϵͳʱ䲻ԡͼ ϵͳ
1.νжŵǰת 1õȫݵֻ1-6µôҪһת ѡСŵת ġǰ˲ɼļ.sjc ұߵļѡҪתsjcļ ѡֻʱֻҪ1-12¸ij1-6·ݼ
ٵʼתתɹʾʱsjcļݾ1-6·ݵˡ
2ҵ.bakļݿⱸļǾҪлԭǰDZѾװsqlserver ݿҹ˾վMSDEsqlserverݿ档ݿһڿʼ˵--òҲ¿ʼ- net start mssqlserver سɡ ѡŵת ĵsqlserverļ.bak.mdf.bak·ѡݿĿ¼Ǹݿİװ·ĬϵĴʱDzҪĶĵťѡ·ɡݿǿԼ塣ȻԭݿSQLSERVER ʱǿֱӰתݵϵͳǰݵ-ֱSQLSERVERݿ㡰ӡѡղŻԭݿơ ʱҪһתתɹݵıɫٵȷͿԵˡͼ
3ҵmdfļݿļldfļݿ־ļҪIJתbakļһġ ˵תֱתûsjcļҪsjcļݿתɹȲҪáǰݵ롰ܡǴǰļ ѡͺsqlserver ӻʾּݿݿбѡѡղתݿƼɡ ʱֻʼȡȡϺᵯԻѡ·
Եõsjcļˡͼ õsjcļϵͳתĹˡ
2.ƶ˵Ĵ ͨǰȡߵǰļ0507Ϊֱ05-07ȵ.sjcǰļ ȻϵͳдĿڼѡ05Ŀ¼Ŀϵͳ˵еġĿάĿڵǰĿ´µȡ06ĿԴַʽ07ĿĴעǵһһҹ˾3һҪѡѡеλǼŹ˾һҪѡʹһȵĵλϵŹ˾áѡѡһΪȵһӷֹ˾ģ塣 ʱͨϵͳĿǰĿ05-07ȴֻҪǰļ˳ֱ뵽Ӧе˶״Ĺˡ ʱ05ʼڵ06귢ʱԶ05лȡûа˳.