Post reply

Can anyone let me know best way to do this backup and restore task?

  • July 24, 2012 at 12:01 pm

    #264674

    Backup AW2012 production database on AWPServer,

    copy to AWTServer test database server,

    And restore as AW2012

    How to move the backup copy from AWPServer to AWTServer?

    Can we use the shared drives on network?

    Can anyone provide me the script with copyonly option with out affecting the other process on db

    thanks

  • July 24, 2012 at 1:56 pm

    #1517061

    nagkarjun1 (7/24/2012)

    Backup AW2012 production database on AWPServer

    Lookup BACKUP DATABASE in books online and then execute a BACKUP command

    nagkarjun1 (7/24/2012)

    copy to AWTServer test database server

    Copy / Paste .bak file

    nagkarjun1 (7/24/2012)

    And restore as AW2012

    Lookup RESTORE DATABASE in books online and then execute a RESTORE command (likely using WITH MOVE options)

    nagkarjun1 (7/24/2012)

    Can anyone provide me the script with copyonly option with out affecting the other process on db

    This is a forum for help, not for people to do your job for you.



    A.J.
    DBA with an attitude

  • July 24, 2012 at 2:05 pm

    #1517066

    A.J. Wilbur (7/24/2012)

    nagkarjun1 (7/24/2012)

    Can anyone provide me the script with copyonly option with out affecting the other process on db

    This is a forum for help, not for people to do your job for you.

    Maybe asking for the script was a little bit too much, but I believe some polite orientation would be sufficient.

    nagkarjun1 (7/24/2012)

    How to move the backup copy from AWPServer to AWTServer?

    Can we use the shared drives on network?

    Yes, you can use network drives to save the backup or you can copy the backup as A.J. suggested.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • July 25, 2012 at 1:04 pm

    #1517589

    The following URL provides good information (including the script \command) for database backup copy_only option:

    http://www.mssqltips.com/sqlservertip/1075/copyonly-backups-with-sql-server-2005/

    Hope this helps.

  • July 25, 2012 at 1:11 pm

    #1517592

    Vikrant S Patil (7/25/2012)

    The following URL provides good information (including the script \command) for database backup copy_only option:

    http://www.mssqltips.com/sqlservertip/1075/copyonly-backups-with-sql-server-2005/

    Hope this helps.

    http://www.mssqltips.com/sqlservertip/1075/copyonly-backups-with-sql-server-2005/

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

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