Hi Sql-Lover,

Thanks for your answer. Do you mean after restoring my database from SQL 2008 on SQL 2012, I should change compatibility level on server 2012 to "120" ?

Many...

Thanks for the link

Thanks for your answer. I decided to install same sql server ( 2008 r2 ) on my new server with MS 2012 OS.

Do we need any order to restore our...

I found when I run this sqcmd commend in my command prompt it workscorrectly , but when I run it from batch file it does not work. Can some body...

This command works on server when I run it from my pc:

psexec \\servername -E cmd.EXE /c "sqlcmd -S s01-techsql1 -E -d dbname -i c:\myfolder\myscript.sql -o c:\mypath\output.txt"

Now I changed the command...

Tahnks Steve, I installed Psexec on my emore server and my pc, and I changed my command in my batch file like this:

psexec \\servername -E cmd.EXE /c "sqlcmd -S s01-techsql1...

Thanks for your solution, but the error is about my input file , and I think after that it wil go to write the result to output file.

Also, I put...

Hi Lynn,

Thanks for your answer.I will explain a little more about my problem in the Myscript.sql query:

I am using sqlcmd in command line:

sqlcmd -U username -d dbname -i c:\mypath\myscript.sql -o...

My plan for backup is daily full backup, and transactional log backup for every 5 minutes because we do not have much transactions.My data base recovery model is "Full",...

Thanks for your prompt answer:-)

Hi,

Thanks for your answer. I did this solution on my test server and it worked, but I am worry! Can I do that on my production server during the users...