Viewing 15 posts - 301 through 315 (of 457 total)
why is the master db not compability mode 90 anyhow?
June 21, 2008 at 6:43 am
There should not be a problem restoring between 64 bit adn 32 bit instances of SQL Server. Do you have any further details on the errors?
June 20, 2008 at 8:07 am
You have to weigh up the benfits the upgrade brings to the business against the risks assoicated with going with a new product...so the answer as usual, is "it depends"
It...
June 20, 2008 at 5:14 am
Certainly some of what you do would indicate that you are a DBA, also some of what you do would suggest your a hardware technican, Others things suggest that you...
June 20, 2008 at 2:57 am
I think it might have something to do with the thresholds you set when configuring log shipping, from what you have said it seems to be set to 45minutes whereas...
June 20, 2008 at 2:26 am
the problem is with the physical file names, they are being restored to the same location as the orginal db files which is causing the conflict. change the physical file...
June 19, 2008 at 11:17 am
You can perform transaction log backups when the database is in full or bulk-logged recovery modes... but not in simple mode.
June 19, 2008 at 9:01 am
Hi you seen this topic too...it doesn't give exact details but it did make me think that what you want to do is achievable.
Initializing a Transactional Subscription Without a Snapshot
June 19, 2008 at 7:33 am
Are you logged onto the server - the servername will be the computer name found under control panel > system.
Once you have the name you can ping the name...
June 19, 2008 at 6:41 am
I think you can do it either way...lookup Strategies for Backing Up and Restoring Snapshot and Transactional Replication in BOL which covers what you are trying to do.
June 19, 2008 at 6:37 am
hi this proably doesn't help you but i would think very carefully before allowing users to restore the database themselves, this has the potential to alot of trouble... if you...
June 19, 2008 at 6:35 am
If you lookup sp_change_users_login in books online, in particular the Auto_fix option, which should allow you to create logins for the orphaned users in your restored user databases, This...
June 19, 2008 at 6:28 am
You can't just change the Execution plan to use something ele you have to hcnage something like your code, create a new index for the query or similar...
this article will...
June 19, 2008 at 6:13 am
enabling C2 auditing may help you with this but i would research doing this properly before implementing it can lead to numerous problems, poor performance being one, as well as...
June 19, 2008 at 4:38 am
sorry just relaised i'd miss read the question. :blush:
June 18, 2008 at 3:01 pm
Viewing 15 posts - 301 through 315 (of 457 total)