Search results for query: *

I have a Publisher database which is also a Distributor. I want to initiate a mirroring session with this box as the Principle and with the mirror on a separate box. In the case of a failure of the Publisher/Distributor box, the mirror will take over of new Principle of the mirroring session...

beautiful thanks

I am getting technically distinct records since one of the fields is different, but I don't want all of them, just the one with the largest number in it. Here is an example of what my current sql statement is returning: field1, field2, field3 apple, fruit, 50 apple, fruit, 43 apple, fruit, 32...

Thanks, I'll check out whether it is set to manual or not, I can't believe I was so stupid to expect it would be auto on boot. SQLDenis, I have bookmarked your site as well as this one.

very funny. We have UPCs for all the servers. The problem is when the power outage is too long for the UPCs to handle (small company, no budget). So is the real answer that SQL Server Agent will not restart even though it is set to start on boot and restart of stopped? Doesn't this setting...

Sorry, all I know is for Portal Server running SQL Server as the backend database. If I get time, I will look into your configuration. Ed

I have set SQL Server Agent to restart automatically if it stops unexpectedly. Unfortunately we have brief power outages, sometimes quite frequently. I take a look at the server after it is restarted and SQL Server Agent is stopped. I have some fairly critical jobs that need to run on a...

Sorry, this is if you are using Sharepoint Portal Server and SQL Server as the database. Make sure both machines are the same versions and patched to the same level on both machines. Make the database backup on one. Move the backup file to the new machine. Then on the new machine use Sharepoint...

Thanks, called Microsoft. Just install Sharepoint Portal Server on the new machine, do a SQL database backup on the old machine, then do a SQL database restore from that backup onto the new machine. BAM! Everything is on the new machine.

hmckillop thank you! That is exactly what the doctor ordered! doing it in batches was in the back of my head, I should have included it in my question. Thanks everyone for your posts, I know alot more than I did when I first posted my question. Great forum, I will definitely be haning out here...

boy, maybe I should take a class or something I have had to learn everything as I go thanks, SQLDenis There are a lot of records in that table

Thank you very much for the replies. That particular table has 40 fields, two primary keys and one index (I think). 7500 updates took over an hour to complete (just finished now). Anyway to see at a glance how many indexes in the database?

I keep running into the problem of my sql server database not being able to delete large numbers of records. It just sits and spins so to speak, and I have to eventually just stop it. It is pretty good hardware, dual xeon, 2 gigs ram, etc. How can I do large deletes and updates in SQL Server...

Thanks, Thomas, I will try some of your suggestions and let you know. And yeah, pictures are pretty standard fare in message boards these days. Maybe we should start our own? ;)

This is what I am doing. I add a web part via the interface: edit page> modify shared page> add web part> browse I am in a subarea called engineering lets say. I add a document library using this technique. I then edit the settings of this document library and choose select a portal area. The...

I have a document library under Home and want it to also show up in another area. I change the settings>location to include not only home but the other area, click ok, and it stays only available in home. Same for a message board, will not show up in another area. After I save these changes, it...