Monday, 15 October 2012
If you are dealing with a large scripted databases and having difficulty restoring it with SSMS, follow the instructions below.

Open the Sql Command Prompt and execute the following: Replace the braces with your settings.

sqlcmd -S {SQL-INSTANCE-NAME} -i {PATH-TO-SCRIPT} -o {LOG-FILE} -U {LOGIN-USERNAME} -P "{LOGIN-PASSWORD}" -d {RESTORE-DATABASE-NAME}

Safety tip:
 Ensure each query is followed by an SQL "GO" for optimal performance and to reduce the chance of out of memory errors.



posted on Monday, 15 October 2012 11:04:19 (South Africa Standard Time, UTC+02:00)  #    Comments [1] Trackback
Related posts:
SQLSERVER Clear and Reseed all Table Indexes
Change Sql Server 2008 default backup location
Monday, 12 October 2015 19:23:03 (South Africa Standard Time, UTC+02:00)
Going to put this arcltie to good use now.
All comments require the approval of the site owner before being displayed.
Name
E-mail
Home page

Comment (HTML not allowed)  

Enter the code shown (prevents robots):