jeudi 4 décembre 2014

How to import DB with .sql extension into SQL Server 2012?


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.





Aucun commentaire:

Enregistrer un commentaire