First off I am not a SQL guy so I really need some assistance. We are running a SBS2003 server with SQL 2005 Premium. One of the databases is around 600MB and the transaction log is 125GB!! I attempted to backup the database but this did not clear the transaction log. I also tried backing up the transaction log but I did not have enough free space to back it up. I'm not sure if backing up the transaction would truncate it anyhow. Can anyone tell me how to get this back down to a normal size and how to prevent this from happening moving forward?
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.