Attached you will find print screens illustrating how to create maintenance plans in SQL Server 2005 AND SQL Server 2008.

Detailed instructions with screen shots are in the attached article. BatchMove is for JPEGger MYSQL to SQLServer Migration. For EXcash MYSQL to SQLServer migration, use Mygrator instead – see reference article. The BatchMove installation program is also attached.

To begin, select the database type. Next, you’ll need to type in the ODBC alias for the source and destination databases. Once those are typed, click “Open” for each one. When opened successfully, you will see a message in the “Messages” area, and the “Go” button will be enabled. ...

Thank You For Using GoToAssist Please follow these steps that will need to be repeated at each one of the problematic machines: Open up a Web browser and go to Go To Assist Wizard Click the GoToAssist Connection Wizard Link and save the file to your desktop. Close all browsers then click on...

Installing Microsoft SQL Server 2005 And All JPEGger Versions These instructions are for installations where SQL Server and JPEGger will reside on the same server AND the software installation media will be downloaded. Installing Microsoft SQL Server Create the following folders:C:\Transact,...

Attached you will find print screens of a typical SQL Server 2008 Installation with all the features to run EZCash and/or JPEGger.

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: create database [jpegger] on (FILENAME =...

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 contained in the name column. This example...

Attached you will find print screens detailing how to install the latest Service Pack 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 model (Please see Full Recovery Model). A...