Autonumber field: website

Showing posts with label website. Show all posts

Tuesday, March 27, 2012

Backing up remote SQL Server

I have written a SQL DB, and ASP.NET website for a client. The clients
database and webpage are not inhouse but on a hosting provider.
This provider says they only backup for disastor purposes--which didn't make
me feel to good.
So my question...
How can I help this non-techie client to backup her remote SQL Server
Database regularly?
What is the best means of doing this?
Some software for her--again figure very low tech small business--no IT
department'
Some other service to do it?
Thanks,
ShaneWrite one or a few ASPI.NET pages from which the user does backups. From
here you can use .ExecuteNonQuery and execute the appropriate BACKUP
DATABASE command. Note that the backup file will be created from the SQL
Server machine's perspective.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"SStory" <TheStorys@.TAKEOUTTHISSPAMBUSTERsofthome.net> wrote in message
news:%233WRgI5BEHA.3748@.tk2msftngp13.phx.gbl...
> I have written a SQL DB, and ASP.NET website for a client. The clients
> database and webpage are not inhouse but on a hosting provider.
> This provider says they only backup for disastor purposes--which didn't
make
> me feel to good.
> So my question...
> How can I help this non-techie client to backup her remote SQL Server
> Database regularly?
> What is the best means of doing this?
> Some software for her--again figure very low tech small business--no IT
> department'
> Some other service to do it?
> Thanks,
> Shane
>|||ok...
But where does that file reside?
If still no hosting site that isn't much of a backup.
Are you saying try to backup to a local protected directory, download the
backup file and in case of disaster client sends that backup file to people
on host site to restore?
Thanks,
Shane
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23Jy4hi5BEHA.3928@.TK2MSFTNGP11.phx.gbl...
> Write one or a few ASPI.NET pages from which the user does backups. From
> here you can use .ExecuteNonQuery and execute the appropriate BACKUP
> DATABASE command. Note that the backup file will be created from the SQL
> Server machine's perspective.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "SStory" <TheStorys@.TAKEOUTTHISSPAMBUSTERsofthome.net> wrote in message
> news:%233WRgI5BEHA.3748@.tk2msftngp13.phx.gbl...
> make
>|||SQL Server does the backup, regardless of who submits the backup command.
Backup on C:\ and it is on C:\ on the SQL Server machine. You can then FTP
down the backup file or do whatever you want with it.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"SStory" <TheStorys@.TAKEOUTTHISSPAMBUSTERsofthome.net> wrote in message
news:%235k0gt5BEHA.3928@.TK2MSFTNGP11.phx.gbl...
> ok...
> But where does that file reside?
> If still no hosting site that isn't much of a backup.
> Are you saying try to backup to a local protected directory, download the
> backup file and in case of disaster client sends that backup file to
people
> on host site to restore?
> Thanks,
> Shane
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:%23Jy4hi5BEHA.3928@.TK2MSFTNGP11.phx.gbl...
clients
didn't
IT
>|||Ok. Thanks.
My client isn't too good at even FTP, so I would have to some how provide a
secure link I suppose. Thanks for the reply.
Shane
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OtLfke6BEHA.916@.tk2msftngp13.phx.gbl...
> SQL Server does the backup, regardless of who submits the backup command.
> Backup on C:\ and it is on C:\ on the SQL Server machine. You can then FTP
> down the backup file or do whatever you want with it.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "SStory" <TheStorys@.TAKEOUTTHISSPAMBUSTERsofthome.net> wrote in message
> news:%235k0gt5BEHA.3928@.TK2MSFTNGP11.phx.gbl...
the
> people
> in
From
SQL
message
> clients
> didn't
Server
> IT
>

Sunday, March 25, 2012

Backing Up DB with Script

Hi,
i am hosting my website's database account with godaddy.com. My website uses
a sql server 2000 database. All good and fine. they have a pretty good
customized web interface to manage sql server expect that this interface does
not have any way of making backups of the database.
I wrote down a custom script which i ran from there web sql query analyser
interface to backup my database to my FTP account but this just does not seem
to work, although it works perfect on my local machine. I am thinking it
might be becasue when i am running this script to do a backup to my ftp
account, sql server uses some kind of a windows user to write the backup file
in my ftp account but since it does not have permissins over my ftp account,
i think it bombs out. Please let me know if there is any way around this
problem or if my diagnosis of the problem is wrong itself. the script i am
using is
BACKUP DATABASE NORTHWIND TO DISK = â'D:\websites\myftpaccount\store.bak'
i am pretty sure this is the write physical address of the folder. Also when
i spoke with godady they said that it is possible to do the backups with a
script and said that there might be something wrong with my script, whichi
dont think so.
thanks
Sameer1. What is the error message you are getting?
2. Do you have permissions to backup the database?
3. Also try EXEC master.dbo.xp_cmdshell 'dir "D:\websites\myftpaccount\"'
Thanks
Ravi
"sameer" wrote:
> Hi,
> i am hosting my website's database account with godaddy.com. My website uses
> a sql server 2000 database. All good and fine. they have a pretty good
> customized web interface to manage sql server expect that this interface does
> not have any way of making backups of the database.
> I wrote down a custom script which i ran from there web sql query analyser
> interface to backup my database to my FTP account but this just does not seem
> to work, although it works perfect on my local machine. I am thinking it
> might be becasue when i am running this script to do a backup to my ftp
> account, sql server uses some kind of a windows user to write the backup file
> in my ftp account but since it does not have permissins over my ftp account,
> i think it bombs out. Please let me know if there is any way around this
> problem or if my diagnosis of the problem is wrong itself. the script i am
> using is
> BACKUP DATABASE NORTHWIND TO DISK = â'D:\websites\myftpaccount\store.bak'
> i am pretty sure this is the write physical address of the folder. Also when
> i spoke with godady they said that it is possible to do the backups with a
> script and said that there might be something wrong with my script, whichi
> dont think so.
> thanks
> Sameer|||Can you post the exact error message?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"sameer" <sameer@.discussions.microsoft.com> wrote in message
news:99C7BD6E-CD0E-4681-9B29-127A6CBBA77B@.microsoft.com...
Hi,
i am hosting my website's database account with godaddy.com. My website uses
a sql server 2000 database. All good and fine. they have a pretty good
customized web interface to manage sql server expect that this interface
does
not have any way of making backups of the database.
I wrote down a custom script which i ran from there web sql query analyser
interface to backup my database to my FTP account but this just does not
seem
to work, although it works perfect on my local machine. I am thinking it
might be becasue when i am running this script to do a backup to my ftp
account, sql server uses some kind of a windows user to write the backup
file
in my ftp account but since it does not have permissins over my ftp account,
i think it bombs out. Please let me know if there is any way around this
problem or if my diagnosis of the problem is wrong itself. the script i am
using is
BACKUP DATABASE NORTHWIND TO DISK = 'D:\websites\myftpaccount\store.bak'
i am pretty sure this is the write physical address of the folder. Also when
i spoke with godady they said that it is possible to do the backups with a
script and said that there might be something wrong with my script, whichi
dont think so.
thanks
Sameer|||Ravi and Narayana , thanks for reply
Error details are :
Error -2147217900
Cannot open backup device 'D:\websites\test\sameer.bak'. Device error or
device off-line. See the SQL Server error log for more details.
Ravi , i do have permission to backup.
"Narayana Vyas Kondreddi" wrote:
> Can you post the exact error message?
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "sameer" <sameer@.discussions.microsoft.com> wrote in message
> news:99C7BD6E-CD0E-4681-9B29-127A6CBBA77B@.microsoft.com...
> Hi,
> i am hosting my website's database account with godaddy.com. My website uses
> a sql server 2000 database. All good and fine. they have a pretty good
> customized web interface to manage sql server expect that this interface
> does
> not have any way of making backups of the database.
> I wrote down a custom script which i ran from there web sql query analyser
> interface to backup my database to my FTP account but this just does not
> seem
> to work, although it works perfect on my local machine. I am thinking it
> might be becasue when i am running this script to do a backup to my ftp
> account, sql server uses some kind of a windows user to write the backup
> file
> in my ftp account but since it does not have permissins over my ftp account,
> i think it bombs out. Please let me know if there is any way around this
> problem or if my diagnosis of the problem is wrong itself. the script i am
> using is
> BACKUP DATABASE NORTHWIND TO DISK = 'D:\websites\myftpaccount\store.bak'
> i am pretty sure this is the write physical address of the folder. Also when
> i spoke with godady they said that it is possible to do the backups with a
> script and said that there might be something wrong with my script, whichi
> dont think so.
> thanks
> Sameer
>
>|||Have you tried what Ravi asked? The permission to backup is the permission
of the acct used to start MSSQL service, not your permission. Following his
question will help troubleshooting.
"sameer" <sameer@.discussions.microsoft.com> wrote in message
news:6B27D23B-5060-4DD5-967F-517852CF2925@.microsoft.com...
> Ravi and Narayana , thanks for reply
> Error details are :
> Error -2147217900
> Cannot open backup device 'D:\websites\test\sameer.bak'. Device error or
> device off-line. See the SQL Server error log for more details.
> Ravi , i do have permission to backup.
>
> "Narayana Vyas Kondreddi" wrote:
>> Can you post the exact error message?
>> --
>> HTH,
>> Vyas, MVP (SQL Server)
>> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>>
>> "sameer" <sameer@.discussions.microsoft.com> wrote in message
>> news:99C7BD6E-CD0E-4681-9B29-127A6CBBA77B@.microsoft.com...
>> Hi,
>> i am hosting my website's database account with godaddy.com. My website
>> uses
>> a sql server 2000 database. All good and fine. they have a pretty good
>> customized web interface to manage sql server expect that this interface
>> does
>> not have any way of making backups of the database.
>> I wrote down a custom script which i ran from there web sql query
>> analyser
>> interface to backup my database to my FTP account but this just does not
>> seem
>> to work, although it works perfect on my local machine. I am thinking it
>> might be becasue when i am running this script to do a backup to my ftp
>> account, sql server uses some kind of a windows user to write the backup
>> file
>> in my ftp account but since it does not have permissins over my ftp
>> account,
>> i think it bombs out. Please let me know if there is any way around this
>> problem or if my diagnosis of the problem is wrong itself. the script i
>> am
>> using is
>> BACKUP DATABASE NORTHWIND TO DISK = 'D:\websites\myftpaccount\store.bak'
>> i am pretty sure this is the write physical address of the folder. Also
>> when
>> i spoke with godady they said that it is possible to do the backups with
>> a
>> script and said that there might be something wrong with my script,
>> whichi
>> dont think so.
>> thanks
>> Sameer
>>|||that is what i was thinking initially and had mentioned in my first email.
Also there is no way i can know what windows account the hosting copy uses
for sql server. considering this are the reason why i cannot do my backups,
do yu suggest any other way around this problem that i can still make my
backups. Reason why i still think there is a way is becaseu the hosting
company(godaddy) rep did tell me that other clients do it using scripts.
thanks
"ME" wrote:
> Have you tried what Ravi asked? The permission to backup is the permission
> of the acct used to start MSSQL service, not your permission. Following his
> question will help troubleshooting.
>
> "sameer" <sameer@.discussions.microsoft.com> wrote in message
> news:6B27D23B-5060-4DD5-967F-517852CF2925@.microsoft.com...
> > Ravi and Narayana , thanks for reply
> > Error details are :
> > Error -2147217900
> > Cannot open backup device 'D:\websites\test\sameer.bak'. Device error or
> > device off-line. See the SQL Server error log for more details.
> >
> > Ravi , i do have permission to backup.
> >
> >
> >
> > "Narayana Vyas Kondreddi" wrote:
> >
> >> Can you post the exact error message?
> >> --
> >> HTH,
> >> Vyas, MVP (SQL Server)
> >> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
> >>
> >>
> >> "sameer" <sameer@.discussions.microsoft.com> wrote in message
> >> news:99C7BD6E-CD0E-4681-9B29-127A6CBBA77B@.microsoft.com...
> >>
> >> Hi,
> >>
> >> i am hosting my website's database account with godaddy.com. My website
> >> uses
> >> a sql server 2000 database. All good and fine. they have a pretty good
> >> customized web interface to manage sql server expect that this interface
> >> does
> >> not have any way of making backups of the database.
> >> I wrote down a custom script which i ran from there web sql query
> >> analyser
> >> interface to backup my database to my FTP account but this just does not
> >> seem
> >> to work, although it works perfect on my local machine. I am thinking it
> >> might be becasue when i am running this script to do a backup to my ftp
> >> account, sql server uses some kind of a windows user to write the backup
> >> file
> >> in my ftp account but since it does not have permissins over my ftp
> >> account,
> >> i think it bombs out. Please let me know if there is any way around this
> >> problem or if my diagnosis of the problem is wrong itself. the script i
> >> am
> >> using is
> >>
> >> BACKUP DATABASE NORTHWIND TO DISK = 'D:\websites\myftpaccount\store.bak'
> >>
> >> i am pretty sure this is the write physical address of the folder. Also
> >> when
> >> i spoke with godady they said that it is possible to do the backups with
> >> a
> >> script and said that there might be something wrong with my script,
> >> whichi
> >> dont think so.
> >>
> >> thanks
> >> Sameer
> >>
> >>
> >>
>
>|||Talk to you hosting company and make them understand how backup in SQL server work. The SQL Server
service account is the one who writes the backup file and need permissions.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"sameer" <sameer@.discussions.microsoft.com> wrote in message
news:6FEDB9A8-F650-4BFE-8596-5B17767C155F@.microsoft.com...
> that is what i was thinking initially and had mentioned in my first email.
> Also there is no way i can know what windows account the hosting copy uses
> for sql server. considering this are the reason why i cannot do my backups,
> do yu suggest any other way around this problem that i can still make my
> backups. Reason why i still think there is a way is becaseu the hosting
> company(godaddy) rep did tell me that other clients do it using scripts.
> thanks
> "ME" wrote:
>> Have you tried what Ravi asked? The permission to backup is the permission
>> of the acct used to start MSSQL service, not your permission. Following his
>> question will help troubleshooting.
>>
>> "sameer" <sameer@.discussions.microsoft.com> wrote in message
>> news:6B27D23B-5060-4DD5-967F-517852CF2925@.microsoft.com...
>> > Ravi and Narayana , thanks for reply
>> > Error details are :
>> > Error -2147217900
>> > Cannot open backup device 'D:\websites\test\sameer.bak'. Device error or
>> > device off-line. See the SQL Server error log for more details.
>> >
>> > Ravi , i do have permission to backup.
>> >
>> >
>> >
>> > "Narayana Vyas Kondreddi" wrote:
>> >
>> >> Can you post the exact error message?
>> >> --
>> >> HTH,
>> >> Vyas, MVP (SQL Server)
>> >> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>> >>
>> >>
>> >> "sameer" <sameer@.discussions.microsoft.com> wrote in message
>> >> news:99C7BD6E-CD0E-4681-9B29-127A6CBBA77B@.microsoft.com...
>> >>
>> >> Hi,
>> >>
>> >> i am hosting my website's database account with godaddy.com. My website
>> >> uses
>> >> a sql server 2000 database. All good and fine. they have a pretty good
>> >> customized web interface to manage sql server expect that this interface
>> >> does
>> >> not have any way of making backups of the database.
>> >> I wrote down a custom script which i ran from there web sql query
>> >> analyser
>> >> interface to backup my database to my FTP account but this just does not
>> >> seem
>> >> to work, although it works perfect on my local machine. I am thinking it
>> >> might be becasue when i am running this script to do a backup to my ftp
>> >> account, sql server uses some kind of a windows user to write the backup
>> >> file
>> >> in my ftp account but since it does not have permissins over my ftp
>> >> account,
>> >> i think it bombs out. Please let me know if there is any way around this
>> >> problem or if my diagnosis of the problem is wrong itself. the script i
>> >> am
>> >> using is
>> >>
>> >> BACKUP DATABASE NORTHWIND TO DISK = 'D:\websites\myftpaccount\store.bak'
>> >>
>> >> i am pretty sure this is the write physical address of the folder. Also
>> >> when
>> >> i spoke with godady they said that it is possible to do the backups with
>> >> a
>> >> script and said that there might be something wrong with my script,
>> >> whichi
>> >> dont think so.
>> >>
>> >> thanks
>> >> Sameer
>> >>
>> >>
>> >>
>>|||You also have to make sure that the folder you're backing up to exists. SQL
Server can't create the folder if it doesn't exist though you might get a
different error message if that's the problem (Can't remember it on top of
my head...).
Regards
Steen
sameer wrote:
> that is what i was thinking initially and had mentioned in my first
> email. Also there is no way i can know what windows account the
> hosting copy uses for sql server. considering this are the reason why
> i cannot do my backups, do yu suggest any other way around this
> problem that i can still make my backups. Reason why i still think
> there is a way is becaseu the hosting company(godaddy) rep did tell
> me that other clients do it using scripts.
> thanks
> "ME" wrote:
>> Have you tried what Ravi asked? The permission to backup is the
>> permission of the acct used to start MSSQL service, not your
>> permission. Following his question will help troubleshooting.
>>
>> "sameer" <sameer@.discussions.microsoft.com> wrote in message
>> news:6B27D23B-5060-4DD5-967F-517852CF2925@.microsoft.com...
>> Ravi and Narayana , thanks for reply
>> Error details are :
>> Error -2147217900
>> Cannot open backup device 'D:\websites\test\sameer.bak'. Device
>> error or device off-line. See the SQL Server error log for more
>> details.
>> Ravi , i do have permission to backup.
>>
>> "Narayana Vyas Kondreddi" wrote:
>> Can you post the exact error message?
>> --
>> HTH,
>> Vyas, MVP (SQL Server)
>> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>>
>> "sameer" <sameer@.discussions.microsoft.com> wrote in message
>> news:99C7BD6E-CD0E-4681-9B29-127A6CBBA77B@.microsoft.com...
>> Hi,
>> i am hosting my website's database account with godaddy.com. My
>> website uses
>> a sql server 2000 database. All good and fine. they have a pretty
>> good customized web interface to manage sql server expect that
>> this interface does
>> not have any way of making backups of the database.
>> I wrote down a custom script which i ran from there web sql query
>> analyser
>> interface to backup my database to my FTP account but this just
>> does not seem
>> to work, although it works perfect on my local machine. I am
>> thinking it might be becasue when i am running this script to do a
>> backup to my ftp account, sql server uses some kind of a windows
>> user to write the backup file
>> in my ftp account but since it does not have permissins over my ftp
>> account,
>> i think it bombs out. Please let me know if there is any way
>> around this problem or if my diagnosis of the problem is wrong
>> itself. the script i am
>> using is
>> BACKUP DATABASE NORTHWIND TO DISK =>> 'D:\websites\myftpaccount\store.bak'
>> i am pretty sure this is the write physical address of the folder.
>> Also when
>> i spoke with godady they said that it is possible to do the
>> backups with a
>> script and said that there might be something wrong with my script,
>> whichi
>> dont think so.
>> thanks
>> Sameer

Tuesday, March 27, 2012

Backing up remote SQL Server

Sunday, March 25, 2012

Backing Up DB with Script

Backing Up DB with Script

Backing Up DB with Script

Autonumber field

Blog Archive

About Me