If you're using the same shared storage unit, having a seperate partition for the TRANSACTION logs isn't going to make a massive difference performance wise because it's still using the same IO. However, saying that, it is probably still a reasonable plan to do this to :a) Keep things tidyb) Prevent Fragmentation (which WILL affect […]
2004-10-14
Sorry Steve I had a hard day yesterday, You must be one of the lucky ones.More than once I have had problems with databases that are in full recovery that the log files do not whant to shrink no matter what you try until you 'reset' their recovery. This has remained an enigma but the sollution that […]
2004-10-14
As stated above the correct answer is syntax error for the reasons already stated
2004-10-14
Basically, your requirement is for Replication, so you should look at SQLServer's Replication features in detail. Sometimes log shipping (that is, copying transaction log backups) is used to achieve similar results. This article explains the difference: qa.sqlservercentral.com/columnists/pibison/logshippingvsreplication.asp Other points to consider: - You are creating databases that shadow the branch databases, so you can replicate […]
2004-10-12
I too face the same problem. In both servers sp3 is applied. and both windows versions are same. This problem occurs when I use the pull subscription(no idea abt push). A snapshot is created. and when I apply the pull subscription(with start merge agent imedeiately). "The process could not enumerate changes at the 'Subscriber'. The […]
2004-08-10
We are required to access the database through stored procedures. So the client couldn't just select against a view in our situation. Thanks for the idea though
2004-03-04
By Steve Jones
I was trying to update my dbatools install to test something and go this...
By James Serra
I see a lot of confusion on how classifications and sensitivity labels work in...
By Chris Yates
As someone attending the event since 2011, I would like to share my personal...
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