We currently have a SQL 2000 volume that has it's database files on one drive and the log files on another.
I wanted to move the log files to another drive that what is on now. When I try to review the properties and change locations it does not let me modify. When I add a new location (as a secondary) and detach and re-attach it does not link to the newly reference drive.
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb. Luckily, there is a free version SQL Express, but does …
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.