恢复数据库备份的时候,特别慢 恢复数据库备份的时候,特别慢,左下角一直显示执行查询,怎么办呢,昨天我刚恢复的,速度很快的,备份文件也就7G左右吧 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 以下是运行sp_who2显示的结果:1 BACKGROUND sa . . NULL RESOURCE MONITOR 0 0 05/12 14:05:35 1 0 2 BACKGROUND sa . . NULL LAZY WRITER 93 0 05/12 14:05:35 2 0 3 SUSPENDED sa . . NULL LOG WRITER 4281 0 05/12 14:05:35 3 0 4 BACKGROUND sa . . NULL LOCK MONITOR 0 0 05/12 14:05:35 4 0 5 BACKGROUND sa . . master SIGNAL HANDLER 0 0 05/12 14:05:35 5 0 6 sleeping sa . . master TASK MANAGER 0 0 05/12 14:05:35 6 0 7 BACKGROUND sa . . master TRACE QUEUE TASK 46 0 05/12 14:05:35 7 0 8 sleeping sa . . NULL UNKNOWN TOKEN 0 0 05/12 14:05:35 8 0 9 BACKGROUND sa . . master BRKR TASK 0 0 05/12 14:05:35 9 0 10 BACKGROUND sa . . master TASK MANAGER 0 0 05/12 14:05:35 10 0 11 SUSPENDED sa . . master CHECKPOINT 2562 453 05/12 14:05:35 11 0 12 BACKGROUND sa . . master BRKR EVENT HNDLR 0 33 05/12 14:05:35 12 0 13 BACKGROUND sa . . master BRKR TASK 0 0 05/12 14:05:35 13 0 14 sleeping sa . . master TASK MANAGER 0 0 05/12 14:05:35 14 0 15 sleeping sa . . master TASK MANAGER 0 0 05/12 14:05:35 15 0 16 sleeping sa . . master TASK MANAGER 0 0 05/12 14:05:35 16 0 17 sleeping sa . . master TASK MANAGER 0 0 05/12 14:05:35 17 0 18 sleeping sa . . master TASK MANAGER 0 0 05/12 14:05:35 18 0 19 sleeping sa . . master TASK MANAGER 0 0 05/12 14:05:35 19 0 51 sleeping SH\Administrator SH . master AWAITING COMMAND 94 0 05/25 13:55:12 Microsoft SQL Server Management Studio 51 0 52 sleeping NT AUTHORITY\SYSTEM SH . msdb AWAITING COMMAND 0 51 05/27 03:00:00 SQLAgent - Job invocation engine 52 0 53 sleeping NT AUTHORITY\SYSTEM SH . msdb AWAITING COMMAND 94 26 05/12 14:05:37 SQLAgent - Generic Refresher 53 0 54 sleeping SH\Administrator SH . master AWAITING COMMAND 94 0 05/27 10:10:09 Microsoft SQL Server Management Studio 54 0 55 SUSPENDED SH\Administrator SH . master RESTORE DATABASE 78 42 05/27 10:09:57 Microsoft SQL Server Management Studio - Query 55 0 55 RUNNABLE SH . master RESTORE DATABASE 15 0 05/27 10:09:57 Microsoft SQL Server Management Studio - Query 55 0 55 SUSPENDED SH . master RESTORE DATABASE 78 0 05/27 10:09:57 Microsoft SQL Server Management Studio - Query 55 0 56 RUNNABLE SH\Administrator SH . master SELECT INTO 16 6 05/27 10:20:15 Microsoft SQL Server Management Studio - Query 56 0 1.我在这之前还原一个5G的全备,用了6分钟时间,这个也是全备(7G),现在还原了20%,但是已经用时40分钟了,2.我在前天也是这样还原这个7G的备份,用时大概10分钟左右,备份是同样的 sql 特定数据删除 一列转多行 这个错误什么意思? 这种插入SQL语句如何写 更新表中某字段值,而该字段值递增,怎么写? ms-sql2005行列转换 一個UPDATE SQL語句 How to add an image into one table.and display it???(wait online) log explorer 使用中碰到问题 分布式数据库服务器问题!! tsql如何实现这个查询? 连字符+的问题
1 BACKGROUND sa . . NULL RESOURCE MONITOR 0 0 05/12 14:05:35 1 0
2 BACKGROUND sa . . NULL LAZY WRITER 93 0 05/12 14:05:35 2 0
3 SUSPENDED sa . . NULL LOG WRITER 4281 0 05/12 14:05:35 3 0
4 BACKGROUND sa . . NULL LOCK MONITOR 0 0 05/12 14:05:35 4 0
5 BACKGROUND sa . . master SIGNAL HANDLER 0 0 05/12 14:05:35 5 0
6 sleeping sa . . master TASK MANAGER 0 0 05/12 14:05:35 6 0
7 BACKGROUND sa . . master TRACE QUEUE TASK 46 0 05/12 14:05:35 7 0
8 sleeping sa . . NULL UNKNOWN TOKEN 0 0 05/12 14:05:35 8 0
9 BACKGROUND sa . . master BRKR TASK 0 0 05/12 14:05:35 9 0
10 BACKGROUND sa . . master TASK MANAGER 0 0 05/12 14:05:35 10 0
11 SUSPENDED sa . . master CHECKPOINT 2562 453 05/12 14:05:35 11 0
12 BACKGROUND sa . . master BRKR EVENT HNDLR 0 33 05/12 14:05:35 12 0
13 BACKGROUND sa . . master BRKR TASK 0 0 05/12 14:05:35 13 0
14 sleeping sa . . master TASK MANAGER 0 0 05/12 14:05:35 14 0
15 sleeping sa . . master TASK MANAGER 0 0 05/12 14:05:35 15 0
16 sleeping sa . . master TASK MANAGER 0 0 05/12 14:05:35 16 0
17 sleeping sa . . master TASK MANAGER 0 0 05/12 14:05:35 17 0
18 sleeping sa . . master TASK MANAGER 0 0 05/12 14:05:35 18 0
19 sleeping sa . . master TASK MANAGER 0 0 05/12 14:05:35 19 0
51 sleeping SH\Administrator SH . master AWAITING COMMAND 94 0 05/25 13:55:12 Microsoft SQL Server Management Studio 51 0
52 sleeping NT AUTHORITY\SYSTEM SH . msdb AWAITING COMMAND 0 51 05/27 03:00:00 SQLAgent - Job invocation engine 52 0
53 sleeping NT AUTHORITY\SYSTEM SH . msdb AWAITING COMMAND 94 26 05/12 14:05:37 SQLAgent - Generic Refresher 53 0
54 sleeping SH\Administrator SH . master AWAITING COMMAND 94 0 05/27 10:10:09 Microsoft SQL Server Management Studio 54 0
55 SUSPENDED SH\Administrator SH . master RESTORE DATABASE 78 42 05/27 10:09:57 Microsoft SQL Server Management Studio - Query 55 0
55 RUNNABLE SH . master RESTORE DATABASE 15 0 05/27 10:09:57 Microsoft SQL Server Management Studio - Query 55 0
55 SUSPENDED SH . master RESTORE DATABASE 78 0 05/27 10:09:57 Microsoft SQL Server Management Studio - Query 55 0
56 RUNNABLE SH\Administrator SH . master SELECT INTO 16 6 05/27 10:20:15 Microsoft SQL Server Management Studio - Query 56 0