Có 120+ tài liệu thuộc chủ đề "Giáo trình SQL Server 2008"
tailieu.vn Xem trực tuyến Tải xuống
A palindrome is a word, phrase, or number that’s the same backward or forward, such as ‘‘kayak’’ or ‘‘drab as a fool, aloof as a bard.’’. The first backup must be a full database backup to begin the backup cycles. The backup source is configured in the General page:. Database: The database to be backed up. Backup type: The type...
tailieu.vn Xem trực tuyến Tải xuống
The restore never copies only yesterday’s work. A restore copies the data back into the database and leaves the transactions open. Recovery is the process of handling the transactions left open in the transaction log. Only logins who are members of the sysadmins fixed server role can restore a database that doesn’t currently exist. Performing the restore with Management Studio....
tailieu.vn Xem trực tuyến Tải xuống
Nielsen c41.tex V pm Page 982. Before restoring the msdb database, stop SQL Server Agent. This ensures that the msdb database is not being accessed by the SQL Server Agent and allows the restore to complete.. Install SQL Server and any service-pack, cumulative updates, security upgrades, or hotfixes.. Start SQL Server in single-user mode and restore the master database.. Verify...
tailieu.vn Xem trực tuyến Tải xuống
If the database requires repair, always use the full DBCC CHECKDB over one of the lesser versions:. A subset of DBCC CHECKDB that checks the allocation of all pages in the database. The report is very detailed, listing the extent count (64KB or eight data pages) and data-page usage of every table and index in the database.. Above the physical-structure...
tailieu.vn Xem trực tuyến Tải xuống
DBCC MEMORYSTATUS : Provides a snapshot of the current memory status of SQL Server.. This command is very useful in troubleshooting issues that relate to SQL Server memory consumption.. Trace flags are used temporarily to set certain specific SQL Server characteristics or turn off some behavior. For example, trace flag 1204 is used to enabled deadlock reporting to SQL Server...
tailieu.vn Xem trực tuyến Tải xuống
Open the Services console found in the Administrative Tools folder of the Control Panel.. Right-click the SQL Server Agent (Instance) service and choose Properties from the context menu.. The SQL Server Agent service is displayed as SQL Server Agent, with the instance name appearing in parentheses. The instance name is MSSQLSERVER for default instance of SQL Server. If more than...
tailieu.vn Xem trực tuyến Tải xuống
FIGURE 43-7. As with alerts, create a new job using the New Job dialog. As you will see in the next section, when defining a job, you can assign a category to it. Start SQL Server Management Studio.. Right-click the SQL Server Agent\Jobs folder and choose Manage Job Categories from the context menu. This brings up the Manage Job Categories...
tailieu.vn Xem trực tuyến Tải xuống
FIGURE 43-17. FIGURE 43-18. Create a new account for Database Mail.. Notice that the new account you created in the previous step is added to the profile, as shown in Figure 43-19. Clicking Add sets up multiple accounts for the Database Mail profile to allow for Failover and avoid single points of failure.. FIGURE 43-19. Add an account to the...
tailieu.vn Xem trực tuyến Tải xuống
FIGURE 44-2. Select the destination server. FIGURE 44-3. Select the databases you want to copy or move. On page 5 (Configure Destination Database), shown in Figure 44-5, the wizard asks you to configure the destination database. You modify the destination database name and the default locations for the database files on the destination server. On page 6 (Select Server Objects),...
tailieu.vn Xem trực tuyến Tải xuống
Though it is often overlooked, one of the easiest ways to move a database from one computer to another is to detach the database, copy the files, and attach the database to SQL Server on the destination computer.. Detaching a database effectively deletes the database from SQL Server’s awareness but leaves the files intact. The database must have no current...
tailieu.vn Xem trực tuyến Tải xuống
Note the logical name of the data files listed under the name column and their sizes. For each data file in the source database there is a data file in the database snapshot. The data files in the database snapshot are different from the source database data files. The data files in the database snapshot are NTFS sparse files. When...
tailieu.vn Xem trực tuyến Tải xuống
cation connections must redirect the data source and reconnect to the warm standby server.. Once the primary server is repaired, returning to the original configuration may require manual DBA intervention.. If these issues are acceptable, log shipping to a warm standby server can be an excellent safeguard against downtime.. I deally, the primary server and the warm standby server should...
tailieu.vn Xem trực tuyến Tải xuống
Notice that it also has the option of scripting the log shipping configuration.. If your log shipping has a number of non-default options, scripting your changes makes it easier to ensure that each time it is done the configuration stays the same.. FIGURE 46-8. Finished configuring log shipping. Once you click OK, the Save Log Shipping Configuration dialog box sets...
tailieu.vn Xem trực tuyến Tải xuống
What’s New in SQL Server Database Mirroring?. S QL Server 2008 database mirroring has some exciting new features, one of which is called log com- pression. As the name suggests, this feature compresses the transaction log records on the production server before sending them to the mirror server. This means that if the production or mirror server is unable to...
tailieu.vn Xem trực tuyến Tải xuống
Configuring the principal server. On the Mirror Server Instance page, shown in Figure 47-8, click the Connect button to display the Connect to Server dialog. Type the connection properties of the mirror server and click Connect. This will bring you back to the Mirror Server Instance page. Type the TCP/IP port for the endpoint on the mirror server. (Just like...
tailieu.vn Xem trực tuyến Tải xuống
Monitoring a database mirroring session. Apart from using the Database Mirroring Monitor, you can also use System Monitor (previously referred to as Performance Monitor) to monitor database mirroring performance. The SQLServer:Database Mirroring object contains the database mirroring performance counters. Log Bytes Sent/sec: Indicates the rate at which the principal is transferring transaction log records to the mirror.. Log Send Queue...
tailieu.vn Xem trực tuyến Tải xuống
Protect data: Implementing SQL Server 2008 failure clustering does not obviate the need to take backups or run consistency checks ( DBCC CHECKDB. Microsoft SQL Server 2008 failover clustering is part of an entire strategy needed to help reduce downtime. How SQL Server 2008 failover clustering works. After installing SQL Server 2008 failover clustering, the nodes that run the SQL...
tailieu.vn Xem trực tuyến Tải xuống
FIGURE 48-3. Select Installation from the left side of the SQL Server Installation Center. Click Installation on the left-hand side of the SQL Server Installation Center. Select ‘‘New SQL Server failover cluster installation’’ to start the single-node SQL Server 2008 failover cluster, as shown in Figure 48-4.. For example, the wizard checks whether the cluster node has the minimum operating...
tailieu.vn Xem trực tuyến Tải xuống
Entering the SQL Server service accounts on the Server Configuration page. On the Error and Usage Reporting page, select the information that you want to automatically send to Microsoft to improve the SQL Server features and services. The Cluster Installation Rules page runs a set of rules to determine whether the SQL Server 2008 failover cluster installation will be blocked....
tailieu.vn Xem trực tuyến Tải xuống
Then, during a scheduled downtime, failover the SQL Server 2005 instance (SQL2005INST1) from NODE2 to NODE1. For example, I saw one failover take 10 minutes, as the SQL Server 2005 instance was dependent on 20 drives and it took all the drives approximately 10 minutes to come online and SQL Server can be online only after the drives it is...