HOME > .NET Framework > Forum > ตั้ง backup auto data baes sql server 2008 r2 ไม่ได้ตอนตั้งไม่มีปัญหาแต่จะมีปัญหาตอนทดสอบนะจ้าช่วยดูให้หน่อยรบกวนผู้รู้ช่วยแนะนำหน่อยจ้า...
ตั้ง backup auto data baes sql server 2008 r2 ไม่ได้ตอนตั้งไม่มีปัญหาแต่จะมีปัญหาตอนทดสอบนะจ้าช่วยดูให้หน่อยรบกวนผู้รู้ช่วยแนะนำหน่อยจ้า...
2012-08-16 03:07:24.11 Server Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
Jul 9 2008 14:43:34
Copyright (c) 1988-2008 Microsoft Corporation
Standard Edition on Windows NT 6.0 <X86> (Build 6002: Service Pack 2)
2012-08-16 03:07:24.11 Server (c) 2005 Microsoft Corporation.
2012-08-16 03:07:24.11 Server All rights reserved.
2012-08-16 03:07:24.13 Server Server process ID is 1444.
2012-08-16 03:07:24.13 Server System Manufacturer: 'HP', System Model: 'ProLiant DL380 G7'.
2012-08-16 03:07:24.13 Server Authentication mode is MIXED.
2012-08-16 03:07:24.13 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2012-08-16 03:07:24.14 Server This instance of SQL Server last reported using a process ID of 1824 at 8/16/2012 3:02:32 AM (local) 8/15/2012 8:02:32 PM (UTC). This is an informational message only; no user action is required.
2012-08-16 03:07:24.14 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2012-08-16 03:07:24.21 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2012-08-16 03:07:24.21 Server Detected 8 CPUs. This is an informational message; no user action is required.
2012-08-16 03:07:24.33 Server SQL Server is not configured to use all of the available system memory. To enable SQL Server to use more memory, set the awe enabled option to 1 by using the sp_configure stored procedure.
2012-08-16 03:07:24.64 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2012-08-16 03:07:24.94 Server Node configuration: node 0: CPU mask: 0x000000ff Active CPU mask: 0x000000ff. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2012-08-16 03:07:25.10 spid6s Starting up database 'master'.
2012-08-16 03:07:25.30 spid6s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2012-08-16 03:07:25.50 spid6s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2012-08-16 03:07:25.66 spid6s SQL Trace ID 1 was started by login "sa".
2012-08-16 03:07:25.67 spid6s Starting up database 'mssqlsystemresource'.
2012-08-16 03:07:25.70 spid6s The resource database build version is 10.00.1600. This is an informational message only. No user action is required.
2012-08-16 03:07:26.30 spid11s Starting up database 'model'.
2012-08-16 03:07:26.31 spid6s Server name is 'PTT-SERVER'. This is an informational message only. No user action is required.
2012-08-16 03:07:26.36 spid6s Informational: No full-text supported languages found.
2012-08-16 03:07:26.36 spid14s Starting up database 'dbwins_ptt2552'.
2012-08-16 03:07:26.36 spid13s Starting up database 'msdb'.
2012-08-16 03:07:26.36 spid15s Starting up database 'test'.
2012-08-16 03:07:26.88 Server A self-generated certificate was successfully loaded for encryption.
2012-08-16 03:07:26.89 Server Server is listening on [ 'any' <ipv6> 1433].
2012-08-16 03:07:26.89 spid11s Clearing tempdb database.
2012-08-16 03:07:26.89 Server Server is listening on [ 'any' <ipv4> 1433].
2012-08-16 03:07:26.89 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2012-08-16 03:07:26.89 Server Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
2012-08-16 03:07:26.91 Server Server is listening on [ ::1 <ipv6> 1434].
2012-08-16 03:07:26.91 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2012-08-16 03:07:26.91 Server Dedicated admin connection support was established for listening locally on port 1434.
2012-08-16 03:07:27.00 Server The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/PTT-SERVER.Domain.local ] for the SQL Server service.
2012-08-16 03:07:27.00 Server The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/PTT-SERVER.Domain.local:1433 ] for the SQL Server service.
2012-08-16 03:07:27.00 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2012-08-16 03:07:28.39 spid11s Starting up database 'tempdb'.
2012-08-16 03:07:28.69 spid13s The Service Broker protocol transport is disabled or not configured.
2012-08-16 03:07:28.70 spid13s The Database Mirroring protocol transport is disabled or not configured.
2012-08-16 03:07:28.72 spid13s Service Broker manager has started.
2012-08-16 03:07:28.73 spid6s Recovery is complete. This is an informational message only. No user action is required.
2012-08-16 03:07:31.09 spid51 Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
2012-08-16 03:07:31.14 spid51 Using 'xpsqlbot.dll' version '2007.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2012-08-16 03:07:31.43 spid51 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2012-08-16 03:07:31.53 spid51 Using 'xpstar.dll' version '2007.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2012-08-16 03:07:31.75 spid51 Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2012-08-16 03:07:31.76 spid51 Using 'xplog70.dll' version '2007.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2012-08-16 11:01:14.93 spid76 Setting database option RECOVERY to FULL for database dbwins_ptt2552.
2012-08-17 00:00:45.85 spid24s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-08-18 00:00:58.75 spid16s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-08-19 00:00:13.28 spid20s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-08-20 00:00:13.51 spid16s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-08-21 00:00:16.18 spid25s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-08-22 00:00:23.19 spid17s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-08-23 00:00:36.31 spid23s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-08-24 00:00:58.22 spid20s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-08-25 00:00:16.53 spid19s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-08-26 00:00:19.08 spid18s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-08-27 00:00:25.67 spid20s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-08-28 00:00:33.73 spid16s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-08-29 00:00:51.30 spid17s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-08-30 00:00:03.88 spid16s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-08-31 00:00:16.50 spid16s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-08-31 14:35:10.13 spid87 Setting database option RECOVERY to SIMPLE for database dbwins_ptt2552.
2012-08-31 14:35:23.38 Logon Error: 18456, Severity: 14, State: 11.
2012-08-31 14:35:23.38 Logon Login failed for user 'Domain\Administrator'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]
2012-08-31 14:48:33.03 Logon Error: 18456, Severity: 14, State: 11.
2012-08-31 14:48:33.03 Logon Login failed for user 'Domain\Administrator'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]
2012-08-31 15:00:29.71 Backup Database backed up. Database: dbwins_ptt2552, creation date(time): 2012/02/03(09:29:41), pages dumped: 1153170, first LSN: 229461:136:138, last LSN: 229461:310:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'D:\backup winspeed\ptt-52'}). This is an informational message only. No user action is required.
2012-09-01 00:00:18.96 spid20s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-09-02 00:00:36.71 spid16s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-09-03 00:00:38.94 spid18s This instance of SQL Server has been using a process ID of 1444 since 8/16/2012 3:07:28 AM (local) 8/15/2012 8:07:28 PM (UTC). This is an informational message only; no user action is required.
2012-09-03 16:09:17.06 Logon Error: 18456, Severity: 14, State: 11.
2012-09-03 16:09:17.06 Logon Login failed for user 'Domain\Administrator'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]
2012-09-03 16:11:52.03 Logon Error: 18456, Severity: 14, State: 11.
2012-09-03 16:11:52.03 Logon Login failed for user 'Domain\Administrator'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]
2012-09-03 16:15:55.60 Logon Error: 18456, Severity: 14, State: 11.
2012-09-03 16:15:55.60 Logon Login failed for user 'Domain\Administrator'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]
Load balance : Server 03
