Search results for query: *

SuperSocket info: (SpnRegister) : Error 8344. any idea what this means?

Bear with me- I am not experienced in SQL server backup issues at all. The database backup is now at 26.6 GIGs and the disk it is on is a 50 gig disk. I suspect that it is dangerous and not at all what we want to do to delete the backup from the day before BEFORE we backup again, but of course...

How do I get the fieldnames to appear in my csv file when exporting results to excel?

I have two sql 2k servers. Server A is the distributor and replicates to Server B via a pull subscription on B. Server A is heavy on writes and Server B is used for Reporting so it is basically only doing Reads. My question is this: If I configure Server B to have a certain page percentage full...

I have enough disk space to hold two backups at a time of one of my sql2k databases. The maintenance plan is set to delete the oldest backup, which it did just fine, until recently. The only thing I can think of that would make this fail now is that the remaining disk space is not enough for...

Hi, I am wondering if anyone is using IWatch and or Spotlight for SQL server. If so, What are your feelings about it? I am having a meeting with them next week and want some feedback from people who are actually using it. Thanks!

Hello. Is there any reason why backups and other sql server tasks (that do not connect to other network machines) should not run under 'sa'? I inherited a legacy box set up by someone else and noticed it did not back up the other day. The reason was that it was running under a domain username...

What are idq and htx files associated with?

I am interested in finding out what the standards (if any) are in companies in terms of their password changing policies, as well as what type of authentication your apps connecting to sql server use, what kinds of authentication the services run under, etc. My company is in the process of...

I am looking for any information I can find on IIS backup and recovery. I am told that you can only restore IIS5 to the same server. What happens if your server catches on fire? Any help would be appreciated.

I have created a replacement machine to take over for our old replicated server that we use for reporting. I have the new server replicating and am ready to begin switching the apps over to use the new server for reporting. I need to add the users from the old machine to the new machine. What...

I have been asked to monitor our SQL servers using performance monitor (sql2k, win2k) and then to provide a weekly report summarizing the information, and also showing a breakdown of the details. The only way I can find to get information out of performance monitor is to save it as a webpage or...

Hello. Could someone please explain to me the difference between running dbcc dbreindex and having a maintenance plan "reorganize data and index pages" under the optimizations tab in the maintenance plan wizard in sql2k? I notice that under the maintenance plan, it has an option to...

We recently bought a newer, better server for our report server which gets data via transactional replication from our production SQL2K database. In setting up the new server, we are having problems with the initial snapshot. We are running it without locking the tables. It keeps timing out with...

Folks, I am having problems finding documentation on steps necessary to move my sql2k db from the current production server, to a new and more robust server that we have purchased. Everything on the new server, including the server name, needs to be identical. We would like to leave the current...