I've installed MSDE SP3, and I'm looking for a script that runs once
before back-up to shut down the server, and once after backing-up, to
restart the server. This is supposed to go automatically. I'm running
Veritas Back_up Exec 9.0 (Without SQL extension... ).
Does anyone have an easy script for to run on my Win2k Server?
--
Jakob /n Powder (i.e. Snow) To The People
Posted via http://dbforums.comWhy do you want to shutdown the server, for creating a backup? The native
SQL Server BACKUP command is online and can backup databases that are
currently being accessed.
Are you trying to copy the physical files? If so, you may want to look at
NET STOP and NET START commands for stopping and starting services.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"JakobDi" <Jakob_di@.hotmail.com> wrote in message
news:3381077.1063810544@.dbforums.com...
I've installed MSDE SP3, and I'm looking for a script that runs once
before back-up to shut down the server, and once after backing-up, to
restart the server. This is supposed to go automatically. I'm running
Veritas Back_up Exec 9.0 (Without SQL extension... ).
Does anyone have an easy script for to run on my Win2k Server?
Jakob /n Powder (i.e. Snow) To The People
Posted via http://dbforums.com|||do a simple .BAT file to stop SQL service before backup runs and another
.BAT file after backup done to start SQL service. You can place the path to
run these files into Backup Exec job. I never use MSDE so I ain't sure but
for SQL you can similar to this:
BEFORE.BAT
net stop mssqlserver
AFTER.BAT
net start mssqlserver
Are you trying to backup the .MDF and LDF files? I prefer using native SQL
backup tools to backup databases.
hth,
"JakobDi" <Jakob_di@.hotmail.com> wrote in message
news:3381077.1063810544@.dbforums.com...
> I've installed MSDE SP3, and I'm looking for a script that runs once
> before back-up to shut down the server, and once after backing-up, to
> restart the server. This is supposed to go automatically. I'm running
> Veritas Back_up Exec 9.0 (Without SQL extension... ).
>
> Does anyone have an easy script for to run on my Win2k Server?
>
> --
> Jakob /n Powder (i.e. Snow) To The People
>
> Posted via http://dbforums.com|||Thanks All;
net stop mssql$test2 & net start msssql$test2 performed as expected,
(and the solution was rather simple; didn't think it would be
this easy...)
:-)
Originally posted by Flicker
> do a simple .BAT file to stop SQL service before backup runs
> and another
> .BAT file after backup done to start SQL service. You can place
> the path to
> run these files into Backup Exec job. I never use MSDE so I ain't
> sure but
> for SQL you can similar to this:
>
> BEFORE.BAT
> net stop mssqlserver
>
> AFTER.BAT
> net start mssqlserver
>
>
> Are you trying to backup the .MDF and LDF files? I prefer using
> native SQL
> backup tools to backup databases.
>
> hth,
>
>
>
>
> "JakobDi" <Jakob_di@.hotmail.com> wrote in message
> news:3381077.1063810544@.dbforums.com"]news:3381077.1063810544@.d-
> bforums.com[/url]...
> > I've installed MSDE SP3, and I'm looking for a script that runs
> once
> > before back-up to shut down the server, and once after backing-
> up, to
> > restart the server. This is supposed to go automatically. I'm
> running
> > Veritas Back_up Exec 9.0 (Without SQL extension... ).
> > Does anyone have an easy script for to run on my Win2k
> Server?
> > --
> > Jakob /n Powder (i.e. Snow) To The People
> Posted via
http://dbforums.com/http://dbforums.com
Jakob /n Powder (i.e. Snow) To The People
Posted via http://dbforums.com
Showing posts with label script. Show all posts
Showing posts with label script. Show all posts
Thursday, March 29, 2012
Sunday, March 25, 2012
Backing up log file with a script setup as a job
Is there any way to include in this script below something
to tell the job to backup will the log file when it gets
to a certain percentage say 85%.
Thanks,
Aboki.
/* Script for backing up the transaction log when it is
getting full and clear the space for the log file. */
/* This can also apply to any other system but you need to
change drive and part location */
/* to match where backup location */
Backup LOG IntegraProd TO
DISK = 'D:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\IntegraProdTran.bak'
GOYou could write a job to run every so often, which uses DBCC PERFLOG
to get information about log space and log space used. If log space for your
database is > 85% then issue your t-sql command.
The log is cyclic, it should wrap around and re-use empty space
where possible. It needs to keep information on the oldest active
transaction
for rollback. If your log is constantly at a certain size, this will most
likely be
right for the database anyway.
HTH
"Aboki" <waco361@.hotmail.com> wrote in message
news:08d801c3627b$37d262a0$a001280a@.phx.gbl...
> Is there any way to include in this script below something
> to tell the job to backup will the log file when it gets
> to a certain percentage say 85%.
> Thanks,
> Aboki.
>
> /* Script for backing up the transaction log when it is
> getting full and clear the space for the log file. */
> /* This can also apply to any other system but you need to
> change drive and part location */
> /* to match where backup location */
>
> Backup LOG IntegraProd TO
> DISK = 'D:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\IntegraProdTran.bak'
> GO|||You can set an alert to start the job. There should be an example alert you
can modify already installed with SQL.
--
Geoff N. Hiten
SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Aboki" <waco361@.hotmail.com> wrote in message
news:08d801c3627b$37d262a0$a001280a@.phx.gbl...
> Is there any way to include in this script below something
> to tell the job to backup will the log file when it gets
> to a certain percentage say 85%.
> Thanks,
> Aboki.
>
> /* Script for backing up the transaction log when it is
> getting full and clear the space for the log file. */
> /* This can also apply to any other system but you need to
> change drive and part location */
> /* to match where backup location */
>
> Backup LOG IntegraProd TO
> DISK = 'D:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\IntegraProdTran.bak'
> GOsql
to tell the job to backup will the log file when it gets
to a certain percentage say 85%.
Thanks,
Aboki.
/* Script for backing up the transaction log when it is
getting full and clear the space for the log file. */
/* This can also apply to any other system but you need to
change drive and part location */
/* to match where backup location */
Backup LOG IntegraProd TO
DISK = 'D:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\IntegraProdTran.bak'
GOYou could write a job to run every so often, which uses DBCC PERFLOG
to get information about log space and log space used. If log space for your
database is > 85% then issue your t-sql command.
The log is cyclic, it should wrap around and re-use empty space
where possible. It needs to keep information on the oldest active
transaction
for rollback. If your log is constantly at a certain size, this will most
likely be
right for the database anyway.
HTH
"Aboki" <waco361@.hotmail.com> wrote in message
news:08d801c3627b$37d262a0$a001280a@.phx.gbl...
> Is there any way to include in this script below something
> to tell the job to backup will the log file when it gets
> to a certain percentage say 85%.
> Thanks,
> Aboki.
>
> /* Script for backing up the transaction log when it is
> getting full and clear the space for the log file. */
> /* This can also apply to any other system but you need to
> change drive and part location */
> /* to match where backup location */
>
> Backup LOG IntegraProd TO
> DISK = 'D:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\IntegraProdTran.bak'
> GO|||You can set an alert to start the job. There should be an example alert you
can modify already installed with SQL.
--
Geoff N. Hiten
SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Aboki" <waco361@.hotmail.com> wrote in message
news:08d801c3627b$37d262a0$a001280a@.phx.gbl...
> Is there any way to include in this script below something
> to tell the job to backup will the log file when it gets
> to a certain percentage say 85%.
> Thanks,
> Aboki.
>
> /* Script for backing up the transaction log when it is
> getting full and clear the space for the log file. */
> /* This can also apply to any other system but you need to
> change drive and part location */
> /* to match where backup location */
>
> Backup LOG IntegraProd TO
> DISK = 'D:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\IntegraProdTran.bak'
> GOsql
backing up everything to sql script
is there a way to back up the entire database, data, relations, tables, and
procedures to an sql script? and if so how do i do it? thanksBrian,
> is there a way to back up the entire database, data, relations,
> tables, and procedures to an sql script? and if so how do i do
> it? thanks
Yes, in Enterprise Manager. Right-click on the database, select All
Tasks | Generate SQL Script... from the menu.
Linda|||Brian,
Just one oversite - This does not get you the DATA.
You can back up the data using:
1) A full database backup - also gets you everything else
2) Detach database and file copy mdf, ndf, ldf files (or just stop SQL server rather than detach)
3) bcp
4) dts
5) Access import via odbc ( okay not so easy to get back, but still useful )
With 3) to 5) backup is on a table by table basis.
Regards
AJ
"lindawie" <lindawie@.my-deja.com> wrote in message news:OYUXTpEkDHA.976@.tk2msftngp13.phx.gbl...
> Brian,
> > is there a way to back up the entire database, data, relations,
> > tables, and procedures to an sql script? and if so how do i do
> > it? thanks
> Yes, in Enterprise Manager. Right-click on the database, select All
> Tasks | Generate SQL Script... from the menu.
> Linda
>
procedures to an sql script? and if so how do i do it? thanksBrian,
> is there a way to back up the entire database, data, relations,
> tables, and procedures to an sql script? and if so how do i do
> it? thanks
Yes, in Enterprise Manager. Right-click on the database, select All
Tasks | Generate SQL Script... from the menu.
Linda|||Brian,
Just one oversite - This does not get you the DATA.
You can back up the data using:
1) A full database backup - also gets you everything else
2) Detach database and file copy mdf, ndf, ldf files (or just stop SQL server rather than detach)
3) bcp
4) dts
5) Access import via odbc ( okay not so easy to get back, but still useful )
With 3) to 5) backup is on a table by table basis.
Regards
AJ
"lindawie" <lindawie@.my-deja.com> wrote in message news:OYUXTpEkDHA.976@.tk2msftngp13.phx.gbl...
> Brian,
> > is there a way to back up the entire database, data, relations,
> > tables, and procedures to an sql script? and if so how do i do
> > it? thanks
> Yes, in Enterprise Manager. Right-click on the database, select All
> Tasks | Generate SQL Script... from the menu.
> Linda
>
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
Sameer
1. 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...[vbcol=seagreen]
> 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:
|||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...
>
>
|||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...[vbcol=seagreen]
> 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:
|||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:[vbcol=seagreen]
> 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:
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
1. 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...[vbcol=seagreen]
> 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:
|||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...
>
>
|||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...[vbcol=seagreen]
> 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:
|||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:[vbcol=seagreen]
> 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:
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 doe
s
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 see
m
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 fil
e
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 us
es
> 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 d
oes
> 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 s
eem
> 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 f
ile
> in my ftp account but since it does not have permissins over my ftp accoun
t,
> 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 a
m
> 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 wh
en
> 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 us
es
> 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 accoun
t,
> 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 a
m
> 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 wh
en
> 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...[vbcol=seagreen]
> 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:
>|||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 permissio
n
> of the acct used to start MSSQL service, not your permission. Following h
is
> question will help troubleshooting.
>
> "sameer" <sameer@.discussions.microsoft.com> wrote in message
> news:6B27D23B-5060-4DD5-967F-517852CF2925@.microsoft.com...
>
>|||Talk to you hosting company and make them understand how backup in SQL serve
r 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...[vbcol=seagreen]
> 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:
>|||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:[vbcol=seagreen]
> 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:
>
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 doe
s
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 see
m
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 fil
e
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 us
es
> 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 d
oes
> 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 s
eem
> 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 f
ile
> in my ftp account but since it does not have permissins over my ftp accoun
t,
> 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 a
m
> 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 wh
en
> 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 us
es
> 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 accoun
t,
> 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 a
m
> 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 wh
en
> 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...[vbcol=seagreen]
> 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:
>|||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 permissio
n
> of the acct used to start MSSQL service, not your permission. Following h
is
> question will help troubleshooting.
>
> "sameer" <sameer@.discussions.microsoft.com> wrote in message
> news:6B27D23B-5060-4DD5-967F-517852CF2925@.microsoft.com...
>
>|||Talk to you hosting company and make them understand how backup in SQL serve
r 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...[vbcol=seagreen]
> 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:
>|||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:[vbcol=seagreen]
> 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:
>
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
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
Wednesday, March 7, 2012
AWE and Target Server Memory
Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
This is the script we used to enable AWE and set Max Memory, essentially
leaving 2GB for the OS.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
set.
The question I have, is what I am seeing for Target and Total Server Memory:
Target Server Memory(KB) = 4087767
Total Server Memory(KB) = 4087747
I was expecting to see more Target Server Memory being used (closer to 6GB)
rather than only 4087767KB / 3.898GB.
Please explain.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1What version of SQL Server are you using?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:663faf808d6ce@.uwe...
Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
This is the script we used to enable AWE and set Max Memory, essentially
leaving 2GB for the OS.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
set.
The question I have, is what I am seeing for Target and Total Server Memory:
Target Server Memory(KB) = 4087767
Total Server Memory(KB) = 4087747
I was expecting to see more Target Server Memory being used (closer to 6GB)
rather than only 4087767KB / 3.898GB.
Please explain.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1|||SQL 2000
Tom Moreau wrote:
>What version of SQL Server are you using?
>Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
>This is the script we used to enable AWE and set Max Memory, essentially
>leaving 2GB for the OS.
>sp_configure 'show advanced options', 1
>RECONFIGURE
>GO
>sp_configure 'awe enabled', 1
>RECONFIGURE
>GO
>sp_configure 'max server memory', 6144
>RECONFIGURE
>GO
>Just so you are aware, we do have the boot.ini with the PAE and 3GB switche
s
>set.
>The question I have, is what I am seeing for Target and Total Server Memory
:
>Target Server Memory(KB) = 4087767
>Total Server Memory(KB) = 4087747
>I was expecting to see more Target Server Memory being used (closer to 6GB)
>rather than only 4087767KB / 3.898GB.
>Please explain.
Message posted via http://www.droptable.com|||Which SP level? What's the result of running:
SELECT @.@.VERSION
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:663fdb867f662@.uwe...
SQL 2000
Tom Moreau wrote:
>What version of SQL Server are you using?
>Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
>This is the script we used to enable AWE and set Max Memory, essentially
>leaving 2GB for the OS.
>sp_configure 'show advanced options', 1
>RECONFIGURE
>GO
>sp_configure 'awe enabled', 1
>RECONFIGURE
>GO
>sp_configure 'max server memory', 6144
>RECONFIGURE
>GO
>Just so you are aware, we do have the boot.ini with the PAE and 3GB
>switches
>set.
>The question I have, is what I am seeing for Target and Total Server
>Memory:
>Target Server Memory(KB) = 4087767
>Total Server Memory(KB) = 4087747
>I was expecting to see more Target Server Memory being used (closer to 6GB)
>rather than only 4087767KB / 3.898GB.
>Please explain.
Message posted via http://www.droptable.com|||Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
Tom Moreau wrote:[vbcol=seagreen]
>Which SP level? What's the result of running:
>SELECT @.@.VERSION
>SQL 2000
>Tom Moreau wrote:
>[quoted text clipped - 27 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1|||What happens if you set the min server memory and restart SQL Server?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:664097d00a0ed@.uwe...
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
Tom Moreau wrote:[vbcol=seagreen]
>Which SP level? What's the result of running:
>SELECT @.@.VERSION
>SQL 2000
>Tom Moreau wrote:
>[quoted text clipped - 27 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1|||I am away from the office and will not have access to the server until
tomorrow around 10:00 MST. Even then we will not be able to restart the
service until late tomorrow evening. Do you have a theory about setting "min
server memory"? I believe I recall on the "max server memory" the minimum is
set to 4. Anyway, just trying to follow your thought process on why the "min
server memory" might be inhibiting memory use.
Tom Moreau wrote:[vbcol=seagreen]
>What happens if you set the min server memory and restart SQL Server?
>Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
>Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Window
s
>NT 5.2 (Build 3790: Service Pack 1)
>Tom Moreau wrote:
>[quoted text clipped - 7 lines]
Message posted via http://www.droptable.com|||In SQL 2005, server memory will gradually climb to the max server memory,
whether or not you're using AWE. In SQL 2000, it's supposed to take it in
one chunk, IIRC. I'm thinking that if max = min = whatever you really want,
then you may be forcing it up to that level straight away.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:6641520a8602d@.uwe...
I am away from the office and will not have access to the server until
tomorrow around 10:00 MST. Even then we will not be able to restart the
service until late tomorrow evening. Do you have a theory about setting "min
server memory"? I believe I recall on the "max server memory" the minimum is
set to 4. Anyway, just trying to follow your thought process on why the "min
server memory" might be inhibiting memory use.
Tom Moreau wrote:[vbcol=seagreen]
>What happens if you set the min server memory and restart SQL Server?
>Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
>Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on
>Windows
>NT 5.2 (Build 3790: Service Pack 1)
>Tom Moreau wrote:
>[quoted text clipped - 7 lines]
Message posted via http://www.droptable.com|||This is the 'expected behavior' of 8.00.2039 and is fixed in 8.00.2040. See
http://support.microsoft.com/defaul...kb;en-us;899761
Linchi
"cbrichards via droptable.com" wrote:
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windo
ws
> NT 5.2 (Build 3790: Service Pack 1)
>
> Tom Moreau wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200609/1
>
This is the script we used to enable AWE and set Max Memory, essentially
leaving 2GB for the OS.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
set.
The question I have, is what I am seeing for Target and Total Server Memory:
Target Server Memory(KB) = 4087767
Total Server Memory(KB) = 4087747
I was expecting to see more Target Server Memory being used (closer to 6GB)
rather than only 4087767KB / 3.898GB.
Please explain.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1What version of SQL Server are you using?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:663faf808d6ce@.uwe...
Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
This is the script we used to enable AWE and set Max Memory, essentially
leaving 2GB for the OS.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
set.
The question I have, is what I am seeing for Target and Total Server Memory:
Target Server Memory(KB) = 4087767
Total Server Memory(KB) = 4087747
I was expecting to see more Target Server Memory being used (closer to 6GB)
rather than only 4087767KB / 3.898GB.
Please explain.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1|||SQL 2000
Tom Moreau wrote:
>What version of SQL Server are you using?
>Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
>This is the script we used to enable AWE and set Max Memory, essentially
>leaving 2GB for the OS.
>sp_configure 'show advanced options', 1
>RECONFIGURE
>GO
>sp_configure 'awe enabled', 1
>RECONFIGURE
>GO
>sp_configure 'max server memory', 6144
>RECONFIGURE
>GO
>Just so you are aware, we do have the boot.ini with the PAE and 3GB switche
s
>set.
>The question I have, is what I am seeing for Target and Total Server Memory
:
>Target Server Memory(KB) = 4087767
>Total Server Memory(KB) = 4087747
>I was expecting to see more Target Server Memory being used (closer to 6GB)
>rather than only 4087767KB / 3.898GB.
>Please explain.
Message posted via http://www.droptable.com|||Which SP level? What's the result of running:
SELECT @.@.VERSION
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:663fdb867f662@.uwe...
SQL 2000
Tom Moreau wrote:
>What version of SQL Server are you using?
>Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
>This is the script we used to enable AWE and set Max Memory, essentially
>leaving 2GB for the OS.
>sp_configure 'show advanced options', 1
>RECONFIGURE
>GO
>sp_configure 'awe enabled', 1
>RECONFIGURE
>GO
>sp_configure 'max server memory', 6144
>RECONFIGURE
>GO
>Just so you are aware, we do have the boot.ini with the PAE and 3GB
>switches
>set.
>The question I have, is what I am seeing for Target and Total Server
>Memory:
>Target Server Memory(KB) = 4087767
>Total Server Memory(KB) = 4087747
>I was expecting to see more Target Server Memory being used (closer to 6GB)
>rather than only 4087767KB / 3.898GB.
>Please explain.
Message posted via http://www.droptable.com|||Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
Tom Moreau wrote:[vbcol=seagreen]
>Which SP level? What's the result of running:
>SELECT @.@.VERSION
>SQL 2000
>Tom Moreau wrote:
>[quoted text clipped - 27 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1|||What happens if you set the min server memory and restart SQL Server?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:664097d00a0ed@.uwe...
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
Tom Moreau wrote:[vbcol=seagreen]
>Which SP level? What's the result of running:
>SELECT @.@.VERSION
>SQL 2000
>Tom Moreau wrote:
>[quoted text clipped - 27 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1|||I am away from the office and will not have access to the server until
tomorrow around 10:00 MST. Even then we will not be able to restart the
service until late tomorrow evening. Do you have a theory about setting "min
server memory"? I believe I recall on the "max server memory" the minimum is
set to 4. Anyway, just trying to follow your thought process on why the "min
server memory" might be inhibiting memory use.
Tom Moreau wrote:[vbcol=seagreen]
>What happens if you set the min server memory and restart SQL Server?
>Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
>Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Window
s
>NT 5.2 (Build 3790: Service Pack 1)
>Tom Moreau wrote:
>[quoted text clipped - 7 lines]
Message posted via http://www.droptable.com|||In SQL 2005, server memory will gradually climb to the max server memory,
whether or not you're using AWE. In SQL 2000, it's supposed to take it in
one chunk, IIRC. I'm thinking that if max = min = whatever you really want,
then you may be forcing it up to that level straight away.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:6641520a8602d@.uwe...
I am away from the office and will not have access to the server until
tomorrow around 10:00 MST. Even then we will not be able to restart the
service until late tomorrow evening. Do you have a theory about setting "min
server memory"? I believe I recall on the "max server memory" the minimum is
set to 4. Anyway, just trying to follow your thought process on why the "min
server memory" might be inhibiting memory use.
Tom Moreau wrote:[vbcol=seagreen]
>What happens if you set the min server memory and restart SQL Server?
>Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
>Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on
>Windows
>NT 5.2 (Build 3790: Service Pack 1)
>Tom Moreau wrote:
>[quoted text clipped - 7 lines]
Message posted via http://www.droptable.com|||This is the 'expected behavior' of 8.00.2039 and is fixed in 8.00.2040. See
http://support.microsoft.com/defaul...kb;en-us;899761
Linchi
"cbrichards via droptable.com" wrote:
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windo
ws
> NT 5.2 (Build 3790: Service Pack 1)
>
> Tom Moreau wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200609/1
>
AWE and Target Server Memory
Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
This is the script we used to enable AWE and set Max Memory, essentially
leaving 2GB for the OS.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
set.
The question I have, is what I am seeing for Target and Total Server Memory:
Target Server Memory(KB) = 4087767
Total Server Memory(KB) = 4087747
I was expecting to see more Target Server Memory being used (closer to 6GB)
rather than only 4087767KB / 3.898GB.
Please explain.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1Hi,
Do you see the Linch's message ?
This is a SQL Server 2000 Bug after you install SP4, Microsoft recommend
apply following patch:
http://support.microsoft.com/defaul...kb;en-us;899761
Run the following command for see memory status in SQL Server 2000:
DBCC MEMORYSTATUS
For more information see the following KB:
http://support.microsoft.com/?id=271624
Regards,
Rodrigo Fernandes
"cbrichards via droptable.com" wrote:
> Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
> This is the script we used to enable AWE and set Max Memory, essentially
> leaving 2GB for the OS.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> Just so you are aware, we do have the boot.ini with the PAE and 3GB switch
es
> set.
> The question I have, is what I am seeing for Target and Total Server Memor
y:
> Target Server Memory(KB) = 4087767
> Total Server Memory(KB) = 4087747
> I was expecting to see more Target Server Memory being used (closer to 6GB
)
> rather than only 4087767KB / 3.898GB.
> Please explain.
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200609/1
>
This is the script we used to enable AWE and set Max Memory, essentially
leaving 2GB for the OS.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
set.
The question I have, is what I am seeing for Target and Total Server Memory:
Target Server Memory(KB) = 4087767
Total Server Memory(KB) = 4087747
I was expecting to see more Target Server Memory being used (closer to 6GB)
rather than only 4087767KB / 3.898GB.
Please explain.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1Hi,
Do you see the Linch's message ?
This is a SQL Server 2000 Bug after you install SP4, Microsoft recommend
apply following patch:
http://support.microsoft.com/defaul...kb;en-us;899761
Run the following command for see memory status in SQL Server 2000:
DBCC MEMORYSTATUS
For more information see the following KB:
http://support.microsoft.com/?id=271624
Regards,
Rodrigo Fernandes
"cbrichards via droptable.com" wrote:
> Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
> This is the script we used to enable AWE and set Max Memory, essentially
> leaving 2GB for the OS.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> Just so you are aware, we do have the boot.ini with the PAE and 3GB switch
es
> set.
> The question I have, is what I am seeing for Target and Total Server Memor
y:
> Target Server Memory(KB) = 4087767
> Total Server Memory(KB) = 4087747
> I was expecting to see more Target Server Memory being used (closer to 6GB
)
> rather than only 4087767KB / 3.898GB.
> Please explain.
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200609/1
>
AWE and Target Server Memory
Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
This is the script we used to enable AWE and set Max Memory, essentially
leaving 2GB for the OS.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
set.
The question I have, is what I am seeing for Target and Total Server Memory:
Target Server Memory(KB) = 4087767
Total Server Memory(KB) = 4087747
I was expecting to see more Target Server Memory being used (closer to 6GB)
rather than only 4087767KB / 3.898GB.
Please explain.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200609/1
Hi,
Do you see the Linch's message ?
This is a SQL Server 2000 Bug after you install SP4, Microsoft recommend
apply following patch:
http://support.microsoft.com/default...b;en-us;899761
Run the following command for see memory status in SQL Server 2000:
DBCC MEMORYSTATUS
For more information see the following KB:
http://support.microsoft.com/?id=271624
Regards,
Rodrigo Fernandes
"cbrichards via droptable.com" wrote:
> Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
> This is the script we used to enable AWE and set Max Memory, essentially
> leaving 2GB for the OS.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
> set.
> The question I have, is what I am seeing for Target and Total Server Memory:
> Target Server Memory(KB) = 4087767
> Total Server Memory(KB) = 4087747
> I was expecting to see more Target Server Memory being used (closer to 6GB)
> rather than only 4087767KB / 3.898GB.
> Please explain.
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200609/1
>
This is the script we used to enable AWE and set Max Memory, essentially
leaving 2GB for the OS.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
set.
The question I have, is what I am seeing for Target and Total Server Memory:
Target Server Memory(KB) = 4087767
Total Server Memory(KB) = 4087747
I was expecting to see more Target Server Memory being used (closer to 6GB)
rather than only 4087767KB / 3.898GB.
Please explain.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200609/1
Hi,
Do you see the Linch's message ?
This is a SQL Server 2000 Bug after you install SP4, Microsoft recommend
apply following patch:
http://support.microsoft.com/default...b;en-us;899761
Run the following command for see memory status in SQL Server 2000:
DBCC MEMORYSTATUS
For more information see the following KB:
http://support.microsoft.com/?id=271624
Regards,
Rodrigo Fernandes
"cbrichards via droptable.com" wrote:
> Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
> This is the script we used to enable AWE and set Max Memory, essentially
> leaving 2GB for the OS.
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
> set.
> The question I have, is what I am seeing for Target and Total Server Memory:
> Target Server Memory(KB) = 4087767
> Total Server Memory(KB) = 4087747
> I was expecting to see more Target Server Memory being used (closer to 6GB)
> rather than only 4087767KB / 3.898GB.
> Please explain.
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200609/1
>
AWE and Target Server Memory
Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
This is the script we used to enable AWE and set Max Memory, essentially
leaving 2GB for the OS.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
set.
The question I have, is what I am seeing for Target and Total Server Memory:
Target Server Memory(KB) = 4087767
Total Server Memory(KB) = 4087747
I was expecting to see more Target Server Memory being used (closer to 6GB)
rather than only 4087767KB / 3.898GB.
Please explain.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200609/1
What version of SQL Server are you using?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:663faf808d6ce@.uwe...
Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
This is the script we used to enable AWE and set Max Memory, essentially
leaving 2GB for the OS.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
set.
The question I have, is what I am seeing for Target and Total Server Memory:
Target Server Memory(KB) = 4087767
Total Server Memory(KB) = 4087747
I was expecting to see more Target Server Memory being used (closer to 6GB)
rather than only 4087767KB / 3.898GB.
Please explain.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200609/1
|||SQL 2000
Tom Moreau wrote:
>What version of SQL Server are you using?
>Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
>This is the script we used to enable AWE and set Max Memory, essentially
>leaving 2GB for the OS.
>sp_configure 'show advanced options', 1
>RECONFIGURE
>GO
>sp_configure 'awe enabled', 1
>RECONFIGURE
>GO
>sp_configure 'max server memory', 6144
>RECONFIGURE
>GO
>Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
>set.
>The question I have, is what I am seeing for Target and Total Server Memory:
>Target Server Memory(KB) = 4087767
>Total Server Memory(KB) = 4087747
>I was expecting to see more Target Server Memory being used (closer to 6GB)
>rather than only 4087767KB / 3.898GB.
>Please explain.
Message posted via http://www.droptable.com
|||Which SP level? What's the result of running:
SELECT @.@.VERSION
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:663fdb867f662@.uwe...
SQL 2000
Tom Moreau wrote:
>What version of SQL Server are you using?
>Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
>This is the script we used to enable AWE and set Max Memory, essentially
>leaving 2GB for the OS.
>sp_configure 'show advanced options', 1
>RECONFIGURE
>GO
>sp_configure 'awe enabled', 1
>RECONFIGURE
>GO
>sp_configure 'max server memory', 6144
>RECONFIGURE
>GO
>Just so you are aware, we do have the boot.ini with the PAE and 3GB
>switches
>set.
>The question I have, is what I am seeing for Target and Total Server
>Memory:
>Target Server Memory(KB) = 4087767
>Total Server Memory(KB) = 4087747
>I was expecting to see more Target Server Memory being used (closer to 6GB)
>rather than only 4087767KB / 3.898GB.
>Please explain.
Message posted via http://www.droptable.com
|||Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
Tom Moreau wrote:[vbcol=seagreen]
>Which SP level? What's the result of running:
>SELECT @.@.VERSION
>SQL 2000
>Tom Moreau wrote:
>[quoted text clipped - 27 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200609/1
|||What happens if you set the min server memory and restart SQL Server?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:664097d00a0ed@.uwe...
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
Tom Moreau wrote:[vbcol=seagreen]
>Which SP level? What's the result of running:
>SELECT @.@.VERSION
>SQL 2000
>Tom Moreau wrote:
>[quoted text clipped - 27 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200609/1
|||I am away from the office and will not have access to the server until
tomorrow around 10:00 MST. Even then we will not be able to restart the
service until late tomorrow evening. Do you have a theory about setting "min
server memory"? I believe I recall on the "max server memory" the minimum is
set to 4. Anyway, just trying to follow your thought process on why the "min
server memory" might be inhibiting memory use.
Tom Moreau wrote:[vbcol=seagreen]
>What happens if you set the min server memory and restart SQL Server?
>Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
>Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
>NT 5.2 (Build 3790: Service Pack 1)
>Tom Moreau wrote:
>[quoted text clipped - 7 lines]
Message posted via http://www.droptable.com
|||In SQL 2005, server memory will gradually climb to the max server memory,
whether or not you're using AWE. In SQL 2000, it's supposed to take it in
one chunk, IIRC. I'm thinking that if max = min = whatever you really want,
then you may be forcing it up to that level straight away.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:6641520a8602d@.uwe...
I am away from the office and will not have access to the server until
tomorrow around 10:00 MST. Even then we will not be able to restart the
service until late tomorrow evening. Do you have a theory about setting "min
server memory"? I believe I recall on the "max server memory" the minimum is
set to 4. Anyway, just trying to follow your thought process on why the "min
server memory" might be inhibiting memory use.
Tom Moreau wrote:[vbcol=seagreen]
>What happens if you set the min server memory and restart SQL Server?
>Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
>Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on
>Windows
>NT 5.2 (Build 3790: Service Pack 1)
>Tom Moreau wrote:
>[quoted text clipped - 7 lines]
Message posted via http://www.droptable.com
|||This is the 'expected behavior' of 8.00.2039 and is fixed in 8.00.2040. See
http://support.microsoft.com/default...b;en-us;899761
Linchi
"cbrichards via droptable.com" wrote:
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> NT 5.2 (Build 3790: Service Pack 1)
>
> Tom Moreau wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200609/1
>
This is the script we used to enable AWE and set Max Memory, essentially
leaving 2GB for the OS.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
set.
The question I have, is what I am seeing for Target and Total Server Memory:
Target Server Memory(KB) = 4087767
Total Server Memory(KB) = 4087747
I was expecting to see more Target Server Memory being used (closer to 6GB)
rather than only 4087767KB / 3.898GB.
Please explain.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200609/1
What version of SQL Server are you using?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:663faf808d6ce@.uwe...
Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
This is the script we used to enable AWE and set Max Memory, essentially
leaving 2GB for the OS.
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
set.
The question I have, is what I am seeing for Target and Total Server Memory:
Target Server Memory(KB) = 4087767
Total Server Memory(KB) = 4087747
I was expecting to see more Target Server Memory being used (closer to 6GB)
rather than only 4087767KB / 3.898GB.
Please explain.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200609/1
|||SQL 2000
Tom Moreau wrote:
>What version of SQL Server are you using?
>Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
>This is the script we used to enable AWE and set Max Memory, essentially
>leaving 2GB for the OS.
>sp_configure 'show advanced options', 1
>RECONFIGURE
>GO
>sp_configure 'awe enabled', 1
>RECONFIGURE
>GO
>sp_configure 'max server memory', 6144
>RECONFIGURE
>GO
>Just so you are aware, we do have the boot.ini with the PAE and 3GB switches
>set.
>The question I have, is what I am seeing for Target and Total Server Memory:
>Target Server Memory(KB) = 4087767
>Total Server Memory(KB) = 4087747
>I was expecting to see more Target Server Memory being used (closer to 6GB)
>rather than only 4087767KB / 3.898GB.
>Please explain.
Message posted via http://www.droptable.com
|||Which SP level? What's the result of running:
SELECT @.@.VERSION
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:663fdb867f662@.uwe...
SQL 2000
Tom Moreau wrote:
>What version of SQL Server are you using?
>Prior to enabling AWE, we had 8GB RAM but utilizing only 2.7GB.
>This is the script we used to enable AWE and set Max Memory, essentially
>leaving 2GB for the OS.
>sp_configure 'show advanced options', 1
>RECONFIGURE
>GO
>sp_configure 'awe enabled', 1
>RECONFIGURE
>GO
>sp_configure 'max server memory', 6144
>RECONFIGURE
>GO
>Just so you are aware, we do have the boot.ini with the PAE and 3GB
>switches
>set.
>The question I have, is what I am seeing for Target and Total Server
>Memory:
>Target Server Memory(KB) = 4087767
>Total Server Memory(KB) = 4087747
>I was expecting to see more Target Server Memory being used (closer to 6GB)
>rather than only 4087767KB / 3.898GB.
>Please explain.
Message posted via http://www.droptable.com
|||Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
Tom Moreau wrote:[vbcol=seagreen]
>Which SP level? What's the result of running:
>SELECT @.@.VERSION
>SQL 2000
>Tom Moreau wrote:
>[quoted text clipped - 27 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200609/1
|||What happens if you set the min server memory and restart SQL Server?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:664097d00a0ed@.uwe...
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
Tom Moreau wrote:[vbcol=seagreen]
>Which SP level? What's the result of running:
>SELECT @.@.VERSION
>SQL 2000
>Tom Moreau wrote:
>[quoted text clipped - 27 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200609/1
|||I am away from the office and will not have access to the server until
tomorrow around 10:00 MST. Even then we will not be able to restart the
service until late tomorrow evening. Do you have a theory about setting "min
server memory"? I believe I recall on the "max server memory" the minimum is
set to 4. Anyway, just trying to follow your thought process on why the "min
server memory" might be inhibiting memory use.
Tom Moreau wrote:[vbcol=seagreen]
>What happens if you set the min server memory and restart SQL Server?
>Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
>Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
>NT 5.2 (Build 3790: Service Pack 1)
>Tom Moreau wrote:
>[quoted text clipped - 7 lines]
Message posted via http://www.droptable.com
|||In SQL 2005, server memory will gradually climb to the max server memory,
whether or not you're using AWE. In SQL 2000, it's supposed to take it in
one chunk, IIRC. I'm thinking that if max = min = whatever you really want,
then you may be forcing it up to that level straight away.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"cbrichards via droptable.com" <u3288@.uwe> wrote in message
news:6641520a8602d@.uwe...
I am away from the office and will not have access to the server until
tomorrow around 10:00 MST. Even then we will not be able to restart the
service until late tomorrow evening. Do you have a theory about setting "min
server memory"? I believe I recall on the "max server memory" the minimum is
set to 4. Anyway, just trying to follow your thought process on why the "min
server memory" might be inhibiting memory use.
Tom Moreau wrote:[vbcol=seagreen]
>What happens if you set the min server memory and restart SQL Server?
>Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
>Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on
>Windows
>NT 5.2 (Build 3790: Service Pack 1)
>Tom Moreau wrote:
>[quoted text clipped - 7 lines]
Message posted via http://www.droptable.com
|||This is the 'expected behavior' of 8.00.2039 and is fixed in 8.00.2040. See
http://support.microsoft.com/default...b;en-us;899761
Linchi
"cbrichards via droptable.com" wrote:
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows
> NT 5.2 (Build 3790: Service Pack 1)
>
> Tom Moreau wrote:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200609/1
>
Saturday, February 25, 2012
Avoiding the usage of DTC
Hello
I am running an script and the following sentence throws and error because the DTC service is not running in the Remote Server:
insert into MyLocalTable
execute synonym_MyRemoteProcedure @.SomeParameter
Since a transaction is not declared within the script, why is the DTC required?
How can I avoid the usage of the DTC? Is there a way to say "this code is not within a distributed transaction"?
Thanks a lot.You are still in an explicit transaction. As far as I know, the requirement that the DTC service be running can not be bypassed. You can try using just a select statement to get the data from the remote server, as the "black box" nature of the stored procedure may be causing this.
I am running an script and the following sentence throws and error because the DTC service is not running in the Remote Server:
insert into MyLocalTable
execute synonym_MyRemoteProcedure @.SomeParameter
Since a transaction is not declared within the script, why is the DTC required?
How can I avoid the usage of the DTC? Is there a way to say "this code is not within a distributed transaction"?
Thanks a lot.You are still in an explicit transaction. As far as I know, the requirement that the DTC service be running can not be bypassed. You can try using just a select statement to get the data from the remote server, as the "black box" nature of the stored procedure may be causing this.
Friday, February 24, 2012
avoid warning
We use a script in our build process to create a database. A single
script creates entire database, including stored procedures. We
occasionally
get a warning message "cannot create entry in sysdepends as .....
the procedure will still be created". I believe this is a harmless
warning
and happens because of the order of creation of stord procedure. Is
there a way to disable this warning.
See "set ansi_warnings" in BOL.
use northwind
go
set ansi_warnings off
go
create procedure proc1
as
select * from t1
go
set ansi_warnings on
go
drop procedure proc1
go
AMB
"Data Cruncher" wrote:
> We use a script in our build process to create a database. A single
> script creates entire database, including stored procedures. We
> occasionally
> get a warning message "cannot create entry in sysdepends as .....
> the procedure will still be created". I believe this is a harmless
> warning
> and happens because of the order of creation of stord procedure. Is
> there a way to disable this warning.
>
|||Sorry,
It seems that this option does not help.
AMB
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See "set ansi_warnings" in BOL.
> use northwind
> go
> set ansi_warnings off
> go
> create procedure proc1
> as
> select * from t1
> go
> set ansi_warnings on
> go
> drop procedure proc1
> go
>
> AMB
> "Data Cruncher" wrote:
|||I don't think there's a way to shut off the warning outside of
creating your script with sub procs being compiled before the
calling procs.
For all intents and purposes, it's harmless for the reason
you stated. Of course, it's not harmless if the main procedure,
in fact, doesn't get created!
"Data Cruncher" <dcruncher4@.netscape.net> wrote in message
news:1116249702.395329.63480@.g47g2000cwa.googlegro ups.com...
> We use a script in our build process to create a database. A single
> script creates entire database, including stored procedures. We
> occasionally
> get a warning message "cannot create entry in sysdepends as .....
> the procedure will still be created". I believe this is a harmless
> warning
> and happens because of the order of creation of stord procedure. Is
> there a way to disable this warning.
>
script creates entire database, including stored procedures. We
occasionally
get a warning message "cannot create entry in sysdepends as .....
the procedure will still be created". I believe this is a harmless
warning
and happens because of the order of creation of stord procedure. Is
there a way to disable this warning.
See "set ansi_warnings" in BOL.
use northwind
go
set ansi_warnings off
go
create procedure proc1
as
select * from t1
go
set ansi_warnings on
go
drop procedure proc1
go
AMB
"Data Cruncher" wrote:
> We use a script in our build process to create a database. A single
> script creates entire database, including stored procedures. We
> occasionally
> get a warning message "cannot create entry in sysdepends as .....
> the procedure will still be created". I believe this is a harmless
> warning
> and happens because of the order of creation of stord procedure. Is
> there a way to disable this warning.
>
|||Sorry,
It seems that this option does not help.
AMB
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See "set ansi_warnings" in BOL.
> use northwind
> go
> set ansi_warnings off
> go
> create procedure proc1
> as
> select * from t1
> go
> set ansi_warnings on
> go
> drop procedure proc1
> go
>
> AMB
> "Data Cruncher" wrote:
|||I don't think there's a way to shut off the warning outside of
creating your script with sub procs being compiled before the
calling procs.
For all intents and purposes, it's harmless for the reason
you stated. Of course, it's not harmless if the main procedure,
in fact, doesn't get created!
"Data Cruncher" <dcruncher4@.netscape.net> wrote in message
news:1116249702.395329.63480@.g47g2000cwa.googlegro ups.com...
> We use a script in our build process to create a database. A single
> script creates entire database, including stored procedures. We
> occasionally
> get a warning message "cannot create entry in sysdepends as .....
> the procedure will still be created". I believe this is a harmless
> warning
> and happens because of the order of creation of stord procedure. Is
> there a way to disable this warning.
>
avoid warning
We use a script in our build process to create a database. A single
script creates entire database, including stored procedures. We
occasionally
get a warning message "cannot create entry in sysdepends as .....
the procedure will still be created". I believe this is a harmless
warning
and happens because of the order of creation of stord procedure. Is
there a way to disable this warning.See "set ansi_warnings" in BOL.
use northwind
go
set ansi_warnings off
go
create procedure proc1
as
select * from t1
go
set ansi_warnings on
go
drop procedure proc1
go
AMB
"Data Cruncher" wrote:
> We use a script in our build process to create a database. A single
> script creates entire database, including stored procedures. We
> occasionally
> get a warning message "cannot create entry in sysdepends as .....
> the procedure will still be created". I believe this is a harmless
> warning
> and happens because of the order of creation of stord procedure. Is
> there a way to disable this warning.
>|||Sorry,
It seems that this option does not help.
AMB
"Alejandro Mesa" wrote:
> See "set ansi_warnings" in BOL.
> use northwind
> go
> set ansi_warnings off
> go
> create procedure proc1
> as
> select * from t1
> go
> set ansi_warnings on
> go
> drop procedure proc1
> go
>
> AMB
> "Data Cruncher" wrote:
> > We use a script in our build process to create a database. A single
> > script creates entire database, including stored procedures. We
> > occasionally
> > get a warning message "cannot create entry in sysdepends as .....
> > the procedure will still be created". I believe this is a harmless
> > warning
> > and happens because of the order of creation of stord procedure. Is
> > there a way to disable this warning.
> >
> >|||I don't think there's a way to shut off the warning outside of
creating your script with sub procs being compiled before the
calling procs.
For all intents and purposes, it's harmless for the reason
you stated. Of course, it's not harmless if the main procedure,
in fact, doesn't get created!
"Data Cruncher" <dcruncher4@.netscape.net> wrote in message
news:1116249702.395329.63480@.g47g2000cwa.googlegroups.com...
> We use a script in our build process to create a database. A single
> script creates entire database, including stored procedures. We
> occasionally
> get a warning message "cannot create entry in sysdepends as .....
> the procedure will still be created". I believe this is a harmless
> warning
> and happens because of the order of creation of stord procedure. Is
> there a way to disable this warning.
>
script creates entire database, including stored procedures. We
occasionally
get a warning message "cannot create entry in sysdepends as .....
the procedure will still be created". I believe this is a harmless
warning
and happens because of the order of creation of stord procedure. Is
there a way to disable this warning.See "set ansi_warnings" in BOL.
use northwind
go
set ansi_warnings off
go
create procedure proc1
as
select * from t1
go
set ansi_warnings on
go
drop procedure proc1
go
AMB
"Data Cruncher" wrote:
> We use a script in our build process to create a database. A single
> script creates entire database, including stored procedures. We
> occasionally
> get a warning message "cannot create entry in sysdepends as .....
> the procedure will still be created". I believe this is a harmless
> warning
> and happens because of the order of creation of stord procedure. Is
> there a way to disable this warning.
>|||Sorry,
It seems that this option does not help.
AMB
"Alejandro Mesa" wrote:
> See "set ansi_warnings" in BOL.
> use northwind
> go
> set ansi_warnings off
> go
> create procedure proc1
> as
> select * from t1
> go
> set ansi_warnings on
> go
> drop procedure proc1
> go
>
> AMB
> "Data Cruncher" wrote:
> > We use a script in our build process to create a database. A single
> > script creates entire database, including stored procedures. We
> > occasionally
> > get a warning message "cannot create entry in sysdepends as .....
> > the procedure will still be created". I believe this is a harmless
> > warning
> > and happens because of the order of creation of stord procedure. Is
> > there a way to disable this warning.
> >
> >|||I don't think there's a way to shut off the warning outside of
creating your script with sub procs being compiled before the
calling procs.
For all intents and purposes, it's harmless for the reason
you stated. Of course, it's not harmless if the main procedure,
in fact, doesn't get created!
"Data Cruncher" <dcruncher4@.netscape.net> wrote in message
news:1116249702.395329.63480@.g47g2000cwa.googlegroups.com...
> We use a script in our build process to create a database. A single
> script creates entire database, including stored procedures. We
> occasionally
> get a warning message "cannot create entry in sysdepends as .....
> the procedure will still be created". I believe this is a harmless
> warning
> and happens because of the order of creation of stord procedure. Is
> there a way to disable this warning.
>
avoid warning
We use a script in our build process to create a database. A single
script creates entire database, including stored procedures. We
occasionally
get a warning message "cannot create entry in sysdepends as .....
the procedure will still be created". I believe this is a harmless
warning
and happens because of the order of creation of stord procedure. Is
there a way to disable this warning.See "set ansi_warnings" in BOL.
use northwind
go
set ansi_warnings off
go
create procedure proc1
as
select * from t1
go
set ansi_warnings on
go
drop procedure proc1
go
AMB
"Data Cruncher" wrote:
> We use a script in our build process to create a database. A single
> script creates entire database, including stored procedures. We
> occasionally
> get a warning message "cannot create entry in sysdepends as .....
> the procedure will still be created". I believe this is a harmless
> warning
> and happens because of the order of creation of stord procedure. Is
> there a way to disable this warning.
>|||Sorry,
It seems that this option does not help.
AMB
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See "set ansi_warnings" in BOL.
> use northwind
> go
> set ansi_warnings off
> go
> create procedure proc1
> as
> select * from t1
> go
> set ansi_warnings on
> go
> drop procedure proc1
> go
>
> AMB
> "Data Cruncher" wrote:
>|||I don't think there's a way to shut off the warning outside of
creating your script with sub procs being compiled before the
calling procs.
For all intents and purposes, it's harmless for the reason
you stated. Of course, it's not harmless if the main procedure,
in fact, doesn't get created!
"Data Cruncher" <dcruncher4@.netscape.net> wrote in message
news:1116249702.395329.63480@.g47g2000cwa.googlegroups.com...
> We use a script in our build process to create a database. A single
> script creates entire database, including stored procedures. We
> occasionally
> get a warning message "cannot create entry in sysdepends as .....
> the procedure will still be created". I believe this is a harmless
> warning
> and happens because of the order of creation of stord procedure. Is
> there a way to disable this warning.
>
script creates entire database, including stored procedures. We
occasionally
get a warning message "cannot create entry in sysdepends as .....
the procedure will still be created". I believe this is a harmless
warning
and happens because of the order of creation of stord procedure. Is
there a way to disable this warning.See "set ansi_warnings" in BOL.
use northwind
go
set ansi_warnings off
go
create procedure proc1
as
select * from t1
go
set ansi_warnings on
go
drop procedure proc1
go
AMB
"Data Cruncher" wrote:
> We use a script in our build process to create a database. A single
> script creates entire database, including stored procedures. We
> occasionally
> get a warning message "cannot create entry in sysdepends as .....
> the procedure will still be created". I believe this is a harmless
> warning
> and happens because of the order of creation of stord procedure. Is
> there a way to disable this warning.
>|||Sorry,
It seems that this option does not help.
AMB
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See "set ansi_warnings" in BOL.
> use northwind
> go
> set ansi_warnings off
> go
> create procedure proc1
> as
> select * from t1
> go
> set ansi_warnings on
> go
> drop procedure proc1
> go
>
> AMB
> "Data Cruncher" wrote:
>|||I don't think there's a way to shut off the warning outside of
creating your script with sub procs being compiled before the
calling procs.
For all intents and purposes, it's harmless for the reason
you stated. Of course, it's not harmless if the main procedure,
in fact, doesn't get created!
"Data Cruncher" <dcruncher4@.netscape.net> wrote in message
news:1116249702.395329.63480@.g47g2000cwa.googlegroups.com...
> We use a script in our build process to create a database. A single
> script creates entire database, including stored procedures. We
> occasionally
> get a warning message "cannot create entry in sysdepends as .....
> the procedure will still be created". I believe this is a harmless
> warning
> and happens because of the order of creation of stord procedure. Is
> there a way to disable this warning.
>
Thursday, February 16, 2012
Average Value Script
The table listed below is sampled every minute with a [CounterDateTime]
[char] (24) format.
I would like to create a script that will average the MarketValue,
FirstMarketValueA, and MarketCount fields in hourly format using the same
counterIDs.
Please help me create a script for average values.
Thanks,
CREATE TABLE [dbo].[Market_Jun2005] (
[MarketID] [int] NOT NULL ,
[RecordIndex] [int] NOT NULL ,
[CounterDateTime] [char] (24) NOT NULL ,
[MarketValue] [float] NOT NULL ,
[FirstMarketValueA] [int] NULL ,
[MarketCount] [int] NULL
)On Tue, 9 Aug 2005 14:35:44 -0700, Joe K. <Joe
K.@.discussions.microsoft.com> wrote:
>The table listed below is sampled every minute with a [CounterDateTime]
>[char] (24) format.
>I would like to create a script that will average the MarketValue,
>FirstMarketValueA, and MarketCount fields in hourly format using the same
>counterIDs.
>Please help me create a script for average values.
Hi Joe,
First, change your CounterDateTime column to datatype datetime.
After that, you can use this query:
SELECT MarketID,
DATEADD(hour,
DATEDIFF(hour, '20040101', CounterDateTime),
'20040101') AS Hour,
AVG (MarketValue) AS AvgMarketValue,
AVG (FirstMarketValueA) AS AvgFirstMarketValueA,
AVG (MarketCount) AS AvgMarketCount
FROM Market)Jun2005
GROUP BY MarketIT,
DATEADD(hour,
DATEDIFF(hour, '20040101', CounterDateTime),
'20040101')
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
[char] (24) format.
I would like to create a script that will average the MarketValue,
FirstMarketValueA, and MarketCount fields in hourly format using the same
counterIDs.
Please help me create a script for average values.
Thanks,
CREATE TABLE [dbo].[Market_Jun2005] (
[MarketID] [int] NOT NULL ,
[RecordIndex] [int] NOT NULL ,
[CounterDateTime] [char] (24) NOT NULL ,
[MarketValue] [float] NOT NULL ,
[FirstMarketValueA] [int] NULL ,
[MarketCount] [int] NULL
)On Tue, 9 Aug 2005 14:35:44 -0700, Joe K. <Joe
K.@.discussions.microsoft.com> wrote:
>The table listed below is sampled every minute with a [CounterDateTime]
>[char] (24) format.
>I would like to create a script that will average the MarketValue,
>FirstMarketValueA, and MarketCount fields in hourly format using the same
>counterIDs.
>Please help me create a script for average values.
Hi Joe,
First, change your CounterDateTime column to datatype datetime.
After that, you can use this query:
SELECT MarketID,
DATEADD(hour,
DATEDIFF(hour, '20040101', CounterDateTime),
'20040101') AS Hour,
AVG (MarketValue) AS AvgMarketValue,
AVG (FirstMarketValueA) AS AvgFirstMarketValueA,
AVG (MarketCount) AS AvgMarketCount
FROM Market)Jun2005
GROUP BY MarketIT,
DATEADD(hour,
DATEDIFF(hour, '20040101', CounterDateTime),
'20040101')
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Subscribe to:
Posts (Atom)