Welcome,
Guest
. Please
login
or
register
.
Home
Articles
Help
Calendar
Login
Register
February 28, 2021, 12:14:06 pm
News
: IF YOU ARE A MEMBER FROM THE ORIGINAL SITE AND CAN'T LOGIN. POST IN THE FEEDBACK FORUM (AS GUEST) AND AN ADMIN WILL ASSIST YOU TO ACCESS THE SITE!
Galahtech
|
Development
|
Databases
| Topic:
[RESOLVED] Restore MS SQL database without using .bak file
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: [RESOLVED] Restore MS SQL database without using .bak file (Read 5558 times)
Slowhand
Supporters
Stars: +0/-0
Offline
Gender:
Awards:
Posts: 4668
I code C#!
[RESOLVED] Restore MS SQL database without using .bak file
«
on:
December 01, 2008, 10:18:25 am »
Hello people,
A customer of us has purchased hosting where we can install software for them.
What we didnt' know is, we don't have rights to restore .bak files.
The hosting provider does it once, after that we have to pay.
Since this is a product in development, it's possible we'll need to update the database a couple of times.
So I'm looking for a way to do this without restoring a new .bak file.
I wondered if there's a way to make a backup like MySQL does it, with a huge sql dump.
«
Last Edit: December 02, 2008, 08:19:34 am by Slowhand
»
Logged
Jason Reed
Administrator
Stars: +4/-0
Offline
Gender:
Posts: 4554
Pure Evil Administrator
Re: Restore MS SQL database without using .bak file
«
Reply #1 on:
December 01, 2008, 12:57:25 pm »
Which version of SQL Server are you using?
Logged
-- signature --
Slowhand
Supporters
Stars: +0/-0
Offline
Gender:
Awards:
Posts: 4668
I code C#!
Re: Restore MS SQL database without using .bak file
«
Reply #2 on:
December 01, 2008, 01:23:50 pm »
2005
Logged
Jason Reed
Administrator
Stars: +4/-0
Offline
Gender:
Posts: 4554
Pure Evil Administrator
Re: Restore MS SQL database without using .bak file
«
Reply #3 on:
December 01, 2008, 01:27:47 pm »
Ok I checked my "Express" version of it and I see no way to dump to SQL like MySQL. You can dump the structure to SQL but not the data inside which I figure is what you are wanting.
I'm guessing that to do this you would have to have an external app that reads the data from the database and creates an SQL script (with maybe a TRUNCATE call for each table). Then you could just run the standard SQL script without using a BAK file.
From what it looks to me is that MS thinks that the BAK file thing everyone would want to use and therefore doesn't provide any functionality to dump to SQL.
Logged
-- signature --
simmo
Administrator
Stars: +3/-0
Offline
Gender:
Posts: 8569
Re: Restore MS SQL database without using .bak file
«
Reply #4 on:
December 01, 2008, 07:25:52 pm »
are you restoring to a certain state? or needing as backups to prevent data corruption/loss?
If restoring to a state you can write the scripts, use the SQL to build the structure then have scripts to populate needed data. If using as a backup solution you could have scripts that pump records to another table and move them back as needed, but that might be fairly resource intensive.
Logged
.....
.....
Slowhand
Supporters
Stars: +0/-0
Offline
Gender:
Awards:
Posts: 4668
I code C#!
Re: Restore MS SQL database without using .bak file
«
Reply #5 on:
December 02, 2008, 08:19:16 am »
I've found a Microsoft application, called
Microsoft SQL Server Database Publishing Wizard
, that can export both schema and data to an sql file, just like MySQL.
Logged
Pages: [
1
]
Go Up
Print
Galahtech
|
Development
|
Databases
| Topic:
[RESOLVED] Restore MS SQL database without using .bak file
« previous
next »
Jump to:
Please select a destination:
-----------------------------
Forum Talk
-----------------------------
=> The I'm a Bot Board
=> News, Current Events, Announcements
===> News and Current Events
=> Say Hello to the members
=> Feedback
=> Coffee Break Time
=> Member Spotlight
=> Mango Jacks
-----------------------------
Computing
-----------------------------
=> Computer Hardware
=> Computer Software
=> Computer Networking
-----------------------------
Development
-----------------------------
=> Desktop Application Development
=> Web Development
=> Databases
=> Computer Graphics
=> Obscurus
-----------------------------
Library
-----------------------------
=> Hosted Projects
===> Hosted Project Archive
===> Tutorial Discussion
=> Examples
===> Visual Basic Examples
===> Visual Basic .NET examples
===> Binary Challenge submisions
=> Oldsite Archive
Loading...