One of the lesser used features of SQL Server 2000, but the capability to restore your databases to a particular point in time can be a valuable skill. Kathi Kellenberger takes a moment to explain how this feature works and how you can use it in your environment.
2005-06-14
17,248 reads
Yes ron k and again this will scan only 1 month at the time. Unless this is exactly what you (kristin) want it to do then I would urge you to try to understand my query as it is immensly more flexible and optimized that your stored proc.
2005-05-25
2005-05-18
Yes, Siva, I've allready checked these IP addresses. It doesn't work. Neither physical nor virtual. On sql server log it's said that one node listen to xx.xx.xx.x1 :1433 , other node- xx.xx.xx.x2:1424These ports have been assigned dynamically. When I try to connect from cluster node to outside SQL server by its IP address all works […]
2005-05-06
Ah - I do have an index on it. It's a name though - not very like to chnage much.
2005-05-06
Reading the BOL has its advantages. Apparently this needs a "Report Model", looks something like a BO universe. I got it working for adventure works.Joachim.
2005-05-03
Allen,Thank You for the swift reply.As I said I am new to this forum, what do you mean by BOL.Also instead of doing the detach and attach using stored procedures, can I do them using the Enterprise Manager?? If so what is the proper sequence of events to move the Logfile?Thanks,
2005-04-29
In this case, you have to wait until it completes, Cancelling the process colud trigger the rollback which may take even longer time.I wouldn't run dbcc check with repair option, instead, Run dbcc checkdb to find out whether database has integrity issues, If it does, the dbcc checkdb will tell you which objects are in trouble […]
2005-04-27
Do this! I certainly have learned a lot from it. And I for myself, enjoy Joe's style of writing.
2005-04-20
I think I am sorted with this now anyway.Advice is - Keep transaction very short - Return server to default isolation level READ COMMITTED when on and on error found. - Consider using HOLDLOCK
2005-04-07
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers