ApexSQL Knowledgebase: How to Execute large scripts generated by the Recovery Wizard

LINKS

General

Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Diff
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Script

Knowledgebase Home

SITE FEED

Site Feed

Support Forum

The fastest and most effective to get answers to your questions quickly. Click Here for more info.

FAQs

Quick answers to common questions. Click Here for more info.

Troubleshooting

Known issues and basic troubleshooting techniques for problems or unexpected behaviors. Click Here for more info.

Knowledgebase

Technical tips, How-to articles, and other tutorials about ApexSQL Tools. Click Here for more info.

Online Documentation

All of our help files for download or convenient viewing online. Click Here for more info.

Videos

Watch product demos, training videos, or tutorials of our products' main features. We frequently upload new videos so check often for updates. Click Here for more info.

ApexSQL Knowledgebase

Tips and How-to Articles for Apex SQL Tools

How to Execute large scripts generated by the Recovery Wizard

DESCRIPTION
In case of recovery of huge databases Recovery Wizard can generate very large result scripts. Such scripts are saved by ApexSQL Log to the flat files at a given place. These files cannot be opened and executed using SQL Server utilities such as SQL Server Management Studio, for example.

SOLUTION
The only way to execute such large scripts is to run osql (or sqlcmd) command line utility that comes with SQL Server. Here are short examples of usage:

a. osql -H <host> -S <server> -U <user> -P <password> -i <path>
b. sqlcmd -S <computername\instancename> -i <path> -o <output>

LAST REVIEW DATE
30 August 2007

Labels: ApexSQL Log

posted by Janice Lee on Thursday, August 09, 2007

0 Comments: