Microsoft SQL
SQL SERVER 2008 INSTALLATION
Attached you will find print screens of a typical SQL Server 2008 Installation with all the features to run EZCash and/or JPEGger.
CREATE A NEW LOG FILE FROM A COMMAND LINE
If the log file is too large and you want to create a new log. Detach the database. Rename the old log file to something like jpegger_log1.ldf (or move it to another directory). Then from Management Studio, open a new query and enter the command: ...
MOVING THE TEMPDB DATABASE
Moving The Tempdb Database You can move tempdb files by using the ALTER DATABASE statement. Determine the logical file names for the tempdb database by using sp_helpfile as follows: use tempdb go sp_helpfile go The logical name for each file is ...
SQL SERVER 2008 SERVICE PACK INSTALLATION INSTRUCTIONS
Attached you will find print screens detailing how to install the latest Service Pack for SQL Server.
RECOMMENDED BACKUP STRATEGY FOR SQL SERVER
The purpose of creating SQL Server backups is to minimize the loss of data in a damaged database. In accordance with the Microsoft recommendations (MS191239 SQL.90), we recommend the following: All databases should be setup using the Full Recovery ...
SQL SERVER MAINTENANCE PLAN INSTRUCTIONS
Attached you will find print screens illustrating how to create maintenance plans in SQL Server 2005 AND SQL Server 2008.
SYMPTOMS: XLATE START UP ERROR.
Symptoms: Xlate start up error. Cause: Xlate needs to be run as Administrator. Resolution: Goto C:windowsSysWOW64 right click XlateApp choose properties, Compatibility tab and Check the Privilege Level check box “Run this program as an administrator”
SQL 2005 INSTALL FAILS WHEN MSXML6 SP 2 IS INSTALLED
This problem occurs when a later version of MSXML6 is installed than the one that is included in SQL 2005. The MSXML6 SP2 cannot be overwritten with the older version of MSXML6 that is in SQL 2005, and any attempts to uninstall MSXML6 will fail. This ...
CREATING ODBC DRIVERS ON A X64 SERVER ISN’T THE SAME AS PREVIOUSLY DOCUMENTED
To setup an ODBC driver on a x64 Server, you must setup the ODBC driver using the following program: c:\WINDOWS\syswow64\odbcad32 This is the same interface as before, just the program is in a different place.
INSTALLING MICROSOFT SQL SERVER 2008
Attached you will find SQL2008Install.bat and SQL2008Install.ini which contain the minimum options necessary for JPEGger and/or EZCash to run correctly. More options may be added at your discretion. Before installation, customization for the system’s ...
SQL Database (Recovery Pending)
To fix a database that is in Recovery Pending status, try executing this query: ALTER DATABASE MyDB SET ONLINE where MyDB is the name of the database