locked
Import local database to remote RRS feed

  • Question

  • Hi,

         I have a bak file backup of my database which is a database backup done via SSMS 2008.I have imported this bak file to SSMS 2014 and working currently. The bak file is about 4 gb size.I need to transfer the entire database to remote server which is also sql server 2014. How can i do this efficiently?

    Thanks

    Thursday, October 22, 2015 11:15 AM

Answers

  • Hello,

    Create a compressed backup file, transfer it to the server and restore it.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, October 22, 2015 12:01 PM

All replies

  • Hello,

    Create a compressed backup file, transfer it to the server and restore it.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, October 22, 2015 12:01 PM
  • Yeah thanks, is there anyway to upload from local machine itself?
    • Edited by Youv Thursday, October 22, 2015 12:29 PM
    Thursday, October 22, 2015 12:28 PM
  • Not clear what you mean exactly here?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, October 22, 2015 2:44 PM