Backing up Backup locally

[MadMikeMorrison]

I am trying to backup my Vortech databases locally using MS Sql Server Management Studio. I have been able to create a new local DB and then Export from my Vortech DB but it does not include stored procedures, etc. I really want to make a full SQL backup locally but I don't have the permissions. I want to put it on a schedule so it'll run every few days or whatever so I have a local backup should things get ugly.

I opened a ticket asking how and they suggested that DTS would work. I know nothing about DTS. Has anyone done this and can you please help me out.

Thanks,

-Mike

[Brangwyn]

Unfortunately you can't make manual backups from the server using the Backup function ... even if you could there's no way to get at the resulting backup file anyway.

DTS is fairly self explanatory, if you have Enterprise Manager running then just right click on your database and select Export (Objects and Data to get everything), walk through the wizard and it should help you to get the data you need. You'll need your own instance of SQL Server running locally to back it up too.

[soky]

Just be careful with keys and indexes. I've had a heck of a time with it. You would do well to create local users with the same name and permissions as your Vortech account/s. It makes recovery a lot easier.

[MadMikeMorrison]

Okay, thanks for the help.

-Mike

[Brangwyn]

Originally Posted by soky

Just be careful with keys and indexes. I've had a heck of a time with it. You would do well to create local users with the same name and permissions as your Vortech account/s. It makes recovery a lot easier.

I'll second that, it is much easier if you do this first.

[kattouf]

Hi,

I am trying to to backup an sql db, and i am using SQl Studio to find the db and when i right click i have the options to Export or Copy. I tried the Copy wizard and selected and source and destination. But when it comes time to choose the database it give me an error that the user name is not valid for this database. The db it mentions in one begining with "a" and not the db i want to copy. Not sure how to get round that.

While the Export db task gives a dll error.

brangwyn can you make a backup for me?

[Brangwyn]

Export is what you want to use, what is the dll error you're getting ?

[kattouf]

Its an error that many people using my version of sql are getting something about dtspipeline.dll not being registered which is it.
Anyway i give up, can you do it for me? I gave them an sql script but they want the backup files :-(

[Brangwyn]

PM me the details of the database etc and I'll see what I can do for you, if you give me an FTP account to chuck it on I should be able to do it today for you sometime. Is your local SQL Server that's giving the error fully service pack patched ??

[kattouf]

Never mind, i paid vortech to do it :-)

Well i tried to patch it and it didn't work, said it needed another update first anyway i think it was a beta or community release or something. I am installing 2000 evaluation now

anyway thanks for your help.

[levseltzer]

I have recently started to use the "SQL Server Database Publishing Wizard" for my MSSQL backups. This program creates a single SQL script file containing your entire database (structures and data). It might not be elegant, but it does seem to work. You can get more information here:
Website: http://www.codeplex.com/sqlhost

[hohios]

Vorech, have to provide us a way to backup mssql databases (with indexes etc) with ease.