Tag Info

New answers tagged


after installation Restart agent and server services Enable OLEDB Driver in SQL Server EXEC sp_configure 'show advanced options', 1; GO RECONFIGURE; GO EXEC sp_configure 'Ad Hoc Distributed Queries', 1; GO RECONFIGURE; GO


In my case i changed the host ip in /etc/hosts file but there was a hosts.swp file locking that change. So Listener was not coming up with the error "Linux Error: 111: Connection refused" used "vim -r /etc/hosts" to recover the change to the file, corrected it again clearly, then Listener came up


Please don't detach and attach your database. If you detach it and something happens to it, you now have zero copies of your database. Much safer approaches: Backup/Restore USE master; GO BACKUP DATABASE floob TO DISK = 'c:\wherever\floob.bak' WITH INIT, COPY_ONLY; ALTER DATABASE floob SET SINGLE_USER WITH ROLLBACK IMMEDIATE; RESTORE DATABASE floob ...


I will post it as an answer because it doesnt fit in the comment: What you need to do is detach the database, move log file to a new location, and atach again referencing the new location of the transaction log file. I will not post an answer because i never did this, but I know this is how it works. You can find a lot of information on google. And yes, you ...


If you are using innodb tables, try to raise innodb_buffer_pool_size as much as you can. You must balance the ram from mysql and other tools you use for development. The idea is to don't have a swapping machine and to use memory resource as best as possible.

Top 50 recent answers are included