Post reply

moving SQL database............

  • October 1, 2009 at 9:39 am

    #210361

    I use SQL Server 2005 and right now it is on server1. Now since we are short on disc soace i need to move the database on server 2 that has SQL Server 2005 since we have lots n lots of space out there. SO can someone give me detailed step by step process how can i achieve this?

  • October 1, 2009 at 9:58 am

    #1060543

    you can use the following process:

    * backup/restore

    * deattach/attach

    Victor Alvarez
    http://sqlpost.blogspot.com

  • October 1, 2009 at 11:14 am

    #1060578

    espanolanthony (10/1/2009)

    I use SQL Server 2005 and right now it is on server1. Now since we are short on disc soace i need to move the database on server 2 that has SQL Server 2005 since we have lots n lots of space out there. SO can someone give me detailed step by step process how can i achieve this?

    Since you are asking for step-by-step instructions, here is a good start:

    http://support.microsoft.com/kb/314546

  • October 1, 2009 at 12:40 pm

    #1060634

    thanks a lot.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply