| Author |
Topic |
|
arunsqladmin
Yak Posting Veteran
74 Posts |
 Posted - 2007-12-24 : 22:54:57
|
| i was working on a production server, and have stopped the sqlserver service along with the sql server agent. since i had to copy a MDF file . now i started the service again . but i find that there are no transactions happening ....what could be the reason. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-12-24 : 23:10:47
|
| What do you mean by "no transactions are happening"? Are you getting errors, are there connections to the server that are sending queries?BTW - you do not need to stop SQL Server in order to copy an MDF file. If you want to leave the database online you can just back it up and then restore it elsewhere. Otherwise you can detach it, copy it and then attach it again. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-24 : 23:39:49
|
| Check connections with sp_who2. |
|
|
|
arunsqladmin
Yak Posting Veteran
74 Posts |
Posted - 2007-12-24 : 23:52:28
|
| i am new to sqlserver so i found that while i execute sp_who2 there are certain status which are sleeping , few are runnable and few are background.... i dont understand anything... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-25 : 00:01:00
|
| If you see runnable connections with spid > 50, that means sql works ok. |
|
|
|
arunsqladmin
Yak Posting Veteran
74 Posts |
Posted - 2007-12-25 : 00:03:50
|
| what is spid what is the use of spid how can we check the whether sqlserver is working fine |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-25 : 00:08:10
|
| Spid is identity number of user connection, sql works fine while sql service is running and accepts user connections. |
|
|
|
arunsqladmin
Yak Posting Veteran
74 Posts |
Posted - 2007-12-25 : 00:41:02
|
| every day we take transaction backup of .trn files ,,,on to one server , now we find that the .trn files archiving is not happening since 3 days.. so what can be the issue... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-25 : 14:29:41
|
| Make sure sql agent is running, then check job history for error message. |
|
|
|
|
no transactions are happening