January 2, 2014 at 1:53 pm
I need a little help with migrating DB files and log files to the client FTP server. I have never done this before so any help/ any instructions on "how to" from the SQL community is highly appreciated.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 2, 2014 at 2:56 pm
Probably the most efficient would be to take a backup to a file and put that backup file on the FTP server. The client will then pull it down and can then restore the database.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 2, 2014 at 4:13 pm
I'm with Jeffrey. You could use detach to unlink the databases from your server, then load them to the FTP server, then the other party can download and attach the database again. However, that's as far as I'm concerned, four risky operations with the original, and, possibly, only, copy of the database. It's just not as safe. Much safer to do a backup, leaving your original database in place, on-line, safe, copy that backup, and if it screws up, copy it again. Let the 3rd party download the backup. If it screws up, no worries, download again. Same thing with the final restore. You can just reset the whole operation instantly because you've never taken the database offline in any way. Safety. What a great thing.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 3, 2014 at 7:02 am
I second Jeffrey's suggestion, with the addition of compressing the backup after you've created it. The end user would probably appreciate this time and space saving extra step.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
January 3, 2014 at 7:07 am
Thank you guys for taking some time out and giving me some amazing tips.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 4, 2014 at 11:22 am
One option as suggested above is a backup, pretty clean and simple way. copy it over FTP and let your clients use it.
However, if they insist to have the database in the form of data and log files (for whatever reason), I suggest you not to detach the database. You can take it offline and then from the location where the data and log files are kept, you can copy them one by one and upload to FTP securely in a folder. When the database is in use, you cannot copy the files kept on disk so you either need to detach the database or take it offline till copying is done(I prefer taking it offline).
However, I would still suggest to go with backups:-)
Cheers!!
Chandan
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply