实验一SQL-Server服务器管理与创建数据库.doc

marketing strict internal cost control, business and innovation performance. -Increasing electricity access, price increase, electricity supply is guaranteed. In 2012, the company with coal inventory, get rewards of Jiangsu provincial government power to 266 million kWh. Through the small and bilateral trade, access to electricity 1.695 billion kWh, seeking removal compensation when the power 50 million-kilowatt, 116% market share in Jiangsu Province ranked first in the same capacity, the same type units. Company closely tracked coal linkage policies on July 1 and August 20 respectively increase prices 2.08 minutes and 2.5 points, profitability increased significantly. 公 . Job grading, remuneration of labour agreements into long-term contract workers compensation system, stimulating the enthusiasm of the staff. -Further strengthening of human resources management. Full implementation of the performance appraisal regulations, incentive effect. Complete the reserve cadre evaluation and selection, produced 10 primary reserve cadres and 11 secondary reserve cadres. Implementation of operation staff induction gang system, 14 staff posts be promoted. Strengthening the cultivation of professional technical leaders, selected coverage 9 13 factory-level professional and technical leaders. To enhance staff skills training, 8 staff technicians. Labor contract law compliance, contracts of up to 100%. -Star team-building to advance further. Establish a holding system implementation, and promoting the whole team-building goals, strengthen group management. Team building into a performance review, promoting the construction of the star team depth. This year, respectively, 1 track, 4 team four star rated five-star by Datang and the team. Four, insists on six cultural construction of harmonious development, really good job of party construction and the independent Commission against corruption, strengthening the humanistic care and psychological counseling, the enterprise culture construction to a new level. -Building of enterprise culture is fruitful. Companies adhere to the Shenhua lead of corporate culture, culture of responsibility at the core, to safety culture, a culture of learning, ethical culture, cost culture culture system-assisted, through various cultural integration, has boosted business centre, this year has won the Chinese cultural management advanced unit, National Advanced Unit in the building of enterprise culture of reform and opening up 30 and other honorary titles. The liability of the company culture: solving management problems of corporate culture project was awarded the CEC national electric power enterprise culture achievement award of excellence. The accident early warning and prevention system was rated as Chinas power of innovation management, innovation management of electric power enterprise in Jiangsu Province. -Party and the independent Commission against corruption continues to strengthen. Was carried out to maintain洛阳理工学院实验报告系别计算机与信息工程系班级学号姓名课程名称数据库系统应用实验日期2014.2.26实验名称实验一SQL Server服务器管理与创建数据库成绩实验目的：1认识和熟悉SQL Server系统及其主要组件；2掌握服务器注册和管理；3掌握数据库创建和管理。实验条件：连在局域网中的微机1台、SQL Server 2008实验内容与步骤：请按顺序完成下面的操作，用文字或图记录问题的结果：1查看所使用的计算机名，使用SQL Server 配置管理器查看本机上安装了哪些实例？ 其实例名是什么？安装了哪些服务？Sqlserver2005;MSSQLSERVER2练习用2种不同方法启动SQL SERVER服务。1.我的电脑右键-管理-服务和应用程序-服务-右边列表中将列出所安装的所有SQL Server 2005服务。选择要启动的服务，单击鼠标右键，在弹出的菜单中选择“启动”命令，启动服务 2.开始-程序-Microsoft SQL Server 2005-配置管理器-SQL Server Configuration Manager,单击左边列表的“SQL Server 2005服务”，右边列表中将列出所安装的所有SQL Server 2005服务。选择要启动的服务，单击鼠标右键，在弹出的菜单中选择“启动”命令，启动服务3在SQL Server Management Studio（SSMS）中删除已有的SQL SERVER注册，再添加SQL SERVER注册。4安装示例数据库AdventureWorks，并附加到本机默认实例中。 5用SSMS创建数据库student，该数据库的主数据文件完整文件名为D: studentdata1.mdf，初始大小为5M，无限增长，每次增长1M，次要数据文件完整文件名为D: studentdata2.ndf，初始大小为3M，无限增长，每次增长1M，日志文件完整文件名为D: studentlog.ldf，初始大小为1M，最大增长到3M，每次增长1M。 6查看数据库student的属性，并记录其所有者。 CC1223Administrator7用SSMS在数据库student中创建一个表，查看该表的属性，并记录该表存储哪个文件组中？ PRIMARY文件组8将student数据库分离，拷贝到U盘上或发送到邮箱中。 右键student数据库，在任务了找到分离，分离数据库。9执行如下代码，若不成功，分析并记录问题所在，修改语句，使语句执行成功。（提示：注意文件路径是否存在，若不存在，要先建立相关路径）然后回答问题：（1）该数据库包括_3_个文件组？分别是_PRIMARY、SalesGroup1、SalesGroup2_。（2）该数据库包括_5_个数据文件和_1_个日志文件。CREATE DATABASE Sales1ON PRIMARY( NAME = Sales_mdata, FILENAME =C:SQLSales_mdata.mdf, SIZE = 10, MAXSIZE = 50, FILEGROWTH = 15% ),( NAME = Sales_ndata1, FILENAME = C:SQLSales_ndata1.ndf, SIZE = 10, MAXSIZE = 50, FILEGROWTH = 15% ),FILEGROUP SalesGroup1( NAME = Sales_ndata2, FILENAME = C:SQLSales_ndata2.ndf, SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 ),( NAME = Sales_ndata3, FILENAME = C:SQLSales_ndata3.ndf, SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 ),FILEGROUP SalesGroup2( NAME = Sales_ndata4, FILENAME = C:SQLSales_ndata4.ndf , SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 )LOG ON( NAME = Sales_log, FILENAME = C:SQLSales_log.ldf, SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB )10上述Sales数据库创建成功后，在SSMS中收缩Sales数据库，记录收缩后数据库的大小，要求收缩后数据库至少减小10M。11在SQL Server 联机丛书中查找ALTER DATABASE语句格式，并参照它写ALTER DATABASE语句，从Sales数据库中删除数据文件Sales_ndata4和文件组Sales_log。12（选做）写出创建快照的语句，给Sales数据库创建快照。13（选做）将其他计算机上的SQL Server实例注册到你计算机上的SSMS中，如果不成功，分析其原因。实验总结（结论或问题分析）：本次试验SQL数据库文件进行了创建，收缩，创建快照等操作。对SQL Server 2005 的默认实例认识，练习了服务器的注册、删除、启动、关闭等操作。进一步了解了数据库的认识。以区域为单位进行有效组织，通过全国统一商品营销和区域活动促销的方式相结合，紧抓春节黄金时段，及节中、节后的消费需求，以中国古今结合“穿越式”的龙年春节文化为主题，security, profit, maintain stability and promote harmonious development as the main content of the three guarantees theme practice activities and stressing party spirit, to conduct, for example campaign, party and further improvement of the level of work. Staff participating in the honest and clean culture construction seminars, staffs sense of probity and enhanced. Founded by honest inspectors team composed of 12 employees to broaden the channels of supervision. Adhere to establish four good leadership activities, staff satisfaction rate of 98% to the team. -Group work dynamic. Promoting the openness of factory Affairs, proposal for a love letter box, to the vital interests of the staff Trade Union delegation leader meeting of the 26 system to discuss and safeguard their democratic rights. Improve the organizational structure of the mission, the work of strengthening. Organize maintenance labor emulation and health Cup competition, enhance the skills of staff. Organized a variety of cultural activities, physical and mental health care staff, to create a harmonious atmosphere. During the Wenchuan earthquake, donated all the company employees, to love, to support the disaster areas. This year, the company has won the Su . Cutting costs can be controlled, money should not be wasted management philosophy, management analysis, to improve management quality, improve cost control capacity and market competitiveness. Innovation of science and technology-science and technology innovation is to play the role of science and technology as the primary productive force, active use of new technologies, new materials, new processes, new equipment, increase investment in science and technology, strengthening scientific and technological training, speeding up transforming scientific and technological achievements, forming a number of proprietary technology, enhancing core competitiveness. Resource-saving-the-resources saving enterprise was to reduce coal consumption, water consumption, electricity at the core, enhance the operation of lean management to realize low consumption, high efficiency, reduce production costs. Second is to strengthen the business, financial, material, information and the optimization