Database Snapshot on SAN attached disks

Hi All

I am in process of moving a SQL 2005 solution from a development box that used local storage to UAT environment with SAN attached storage. The solution uses database snapshots

The database files are on the SAN storage but during testing I was unable to create a Database snapshot on the SAN disk. Creating snapshots on the local disk worked fine.

Is their some restriction/problem in using the database snapshot technology with SAN storage?

What edition of Sql server 2005 you have ? Database snapshot is possible only with Enterprise edition I believe
|||

SQL Server Enterprise 2005 SP2 is being used on all systems.

The snapshots are working against the local disks on the server but not against the SAN attached storage.

Regards

Nadreck

|||

Are the SAN attached drives formatted using the NTFS file system? Database Snapshots use NTFS Sparse Files for the underlying technology, and will not work under any other file system.

I have database snapshots on production clustered servers, using SAN storage, and haven't had any problems.

|||Your use of the term "SAN attached" has me wondering. There are Network Attached Storage (NAS) devices that often have their own proprietary file system and then there are Storage Area Networks (SAN) which are usually NTFS in the Windows world. Which type of storage are you referring to? Database snapshots require NTFS.
|||There is no difference between a "SAN" and a local drive to SQL, they both look like local drives. This must be a security issue on the directory.

If you are talking about a "NAS" drive, as in you access it using "\\servername\share", SQL does not support putting data/transaction files on share drives.

|||

The storage is on a true SAN with the disks attached by Fibre Channel and being presented as Local disk.

I have spoken with the SAN administrators and they have confirmed that the disks are formatted as NTFS

The error received when trying to create the sbnapshot was

Msg 1823, Level 16, State 2, Line 1

A database snapshot cannot be created because it failed to start.

Msg 5123, Level 16, State 1, Line 1

CREATE FILE encountered operating system error 5(error not found) while attempting to open or create the physical file 'filename'.

|||I think the login with which you have logged into Sql server(windows authentication) might not be having modify privilege to the folder where the Sparse file is being created ! also check if the sql service account has necessary privileges to that folder ! ! !

Thanxx
Deepak


|||

The logon accounts and service accounts both have local admin rights on the box so write permissions do not appear to be the issue. The mdf and ldf files for the database are both on SAN storage so SQL appears to have sufficient rights to write to these disks. Creating snapshots on local disk (with the same accounts) has no issue.

Obviously it may still be some permissions issue with the SAN but I cannot see any difference.

regards

Nadreck

Database sizes explanation Please?

Hi All
I have been developing in MS SQL Server 2000 for about 8 months now so I
would consider my self to be really new to this Database.
As I am lacking in long term experience I really have no idea about the
sizes that MS SQL is capable of.
My database started at 0 in size I would say 3 months ago and is now 5007.19
MB in size I think. I don't know how to check this 100 percent because I am
a developer I have not done much MS SQL admin.
My problem is that the database will continue to grow at about this speed
potentially for ever.
There is about 10 users of my application and they are constantly inserting
new data, and the idea is that when they get better at using the application
they will be imputing the data even faster so the volume should increase but
I don't know by how much.
So First question is.
How can I keep track of the database growth properly?
When do I need to start being concerned about the size of this database?
And what are the options available to me when the database gets really
large?
Many thanks
Ian
See inline...
and good luck Ian... you are asking the right questions in the right place!.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ian" <ian@.NoWhere.com> wrote in message
news:%23cXJW9izEHA.3376@.TK2MSFTNGP12.phx.gbl...
> Hi All
> I have been developing in MS SQL Server 2000 for about 8 months now so I
> would consider my self to be really new to this Database.
> As I am lacking in long term experience I really have no idea about the
> sizes that MS SQL is capable of.
> My database started at 0 in size I would say 3 months ago and is now
5007.19
> MB in size I think. I don't know how to check this 100 percent because I
am
> a developer I have not done much MS SQL admin.
> My problem is that the database will continue to grow at about this speed
> potentially for ever.
> There is about 10 users of my application and they are constantly
inserting
> new data, and the idea is that when they get better at using the
application
> they will be imputing the data even faster so the volume should increase
but
> I don't know by how much.
> So First question is.
> How can I keep track of the database growth properly?
sp_spaceused or
sp_spaceused @.updateusage=true
You may also use SQL Agent to create an alert based on the data file size.
> When do I need to start being concerned about the size of this database?
You should always be aware of the size... SQL Server can handle very large
databases is designed and maintined properly, even in the several Terabyte
range...
One of the things which might be causing your db to grow quickly is the
transaction log... IF your database is in FUll Recovery mode AND you have
not been backing up the transaction log, then the log will contain every
change you have ever made to the database... Take a look at the log size
relative to the data file sizes... You may need to start backing up the
log... ( and perhaps shrink the log ( DBCC SHRINKFILE) if it has grown large
due to neglect)
> And what are the options available to me when the database gets really
> large?
Good Maintenance, Faster/better IO subsystem, more memory, separating
historical data from current OLTP data, etc.

>
> Many thanks
> Ian
>
>
>
>
>
>
|||Thanks Wayne
Would you consider my database to be a fast growing?
Is there some where that I can read about this "FUll Recovery mode" and how
to change it?
Ian
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OiufmPjzEHA.4004@.tk2msftngp13.phx.gbl...
> See inline...
> and good luck Ian... you are asking the right questions in the right
place!.[vbcol=seagreen]
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Ian" <ian@.NoWhere.com> wrote in message
> news:%23cXJW9izEHA.3376@.TK2MSFTNGP12.phx.gbl...
> 5007.19
> am
speed
> inserting
> application
> but
> sp_spaceused or
> sp_spaceused @.updateusage=true
> You may also use SQL Agent to create an alert based on the data file size.
> You should always be aware of the size... SQL Server can handle very large
> databases is designed and maintined properly, even in the several Terabyte
> range...
> One of the things which might be causing your db to grow quickly is the
> transaction log... IF your database is in FUll Recovery mode AND you have
> not been backing up the transaction log, then the log will contain every
> change you have ever made to the database... Take a look at the log size
> relative to the data file sizes... You may need to start backing up the
> log... ( and perhaps shrink the log ( DBCC SHRINKFILE) if it has grown
large
> due to neglect)
> Good Maintenance, Faster/better IO subsystem, more memory, separating
> historical data from current OLTP data, etc.
>
>

Database sizes explanation Please?

Hi All
I have been developing in MS SQL Server 2000 for about 8 months now so I
would consider my self to be really new to this Database.
As I am lacking in long term experience I really have no idea about the
sizes that MS SQL is capable of.
My database started at 0 in size I would say 3 months ago and is now 5007.19
MB in size I think. I don't know how to check this 100 percent because I am
a developer I have not done much MS SQL admin.
My problem is that the database will continue to grow at about this speed
potentially for ever.
There is about 10 users of my application and they are constantly inserting
new data, and the idea is that when they get better at using the application
they will be imputing the data even faster so the volume should increase but
I don't know by how much.
So First question is.
How can I keep track of the database growth properly?
When do I need to start being concerned about the size of this database?
And what are the options available to me when the database gets really
large?
Many thanks
IanSee inline...
and good luck Ian... you are asking the right questions in the right place!.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ian" <ian@.NoWhere.com> wrote in message
news:%23cXJW9izEHA.3376@.TK2MSFTNGP12.phx.gbl...
> Hi All
> I have been developing in MS SQL Server 2000 for about 8 months now so I
> would consider my self to be really new to this Database.
> As I am lacking in long term experience I really have no idea about the
> sizes that MS SQL is capable of.
> My database started at 0 in size I would say 3 months ago and is now
5007.19
> MB in size I think. I don't know how to check this 100 percent because I
am
> a developer I have not done much MS SQL admin.
> My problem is that the database will continue to grow at about this speed
> potentially for ever.
> There is about 10 users of my application and they are constantly
inserting
> new data, and the idea is that when they get better at using the
application
> they will be imputing the data even faster so the volume should increase
but
> I don't know by how much.
> So First question is.
> How can I keep track of the database growth properly?
sp_spaceused or
sp_spaceused @.updateusage=true
You may also use SQL Agent to create an alert based on the data file size.
> When do I need to start being concerned about the size of this database?
You should always be aware of the size... SQL Server can handle very large
databases is designed and maintined properly, even in the several Terabyte
range...
One of the things which might be causing your db to grow quickly is the
transaction log... IF your database is in FUll Recovery mode AND you have
not been backing up the transaction log, then the log will contain every
change you have ever made to the database... Take a look at the log size
relative to the data file sizes... You may need to start backing up the
log... ( and perhaps shrink the log ( DBCC SHRINKFILE) if it has grown large
due to neglect)
> And what are the options available to me when the database gets really
> large?
Good Maintenance, Faster/better IO subsystem, more memory, separating
historical data from current OLTP data, etc.

>
> Many thanks
> Ian
>
>
>
>
>
>|||Thanks Wayne
Would you consider my database to be a fast growing?
Is there some where that I can read about this "FUll Recovery mode" and how
to change it?
Ian
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OiufmPjzEHA.4004@.tk2msftngp13.phx.gbl...
> See inline...
> and good luck Ian... you are asking the right questions in the right
place!.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Ian" <ian@.NoWhere.com> wrote in message
> news:%23cXJW9izEHA.3376@.TK2MSFTNGP12.phx.gbl...
> 5007.19
> am
speed[vbcol=seagreen]
> inserting
> application
> but
> sp_spaceused or
> sp_spaceused @.updateusage=true
> You may also use SQL Agent to create an alert based on the data file size.
> You should always be aware of the size... SQL Server can handle very large
> databases is designed and maintined properly, even in the several Terabyte
> range...
> One of the things which might be causing your db to grow quickly is the
> transaction log... IF your database is in FUll Recovery mode AND you have
> not been backing up the transaction log, then the log will contain every
> change you have ever made to the database... Take a look at the log size
> relative to the data file sizes... You may need to start backing up the
> log... ( and perhaps shrink the log ( DBCC SHRINKFILE) if it has grown
large
> due to neglect)
> Good Maintenance, Faster/better IO subsystem, more memory, separating
> historical data from current OLTP data, etc.
>
>

database size

Dear all
I have a SQL abc database. Recently, I right click database properity,the
space avaliable is zero, but i see the database file size and transcation lo
g
has some free space. Why the space avaliable is zero in that case and have
any impact about this database?
thanksVerify that your database has the 'Automatic grow file' property checked in
both your data and transaction log files.
If it is not enabled, you have some choices, like expanding the size of your
files manually, or enabling automatic grow file. Perhaps you want to go with
the default of 10 percent.
Ben Nevarez, MCDBA, OCP
"123" <123@.discussions.microsoft.com> wrote in message
news:518D80E7-98FF-4729-9BB4-A6DA6ACFAD90@.microsoft.com...
> Dear all
> I have a SQL abc database. Recently, I right click database properity,the
> space avaliable is zero, but i see the database file size and transcation
> log
> has some free space. Why the space avaliable is zero in that case and have
> any impact about this database?
> thanks
>|||Check the fragmentation of your tables. If you haven't already it may be
best to set up a database maintenance plan to reorganise your data and index
pages. The frequency you do this depends on the workload of your server.
"123" wrote:

> Dear all
> I have a SQL abc database. Recently, I right click database properity,the
> space avaliable is zero, but i see the database file size and transcation
log
> has some free space. Why the space avaliable is zero in that case and have
> any impact about this database?
> thanks
>

database size

Dear all
I have a SQL abc database. Recently, I right click database properity,the
space avaliable is zero, but i see the database file size and transcation log
has some free space. Why the space avaliable is zero in that case and have
any impact about this database?
thanks
Verify that your database has the 'Automatic grow file' property checked in
both your data and transaction log files.
If it is not enabled, you have some choices, like expanding the size of your
files manually, or enabling automatic grow file. Perhaps you want to go with
the default of 10 percent.
Ben Nevarez, MCDBA, OCP
"123" <123@.discussions.microsoft.com> wrote in message
news:518D80E7-98FF-4729-9BB4-A6DA6ACFAD90@.microsoft.com...
> Dear all
> I have a SQL abc database. Recently, I right click database properity,the
> space avaliable is zero, but i see the database file size and transcation
> log
> has some free space. Why the space avaliable is zero in that case and have
> any impact about this database?
> thanks
>
|||Check the fragmentation of your tables. If you haven't already it may be
best to set up a database maintenance plan to reorganise your data and index
pages. The frequency you do this depends on the workload of your server.
"123" wrote:

> Dear all
> I have a SQL abc database. Recently, I right click database properity,the
> space avaliable is zero, but i see the database file size and transcation log
> has some free space. Why the space avaliable is zero in that case and have
> any impact about this database?
> thanks
>

database return issue

Hello all!

I have a stored procedure that I want to return a value to a C# varaiable:

Code:

public decimal GetSiloLevelForDate(string plantId, DateTime date)
{
 decimal total = 0.0M;
 Open();
 SqlCommand cmd = new SqlCommand("getSiloLevelForDate", DbConn);
 cmd.CommandType = CommandType.StoredProcedure;
 cmd.Parameters.Add("@.plantId", plantId);
 cmd.Parameters.Add("@.date", date);
 SqlDataReader reader = cmd.ExecuteReader();
 if (reader.Read())
 {
 if (!reader.IsDBNull(0))
 total = reader.GetDecimal(0);
 }
 reader.Close();
 Close();
 return total;
}

this would normally work just fine. However, it is not becuase the actual SP's end statement is:

return (select @.tempTotal)

which should return a value. But it doesnt... if I run this SQL query:

declare @.usedTonnes numeric(13,2)
exec @.usedTonnes = dbo.getSiloLevelForDate ' 11', @.date

@.usedTonnes is a value, its 7096...

So why doesnt the C# return a value?

(so, the reader is not reading anything)Return values from stored procedures are typically used to indicatesuccess or failure, not to communicate data. A resultset or anoutput parameter is better/typically suited for this task.

The way I see it, you have 3 options:

1. Change your C# code
The way to access the return value is via a parameter with ParameterDirection = ReturnValue. You should beperforming an ExecuteNonQuery, and capturing this parameter. The datareader is overkill for what you are doing.

2. Change your stored procedure
instead of :
return (select @.tempTotal)
use:
select @.tempTotal
return
This would allow you to continue to use the datareader.

3. Change your C# code AND your stored procedure code
The way I'd suggest would be to change @.usedTonnes to an outputparameter in your stored procedure instead of a variable. In yourcode, you should beperforming an ExecuteNonQuery, and capturing this outputparameter with a parameter whose ParameterDirection = Output.

SeeInput and Output Parameters, and Return Values for more background information.|||

return(SELECT @.tempTotal) isn't correct.

The return from a stored procedure is a int. You are trying to passback a resultset through the return statement.

In addition your code is looking for a resultset not passed back from return.

Change your stored proc to end in:

SELECT @.tempTotal

return

and you won't have to change your C# code.

|||thanks for the tips guys. I did use the direction method to solve the issue:

SqlCommand cmd = new SqlCommand("getSiloLevelForDate", DbConn);
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@.plantId", plantId);
cmd.Parameters.Add("@.date", date);

SqlParameter param = cmd.Parameters.Add("@.tempTotal", SqlDbType.Decimal);
param.Direction = ParameterDirection.ReturnValue;

cmd.ExecuteNonQuery();

total = (int)param.Value;

worked fine, and the SQL was

if( @.tempTotal is not null) begin
return @.tempTotal
end
else begin
set @.tempTotal = 0
return @.tempTotal
end

and i got the correct result|||I did end up having to use the direction method of the SqlCommand object:

SqlCommand cmd = new SqlCommand("getSiloLevelForDate", DbConn);
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@.plantId", plantId);
cmd.Parameters.Add("@.date", date);

SqlParameter param = cmd.Parameters.Add("@.tempTotal", SqlDbType.Decimal);
param.Direction = ParameterDirection.ReturnValue;

cmd.ExecuteNonQuery();

total = (int)param.Value;

Database Restores; Terminates Abnormally

Hi to All!
i have data base restore problem. i have backed up data base with verify
the backup option last w now i have server crash and i have two
recent backups with me. When i restore the latest one it terminates
abnormally. when i restore the other backup it restores okay. what may
be the problem in restoring the latest backup or which optin i shuould
select in the options to restore the data sucessfully.
Thanx
*** Sent via Developersdex http://www.examnotes.net ***Hi Ghulam,
What error do you get when the restore fails ?
"Ghulam Farid" wrote:

> Hi to All!
> i have data base restore problem. i have backed up data base with verify
> the backup option last w now i have server crash and i have two
> recent backups with me. When i restore the latest one it terminates
> abnormally. when i restore the other backup it restores okay. what may
> be the problem in restoring the latest backup or which optin i shuould
> select in the options to restore the data sucessfully.
> Thanx
>
> *** Sent via Developersdex http://www.examnotes.net ***
>

Database Restore Fails

HI to All!
I have posted previously that database resotre giving me Device
Activation Error which is solved. Now it is giving me the following
error:
Server: Msg 3270, Level 16, State 1, Line 1
An internal consistency error occurred. Contact Technical Support for
assistance.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Any Help!
Thanx
Farid
*** Sent via Developersdex http://www.examnotes.net ***Hi
Maybe:
http://support.microsoft.com/defaul...kb;en-us;268481
John
"Ghulam Farid" wrote:

> HI to All!
> I have posted previously that database resotre giving me Device
> Activation Error which is solved. Now it is giving me the following
> error:
> Server: Msg 3270, Level 16, State 1, Line 1
> An internal consistency error occurred. Contact Technical Support for
> assistance.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Any Help!
> Thanx
> Farid
> *** Sent via Developersdex http://www.examnotes.net ***
>|||Hi
Run DBCC CheckDb command to see what is hoing on as well as running verify
backup upon completion just executes RESTORE VERIFYONLY
It seems that your backup a corrupted database
"Ghulam Farid" <gfaryd@.yahoo.com> wrote in message
news:Ono7oWf2FHA.3880@.TK2MSFTNGP12.phx.gbl...
> HI to All!
> I have posted previously that database resotre giving me Device
> Activation Error which is solved. Now it is giving me the following
> error:
> Server: Msg 3270, Level 16, State 1, Line 1
> An internal consistency error occurred. Contact Technical Support for
> assistance.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Any Help!
> Thanx
> Farid
> *** Sent via Developersdex http://www.examnotes.net ***

Database Restore Fails

HI to All!
I have posted previously that database resotre giving me Device
Activation Error which is solved. Now it is giving me the following
error:
Server: Msg 3270, Level 16, State 1, Line 1
An internal consistency error occurred. Contact Technical Support for
assistance.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Any Help!
Thanx
Farid
*** Sent via Developersdex http://www.codecomments.com ***
You should do what the error say. There is a problem in the backup, open a case with MS Support and
see if they can handle it. Also, if the original database is still around, use DBCC CHECKDB to see
if it has any corruptions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ghulam Farid" <gfaryd@.yahoo.com> wrote in message news:%23w63%23Zf2FHA.896@.TK2MSFTNGP09.phx.gbl...
>
> HI to All!
> I have posted previously that database resotre giving me Device
> Activation Error which is solved. Now it is giving me the following
> error:
> Server: Msg 3270, Level 16, State 1, Line 1
> An internal consistency error occurred. Contact Technical Support for
> assistance.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Any Help!
> Thanx
> Farid
>
> *** Sent via Developersdex http://www.codecomments.com ***
|||Hi,
Execute DBCC CHECKDB in the source database where you took the backup. See
if there is any errors on it.
If you do not have the source database then open a case with microsoft and
seek their help in restore
Thanks
hari
SQL Server MVP
"Ghulam Farid" <gfaryd@.yahoo.com> wrote in message
news:%23w63%23Zf2FHA.896@.TK2MSFTNGP09.phx.gbl...
>
> HI to All!
> I have posted previously that database resotre giving me Device
> Activation Error which is solved. Now it is giving me the following
> error:
> Server: Msg 3270, Level 16, State 1, Line 1
> An internal consistency error occurred. Contact Technical Support for
> assistance.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Any Help!
> Thanx
> Farid
>
> *** Sent via Developersdex http://www.codecomments.com ***

Database Restore Fails

HI to All!
I have posted previously that database resotre giving me Device
Activation Error which is solved. Now it is giving me the following
error:
Server: Msg 3270, Level 16, State 1, Line 1
An internal consistency error occurred. Contact Technical Support for
assistance.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Any Help!
Thanx
Farid
*** Sent via Developersdex http://www.codecomments.com ***You should do what the error say. There is a problem in the backup, open a c
ase with MS Support and
see if they can handle it. Also, if the original database is still around, u
se DBCC CHECKDB to see
if it has any corruptions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ghulam Farid" <gfaryd@.yahoo.com> wrote in message news:%23w63%23Zf2FHA.896@.TK2MSFTNGP09.phx
.gbl...
>
> HI to All!
> I have posted previously that database resotre giving me Device
> Activation Error which is solved. Now it is giving me the following
> error:
> Server: Msg 3270, Level 16, State 1, Line 1
> An internal consistency error occurred. Contact Technical Support for
> assistance.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Any Help!
> Thanx
> Farid
>
> *** Sent via Developersdex http://www.codecomments.com ***|||Hi,
Execute DBCC CHECKDB in the source database where you took the backup. See
if there is any errors on it.
If you do not have the source database then open a case with microsoft and
seek their help in restore
Thanks
hari
SQL Server MVP
"Ghulam Farid" <gfaryd@.yahoo.com> wrote in message
news:%23w63%23Zf2FHA.896@.TK2MSFTNGP09.phx.gbl...
>
> HI to All!
> I have posted previously that database resotre giving me Device
> Activation Error which is solved. Now it is giving me the following
> error:
> Server: Msg 3270, Level 16, State 1, Line 1
> An internal consistency error occurred. Contact Technical Support for
> assistance.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Any Help!
> Thanx
> Farid
>
> *** Sent via Developersdex http://www.codecomments.com ***

Database Problem

hello all

i am develope a travel website, in this site there is an 14 database tables

in my local machine all the work is done properly like (insert, update, delete, adminlogin , client login, etc...)

but in the internet or main server it not work properly

what is this prob.

plz help me

ashwani

what happens when you run it on the internet?

Does it give you an error Message or just not save changes to the database?

|||

it could be a connection string problem, the application cannot connect to the database, or ASP.NET account doesn't have the proper rights.