Execute the following stored procedure
'sp_who2 active' into Query Analyser
It will return the information with status, login, cpu time, DB Name, Command etc.
Friday, November 20, 2009
Wednesday, October 07, 2009
HTTP/1.1 400 Bad Request errors
One possibility of the cause is because of the specific IP address. Could you change it to "All Unassigned" and test it again.
This is one of the option to resolve the error.
This is one of the option to resolve the error.
Wednesday, September 16, 2009
Folder backup/restore
NTBackup is the backup utility that comes with Windows utility.
Start -> Run -> NTBackup
You can backup your server's system state and any folders/files that you choose.
If you choose full backup, the "archive" bit on each file backed up gets reset. When a file is updated, the archive bit is "set".
This allows each subsequent incremental backup to know which files have been changed, and only those files will be backed up, you end up with everything backed up to a .bak file. You could then store this .bak file somewhere safe.
To restore the files, you can use the same NTBackup utility.
Start -> Run -> NTBackup
You can backup your server's system state and any folders/files that you choose.
If you choose full backup, the "archive" bit on each file backed up gets reset. When a file is updated, the archive bit is "set".
This allows each subsequent incremental backup to know which files have been changed, and only those files will be backed up, you end up with everything backed up to a .bak file. You could then store this .bak file somewhere safe.
To restore the files, you can use the same NTBackup utility.
Subscribe to:
Posts (Atom)