I have a database with
.sql extension which is exported from server using putty.
How to import this into SQL Server 2012 in Management Studio?
It is not accepting
.sql as database, throwing error.
If I try to restore using
RESTORE HEADERONLY FROM DISK = N'D:\LogFile\accesslog.sql';
I am getting the following error:
Msg 262, Level 14, State 1, Line 1
CREATE DATABASE permission denied in database 'master'.
Msg 3013, Level 16, State 1, Line 1
RESTORE HEADERONLY is terminating abnormally.
Please help me with this.