Post reply

Backup Question

  • February 27, 2009 at 6:54 am

    #131414

    Hello All,

    I am using the following script to perform the backup,

    http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31932/

    Thanks Marvin for the great script. But I have one issue Marvin, I do not have enough space on my local drive to backup all databases and then move it to the network share, I have to backup one database, move it make sure move was successful, delete it on local and then backup the next database. These databases are in the 10-20Gb size range. My question is how do you confirm the copy/move was successful before deleting it on the local drive. This is SQL2000 server.

    Any help would be greatly appreciated

    Thanks

    Shri

  • February 27, 2009 at 9:24 am

    #951252

    shri_sastry (2/27/2009)

    This is SQL2000 server.

    Please post SQL 2000-related questions in the SQL 2000 forums. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 2, 2009 at 11:36 am

    #952011

    What you would need to do is serialize these. So backup, then script the move, then backup next one, etc. You'd need validation to be sure that the backup was copied correctly.

    These days, I'd just ask for more space. A 1TB USB drive, which would handle many backups, is a few hundred $$. You want backups on a separate drive from data as well.

  • March 2, 2009 at 3:48 pm

    #952162

    Steve,

    Thank you for your reply. I would ask for extra disk space too, but for now I have to make use of what is available. As per your suggestion, I have serialized the process, backup one database, check the backup, move the .bak file, check the moved file and then copy the next one. the backup is working but for some reason, when I do the copy(I am using xCopy) the job fails with the error "A network of the specified name cannot be found" I do not know how to resolve this error. This is happening in both SQL 2000 and SQL 2005. I am thinking this is a netowrking issue, but have not been successful in resolving it. Any suggestion to resolve the error is greatly appreciated.

    Thanks

    Shri

  • March 2, 2009 at 3:53 pm

    #952167

    What's your xcopy string? It should run from the command line fine.

    Also, how are you executing xcopy?

  • March 3, 2009 at 7:01 am

    #952396

    Here is my xcopy string

    @loc_file = @loc_folder_nm + '\' + @name + '_diff_' + CONVERT(NVARCHAR, GETDATE(), 112) + '.diff'

    @nw_folder_nm = '\\web-server9\backup\mssql\dbserver\' + @name +'\diffbkp'

    Set @copycmd = 'Move ' + '"'+ @loc_file + '"' + ' '+ '"' + @nw_folder_nm +'"'

    exec master..xp_cmdshell @copycmd

    the xcopy may not be the problem, I am thinking it is access issues.

    Thanks

    Shri

Viewing 6 posts - 1 through 6 (of 6 total)

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