Viewing 15 posts - 901 through 915 (of 1,335 total)
SQL Server information will have information like when the sql server has started, recovery of databases, any user or system errors, backup of databases, restorations, dbcc commands, login informations and...
June 28, 2007 at 4:46 am
Search for Microsoft Best Practices Analyzer for SQL Server 2005 in microsoft website you can download a tool which will list out the vulnerabilities in the server.
June 28, 2007 at 4:26 am
Database snapshots are supported on all the editions of SQL 2005. Use that instead of copying the database to other server or so. I too knew that SQL 2005 2-node...
June 28, 2007 at 4:11 am
What books online says is true. Yu should not use /3GB switch with 16GB RAM. You should use /PAE switch in boot.ini file and specify max and min server memory...
June 28, 2007 at 3:39 am
If the restore is terminated abruptly in middle then database being resotred will go to loading state and you will need to restore the full backup copy again to bring...
June 28, 2007 at 3:34 am
I don't have the KB number suspected that kerebros may be the culprit because SQL be default tries to use kerebros to access network resources. And when you say that...
June 28, 2007 at 3:23 am
Might be the folder that you have used in the backup database might not be there. This error occurs if the path to back is given incorrect. If this is also...
June 28, 2007 at 3:19 am
osql -U username -P password -S ServerName -q"exec procedure name"
if you feel that passing user name and passsword is not providing the right security that you want u can use...
June 28, 2007 at 3:16 am
You do you copy the whole database. You have the option of database snapshots in SQL 2005 that can be a consisntent copy till the point the snapshot was created...
June 28, 2007 at 3:11 am
Is the drive that you use to take backups a networked drive. f so did you check if that was mapped to the server while the backup command was running....
June 28, 2007 at 3:10 am
do this test to see if port 25 is open
telnet servername 25
if it takes you to a blank DOS screen its open else not.
June 28, 2007 at 2:18 am
The patch for Kerebros would have caused the issue. With Windows 2003 and SQL 2005 microsoft says us to use Kerebros instead of NTLM. See BOL for more details.
June 28, 2007 at 2:14 am
Are you running with SQL Server 2005 Express Edition. I hope this issues is with that edition and few mant threads are already running in this forum for the same.
June 28, 2007 at 2:05 am
You are using SQL 2005 and its easy to use email functionality there with the new DBMAIL feature thats available with it. All you neeed to know is your smtp...
June 28, 2007 at 1:59 am
Don't try to kill any SPIDs that have a value less than 50 as they are system related processes. Since you say that you are stuck i suggest the following
1....
June 28, 2007 at 1:57 am
Viewing 15 posts - 901 through 915 (of 1,335 total)