Friday, March 9, 2012

How to create a BAK of MSSQL database?

Hi,
WebAssist have asked us to provide them with a BAK of our MSSQL database.
Can anyone provide instruction on how to do that? We are using Enterprise
Manager and our database is hosted by our ISP on their server, which we have
access to.
Thanks
Nath.Hi
BACKUP DATABASE mydb TO DISK ='C:\mydb.bak'
"Nathon Jones" <sales@.NOSHPAMtradmusic.com> wrote in message
news:OMVgNucQGHA.5296@.TK2MSFTNGP09.phx.gbl...
> Hi,
> WebAssist have asked us to provide them with a BAK of our MSSQL database.
> Can anyone provide instruction on how to do that? We are using Enterprise
> Manager and our database is hosted by our ISP on their server, which we
> have access to.
> Thanks
> Nath.
>|||Hi Uri,
Thank you very much.
Regards
nath.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23BCJGDdQGHA.2300@.TK2MSFTNGP11.phx.gbl...
> Hi
> BACKUP DATABASE mydb TO DISK ='C:\mydb.bak'
>
>
> "Nathon Jones" <sales@.NOSHPAMtradmusic.com> wrote in message
> news:OMVgNucQGHA.5296@.TK2MSFTNGP09.phx.gbl...
>|||No file though?
SQL SERVER BACKUP
database name: ourdbname
name: our backup
description: <blank>
Backup - we have "database complete" selected
Destination - we have C:\ourdbase.bak
When we click "OK" it seems to run through everything successfully, except
there is no ourdbase.bak file on our C drive! Are we saving it to our ISP's
C drive considering that the MSSQL database is hosted there?
Hope you can help. Thanks again.
Regards
Nath.
"Nathon Jones" <sales@.NOSHPAMtradmusic.com> wrote in message
news:%23P5JDGdQGHA.516@.TK2MSFTNGP15.phx.gbl...
> Hi Uri,
> Thank you very much.
> Regards
> nath.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23BCJGDdQGHA.2300@.TK2MSFTNGP11.phx.gbl...
>|||Yes path are always relative to the server you are working on.
HTH, Jens Suessmeyer.|||Hi,
Is there any way to save the file locally? Our ISP (Fasthosts) don't seem
to understand what we are asking them and keep trying to force us to use DTS
to backup the database.
We've got Microsoft SQL Server 8.0 installed but, to be honest, we're just
using this to link to 2 databases hosted by our ISP.
How do we create a MSSQL database locally, so that we could import the data
in and THEN do the All Tasks > Database Backup?
Thanks
Nath.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1141728051.055622.165600@.z34g2000cwc.googlegroups.com...
> Yes path are always relative to the server you are working on.
> HTH, Jens Suessmeyer.
>|||> Is there any way to save the file locally?
That would require that the account that the SQL Server service is running u
nder at your ISP had
connection and permissions to a share on your machine. Not likely, and not s
omething you want. This
is how windows work. How about backup locally at your ISP and then FTP the f
ile? If your ISP don't
give you an option to backup and save the backup locally you should change I
SP immediately...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nathon Jones" <sales@.NOSHPAMtradmusic.com> wrote in message
news:%23U4%23kodQGHA.5808@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is there any way to save the file locally? Our ISP (Fasthosts) don't seem
to understand what we
> are asking them and keep trying to force us to use DTS to backup the datab
ase.
> We've got Microsoft SQL Server 8.0 installed but, to be honest, we're just
using this to link to 2
> databases hosted by our ISP.
> How do we create a MSSQL database locally, so that we could import the dat
a in and THEN do the All
> Tasks > Database Backup?
> Thanks
> Nath.
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1141728051.055622.165600@.z34g2000cwc.googlegroups.com...
>

No comments:

Post a Comment