learn how to create sql table,how to insert delete and edit data,,sql server monitoring,ms sql hosting,online sql training,sql if statement,sql date functions,oracle database,sql server versionsearning sql
If you install edition of Microsoft Visual Studio 2005 Bata1 first,Install . of edition of SQL Server Bata2 again nextCan hint when install you delete . of original SQL Server component(although had never installed SQL Server,also can hint) .
The CLR Version that its reason is edition of Visual Studio 2005 Bata1 is 2.0.40607.16,The CLR Version of edition of SQL Server 2005 Bata2 is 2.0.40607.42
Settle way:The Framework that deletes edition of Visual Studio 2005 Batϋ first,Edition of moving Visual Studio 2005 Bata1 installs dish of Dotnetfx.exe that go up to undertake deleting .Install edition of SQL Server 2005 Bata2 again next
————————————- The cut that is installation hind below pursues:
Component of SQL Server 2005
SQL Server Management Studio,Visit the style . of VSThe business management that joined SQL Server 2000 implement the functional . with inquiry analyzer
Object Explorer,Can examine a database,Manage a database,Build a database,Express,Manage a database
Template Explorer (stencil management implement) :Can examine . of grammar of statement of commonly used SQL
Microsoft SQL Server 7.0 Oracle 8i Standard Edition Quote:$1, 399 $3, 925 Per CPU Already included a client to count 5 Users (named Or Concurrent) 5 Concurrent Users Every add and intercurrent client / accredit client $127 / $127 $785 / $392.50 Server operating system supports Windows NT, windows 9x Windows NT, multiple Unix FlAvors The client carries an operating system to support Windows NT, windows 9x All Server Platforms Plus WiNdows 9x Network agreement supports AppleTalk, IPX, named Pipes, TCP/IP, vines IP IPX, named Pipes, TCP/IP Management Graphical tool: ? ? Install database Yes Yes Build administrative database / disk device Yes / Yes Yes / Yes Build management to express / index Yes / Yes Yes / Yes Build Yes Yes of administrative memory process Build administrative user Yes Yes Establish government duplicate join Yes Yes Back up and restore Yes Yes COLOR=”#ffffff “%26gt;Web releases Yes Yes Database chart Yes Optional Refer SQL inquiry and postmortem result Yes Yes Look carefully at Yes Optional of code of all and current executive SQL Examination resource sensitivity inquires / cleared inquiry Yes / Yes Yes / Yes Figure of server engine state changes Yes Yes Executive plan shows Yes Optional Offer the index that is based on onefold SQL statement to suggest / be based on server whole to apply Yes / Yes Optional / Optional All tools offer the visit means Yes Yes that is based on command travel COLOR=%26quot;#ffffff%26quot;%26gt;Reverse-engineer Database Objects/data To A SQL Script Yes / No Yes / Optional Offer the script that is based on command travel means to support JScript, OS Commands, SQL, transact-SQL, VB ScriptJava, OS Commands, PL/SQL, SQL, TCL The administrator reachs the safe log No Yes of user activity The time task that finish / Yes / Yes Yes / Yes of task of the activation when should appointing incident happening Online manual reachs search Yes Yes Server engine Levels Of Locking Granularity Available Database, table, page, row DatAbase, table, row Default Locking Level For Queries Row Row Readers Can Block Writers/writers Can Block Readers At Default IsolatiOn Level No / Yes No / No Can use multiprocessing implement divide a load / the inquiry that finish / build index Yes / Yes / No Yes / OptioNal / Optional Can use multiprocessing implement the backup that finish and restore / update / delete Yes / No / No Optional / OPtional / Optional Nest binds circularly (Join)/ no use binds / amalgamative coupling Yes / Yes / Yes Yes / Yes / Yes
Semi-join For Star Queries Yes Yes B-tree Index/Clustered Index/Bitmap Index Yes / Yes / Yes** Yes / Yes / Optional Cost-based/rule-based Optimizer Yes / No Yes / Yes Every inquiry can use multiple index Yes Yes Can Use Just The Index To Answer The Query Yes Yes Safeguard what what need automatically to optimize condition Yes Yes Parameter of dynamic SQL statement changes gentle to put Yes Yes Support is built be stationed in the watch Yes Yes that keeps memory Dynamic memory resource shares Yes No Every server supports CPU to count 4 4 Optional Yes of zero accident server Inquire resource manages Yes Yes Can allocate No Optional of different and first step for different user or group Increment backs up / Yes / Yes Optional / Optional can restore in some time place 8K 2K Or 8K of acquiescent disk data dimension The user can choose No Yes of disk data dimension Collateral / asynchronous (much task) disk operates Yes / Yes Yes / Yes The capacity of data and log equipment can increase Yes Yes when need 2000 attestation / euro supports Yes / Yes Yes / Yes Multimedia data type Binary big data (BLOB) Yes Yes Frequency / video / graphical No / No / No Yes / Yes / Yes Text documentation / geographical sex data / time Yes / No / Yes** Yes / Yes / Optional Seesaw pattern Coupling is other database ODBC, OLE DB Optional To the Yes / No / No Yes / Opt of onefold entry support of Windows NT / LDAP / OSF DCEIonal / Optional But process designing sex Memory process / trigger Yes / Yes Yes / Yes Inside buy programming language Transact-SQLJava, PL/SQL Memory process is debugged implement Optional Optional The client carries a database to support DB/LIB, ODBC, OLE DB CORBA, enterpriseJavaBeans, JDB C, OCI, ODBC, oracle Objects For OLE Inquire language and database are designed Version of SQL language supports SQL-92 Entry Level With Extensions SQL-92 Entry LevelWith Extensions ANSI separator supports Read Uncommitted, read Committed, repeatable Read, serIalizable, read Only Read Committed, serializable, read Only Left / right / Yes / Yes / Yes Yes / Yes / Yes of completely exterior coupling Yes Yes of referenced statement integrality Cascade is deleted / cascade updates No / No Yes / No Object-oriented design supports / the object is referenced (REFs) No / No Yes / Yes Branch office supports One-way / two-way and duplicate Yes / Yes Yes / Yes Pass Beep-Pager / Yes / Yes Yes / Yes of mistake of electronic correspondence clew Manager tool can manage server Yes Yes remotely Offer the administrative interface No Yes that is based on WEB The database is distributed processing general affairs / undertake handling clerical Yes / Yes Yes / Yes according to the library with other class number
Data storehouse Data lades the program can call disk page Yes Yes directly Data is changed and arrange tool Yes Yes When great data bulk is called defer agreement checks Yes Yes Undertake to collect information beforehand operation Yes** Optional Include OLAP server Yes Optional Inquiry rescripts automatically summary table No Optional Summaries understands dimensional structure Yes** Optional When data is changed No Optional of information of automatic refresh collect Can undertake data sampling increases processing speed No Optional Top N inquires / Top N Percent Of Total inquires Yes / Yes Yes / No Can Handle Ties When Ranking Top Rows Yes No Cube/rollup function Yes / Yes Yes / Yes Oracle 8i Windows NT Version With JServer And InterMedia Options. **In OLAP Services Only.
Role change, part crossing-over, and monitoring server is in the position
When come to a standstill of the database on the line (the likelihood is the work is defended inside the plan,Or it is the state outside anticipating) ,If return the database on server of aid having equipment to be able to be offerred,access,You may set your mind at one a little bit quite.The daily record with a good design is deferent system (trade the database log file conveys from main server equipment aid server) can give you such self-confident heart.Built-in at SQL Serve 2000 the program of tool of Enterprise Manager of enterprise board and development edition bears a daily record namely deferent function.
Role change
Convey the log from main server after less important server,You can be in drop main server with displacement of less important server when necessary.If main server produces a problem,Or it is plan sex come to a standstill (upgrade for example hardware or installation amend an order) ,During the database on the line must stop to serve a paragraph.The part that right now you can change the database on less important server,The database on the line is become then after letting it replace main server.The manual on line of SQL Server 2000 (Books Online,BOL) calls this operation the daily record deferent part is changed (Log Shipping Role Change) .Convey in the log in the process,Less important server needs set to be in cannot recover from an illness (Nonrecovered) condition,Because this trades,the log just can be answered from main server put less important server (one but you recover from an illness the database,cannot farewell is put trade record) .When changing a part,The database that you need will less important server gives recover from an illness,Indicative its are database of new main server.You also can be set of database of old main server database of new less important server.If database of old main server did not damage,Can be in so new main server and old main server (already became new less important server) between the new daily record that build place is deferent function.We call way of this kind of switch part crossing-over (Role Reversal) .
These operations are how-to can edit for six basic measure,It is respectively:1, move and remit enter order of enter an item in an account,2, demote (Demote) main server,3, upgrade (Promote) less important server,4, part of announcement monitoring server already was changed,5, analytic on less important server enter order of enter an item in an account,6, and concatenate database is accessed with attributive.
Measure 1: Move and remit enter order of enter an item in an account Above all,BOL suggests you build a SQL Server 2000 DTS to enclose (Package) ,Use will main server ascend date of enter an item in an account to transfer less important server,And carry out the analytic movement that SID of date of enter an item in an account records between each server.The DTS Transfer Logins Task that move ascends place of date of enter an item in an account to use can be used inside SQL Server 2000 DTS Designer only.You can be built on main server with store DTS is enclosed,Next the executive means that set of call Dtsrun.exe should enclose, the job that passes through main server SQL Server Agent (Job) .Should enclose the meeting when carrying out to will ascend date of enter an item in an account to convey from some server to another server,But it is not met analytic the SID(that its enter order of enter an item in an account is in can explain why to need in measure later analytic enter order of enter an item in an account) .However,To be in later can successful analytic enter order of enter an item in an account,You must establish a record first,The remit material that list of data of main server Syslogins contains inside its.
Remit ascends date of enter an item in an account to arrive when less important server,The SQL Server Agent that BOL suggests you establish a two level works:Use Bcp remit,And duplicate enter order of enter an item in an account.In the first measure,You will ascend the Bcp that uses primitive pattern remit of date of enter an item in an account to come a certain archives.And in the second measure,You must will ascend date of enter an item in an account to duplicate to a certain archives of less important server,So that make can be used when role change later analytic enter order of enter an item in an account.In measure the 5 SID that you put use Sp_resolve_logins the program to enter order of enter an item in an account beforehand.This job is built after finishing,OK and fixed ground is carried out (carry out every night for example) .Come so server admiral withholds secondary to publish document of remit of date of enter an item in an account newly at any time,So that undertake the log conveys,the part is changed.
Measure 2: Demote main server To let main server it is a log no longer the data sources of deferent system,You must it ” demote ” .You can demote the origin database of main server,Let it become potential less important server.Carry out Sp_change_primary_role to put a program beforehand on main server next,The purpose is to move to convey except original daily record function.Program code list 1 show this to put a program how to convey Pubscopy log beforehand database from read / write mode to be changed read-only equipment aid mode,Preparation is accepted at any time trade the backup data of the log.This meeting after putting program by to count a move beforehand conveys in the log main server database is deleted inside the plan.Afferent parameter puts those who accuse the program to need to carry out the following job beforehand:Backup is the closest trade all use person inside database of log, end are online, be in database set equipment hold status and the person that use more accesses a class.Put a program beforehand time pass code to narrate indicative BACKUP LOG sentence carry out whether successfully.
Program code list 1:Convey the log database from read / write mode to demote read-only of mode put a program beforehand.
Measure 3: Upgrade measure of the next of less important server is upgrade current and less important server to recover from an illness condition (Recovered State) ,Such its ability replace the database on original line,And turn potential log into database of deferent and main server.On less important server,If you already affirmed the person that do not have any use continues to put access,occupy a library,Can carry out Sp_change_secondary_role to put a program beforehand,Like program code list 2 are shown:
Program code list 2:Put what database of less important server upgrades into main server database the program beforehand.
These parameter will make this put a program to try to trade all the rest beforehand log file duplicates from former and main server to less important server,And secondary of these log file to load server database.Parameter @do_load=1 can undertake backing up recently,And to load is all trade log file;Parameter @force_load=1 is appoint when executive Sqlmaint.exe have not the Forceload option that the file converts;Parameter @final_state=1 is set of database of new main server recover from an illness mode;Parameter @access_level will access means to set a cond
ition of the person that use more before.The database of the person that parameter @terminate=1 makes this put a program to interrupt all use beforehand accesses a movement, means is to carry out ALTER DATABASE to cooperate IMMEDIATE option.However,When if carry out this,putting a program beforehand,Between your own Enterprise Manager and database online be in open condition,Movement of ALTER DATABASE will fail.So you must move means to affirm with the hand whether to already have place the database online give interrupt.Finally,If this database is autotyped for the database by set (the publisher database of Replication) (Publisher) ,So @keep_replication=0 parameter will maintain a server to get on all autotyping as before set.
If you ever chose to let less important server become the main server with potential future,Criterion the database safeguards a plan to meet place is built on less important server one trades log backup works (the Transaction-log Backup Job) of SQL Server Agent.After this job activations,Trade log backup file can begin to appear in new main server.You need these archives to go reset conveys the log a new less important server.