SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Backup SQL Server Database with Move/Copy File


Backup SQL Server Database with Move/Copy File

Author
Message
Marvin D
Marvin D
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1086 Visits: 318
Comments posted to this topic are about the item Backup SQL Server Database with Move/Copy File

Marvin Dillard
Senior Consultant
Claraview Inc
Sreejithsql
Sreejithsql
SSC Eights!
SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)SSC Eights! (999 reputation)

Group: General Forum Members
Points: 999 Visits: 134
hi,
its soo helpful script for me. so simple to run. really appreaciatable.

thx
sreejith
MCAD
venkatesan53
venkatesan53
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 17
somebody pls explain step by step to me to use this query. because i have to set back on a network computer. i dont know how to use this. but it seems very help full

VENKAT
shri_sastry
shri_sastry
SSC-Enthusiastic
SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)

Group: General Forum Members
Points: 114 Visits: 169
Marvin,
Thank you So much for the script, this is so helpful. I have one question, if you can provide some suggestion. I have to backup all the databases but I do not have enough disk space on my local to do them all at a time is there a way to backup one database, move the .bak file and then backup the next one. My question is how can you make sure the move/copy was successful before you delete the bakup file on the local and backup the next one.


Thanks
Shri
Marvin D
Marvin D
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1086 Visits: 318
Shri
I sent you a new script. Let me know if that works for you
MD

Marvin Dillard
Senior Consultant
Claraview Inc
dolittle.d1
dolittle.d1
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 66
sreejith and all,

Please i really need your assistance asap on how to use this script if you don't mind.
I'll be really greatful if i can get some assistance on how exactly to use this sript.

He mention something about not forgetting to set the local drive path and network share for each backup in the backupretention table. (Is this after the script has been run for the first time or before it's run at all?

Also remember, to set the relocation action of copy or move. (Not sure how to do this too)??? Guys am new on the job please :-P help!!!:
lrosini
lrosini
Say Hey Kid
Say Hey Kid (670 reputation)Say Hey Kid (670 reputation)Say Hey Kid (670 reputation)Say Hey Kid (670 reputation)Say Hey Kid (670 reputation)Say Hey Kid (670 reputation)Say Hey Kid (670 reputation)Say Hey Kid (670 reputation)

Group: General Forum Members
Points: 670 Visits: 1657
Hi Marvin
Could you please also send me the script to backup one database at a time like Shri asked for or post it here. I would really appreciate it.

Thanks,
Lynn
Marvin D
Marvin D
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1086 Visits: 318
Sorry

Been busy and haven't been around on a regular basis, let me know if you still need it and I will dig it out.

Thanks

MD

Marvin Dillard
Senior Consultant
Claraview Inc
Disney Hammerschmidt
Disney Hammerschmidt
SSC-Enthusiastic
SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)SSC-Enthusiastic (126 reputation)

Group: General Forum Members
Points: 126 Visits: 185
Hi,

Great job, I was develop a symilar way, but encounter error whem copy to network drive.

I was set the permissions to everyone, change the user for SQL Agent, try to put this user in Administrator Group and nothing.

Always the job in sql command say:

move /Y \\backup\aaaa_20100927.bak \\192.168.10.1\BACKUPS\bbbb.bak
output
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Access is denied.

Any Ideas?
logicinside22
logicinside22
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2060 Visits: 1420
can you explain me how to run this SP .
I am trying to run but nothing is happeing even though saying execute successfully .

Aim to inspire rather than to teach.
SQL Server DBA
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search