How to Restore Huge Script File in SQL Server 2008

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Dear Team,
i have file .sql and they content upto 150 mb file size when i execute in SQL Server then get file size heavy and execute error.

Have any other way restore .sql file in database like .bak file .

Regards
Rohit Kumar Singh
9810353598

Posted 18-Feb-13 18:53pm

rohit_singhk

Add a Solution

Comments

ssd_coolguy 19-Feb-13 4:44am

can you tell us.. what exactly that sql file contain..?
is there any query?

rohit_singhk 19-Feb-13 5:31am

DataBase Script with Data Contain

rohit_singhk 19-Feb-13 5:47am

Dear File extension is .sql not .bak file got it?
File Path like :
E:\New folder\DCE_Script_With_Data.sql

Again i told not like .bak if it is .bak file i easily restore?

And .SQL extension direct open in new query window if file size not more than 150 MB.

rohit_singhk 19-Feb-13 6:38am

CALL sqlcmd -w 125 -S %ROHIT-PC% -d %DCORE_19022013% -U%sa% -P%boss% -l30 -b -I -i "E:\Dcore_GGN_Even_20April2012_1013hrs.sql"

Like that

rohit_singhk 19-Feb-13 6:40am

Server Name : ROHIT-PC
DataBase : DCORE_19022013
User ID : Sa
Password : boss
File Sources Path : E:\Dcore_GGN_Even_20April2012_1013hrs.sql

Now what is query direct exceutable

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Davidduraisamy · Answer 1 · 2013-02-18T23:39:00

Solution 1

hi,

Try this code....
DECLARE @SqlString VARCHAR(1000)
SELECT @SqlString = 'BACKUP DATABASE eUnderwrite TO DISK = ''path'+ REPLACE(CONVERT(VARCHAR(15),GETDATE(),106),' ','_')++'_'+REPLACE(CONVERT(VARCHAR(25),GETDATE(),108),':','_')+'.bak'' WITH INIT'
PRINT @SqlString
EXEC (@SqlString)

Posted 18-Feb-13 23:39pm

Davidduraisamy

S. M. Ahasan Habib · Answer 2 · 2013-02-19T00:27:00

Solution 2

You can try SqlCmd utility. Code like

CALL sqlcmd -w 125 -S %Server% -d %Database% -U%uid% -P%pwd% -l30 -b -I -i  "dbscript.sql"

In details you can check SqlCmd Utility

Posted 19-Feb-13 0:27am

S. M. Ahasan Habib