Tag Info

New answers tagged

1

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


0

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


5

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 ...


3

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 ...


1

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