We have SQL 2000 Enterprise Edition running on Windows 2000 Server. I ran
the DBCC Shrinkdatabase command last week. Now, the database is slow when I
open one of the work orders. Do you have any recommendation on how to fix
the slowness? Am I doing something incorrectly? I ran the following
commands under Query Analyzer. Thank you.
BACKUP LOG Support_DATA WITH TRUNCATE_ONLY
GO
DBCC SHRINKDATABASE (Support_DATA, TRUNCATEONLY)Diane,
Just a guess...perhaps there is very little free space in the database and
the growth interval is small (i.e., 1MB) so the database continually grows
as new data is inserted. If this is the case, increase the size of the
database and the the growth setting. Degrading performance can also be
attributed to index fragmentation and out-of-date statistics.
HTH
Jerr
"Diane Walker" <ett9300@.yahoo.com> wrote in message
news:ek4k5hgxFHA.1132@.TK2MSFTNGP10.phx.gbl...
> We have SQL 2000 Enterprise Edition running on Windows 2000 Server. I ran
> the DBCC Shrinkdatabase command last week. Now, the database is slow when
> I open one of the work orders. Do you have any recommendation on how to
> fix the slowness? Am I doing something incorrectly? I ran the following
> commands under Query Analyzer. Thank you.
> BACKUP LOG Support_DATA WITH TRUNCATE_ONLY
> GO
> DBCC SHRINKDATABASE (Support_DATA, TRUNCATEONLY)
>|||The shrinkdatabase command isn't very useful in my opinion.
You don't have much control over which files are being
shrunk to what size. Shrinking is typically something that
you would do ad hoc and for a specific file using shrinkfile
- after a run away transaction filled up the log, a database
where the log wasn't being backed up and the size became too
large, etc. The goal should be to size the files
appropriately, do regular log back ups to keep the log size
reasonable and avoid shrinking activities.
The slowness may or may not be related to having shrunk the
database last week. When you query the table, you would want
to monitor what is going on - checking for other activity
and locking/blocking by executing sp_who2 and querying the
sysprocesses table in the master database. And you'd want to
use something other than Enterprise Manager to view data in
tables - especially if it has a lot of data. Enterprise
Manager isn't necessarily a good tool to use for viewing or
manipulating data. Use Query Analyzer instead.
-Sue
On Fri, 30 Sep 2005 14:46:53 -0700, "Diane Walker"
<ett9300@.yahoo.com> wrote:
>We have SQL 2000 Enterprise Edition running on Windows 2000 Server. I ran
>the DBCC Shrinkdatabase command last week. Now, the database is slow when I
>open one of the work orders. Do you have any recommendation on how to fix
>the slowness? Am I doing something incorrectly? I ran the following
>commands under Query Analyzer. Thank you.
>BACKUP LOG Support_DATA WITH TRUNCATE_ONLY
>GO
>DBCC SHRINKDATABASE (Support_DATA, TRUNCATEONLY)
>|||Possibly autogrow as suggested or that indexes became fragmented due to the shrink:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Diane Walker" <ett9300@.yahoo.com> wrote in message news:ek4k5hgxFHA.1132@.TK2MSFTNGP10.phx.gbl...
> We have SQL 2000 Enterprise Edition running on Windows 2000 Server. I ran the DBCC Shrinkdatabase
> command last week. Now, the database is slow when I open one of the work orders. Do you have any
> recommendation on how to fix the slowness? Am I doing something incorrectly? I ran the following
> commands under Query Analyzer. Thank you.
> BACKUP LOG Support_DATA WITH TRUNCATE_ONLY
> GO
> DBCC SHRINKDATABASE (Support_DATA, TRUNCATEONLY)
>sql
Showing posts with label windows. Show all posts
Showing posts with label windows. Show all posts
Thursday, March 29, 2012
database in load
Hello,
I am an administrator of a SQL server 2000 machine residing on a windows 2000 box. I tried restoring a database on this server from a backup file that i copied from another server. Halfway through the restore, the user comes up to me saying they did not want the database restored again. I stopped the restore process and since then it has not gone back to its previous state. Secondly it is grayed out with a (loading) text next to the database icon.
how did this happen and how do you suggest i solve this.
regards
This is because the restore process is not complete. Try dropping the database and restore the backup prior to this state as it will recreate the database.Tuesday, March 27, 2012
Database Hammer & Stress testing
Hello all
I am trying to stress test an SQL2000 server running on Windows 2003.
I am using the reskit utility database hammer.
The utility creates a table with 10,000,000 rows in it fine but when I try
to use the query/update part of the tool(procmaster.exe), it fails and I get
an error: 'Problem encountered during processing -2147217913'.
There is plenty of space in my log and data files etc.
Does anybody know what might be going on?
Thanks in advance.
Jane
PS I have also left a copy of this post in the sqlserver tools group.
Hi
Sounds something like:
http://support.microsoft.com/default...b;en-us;265166
You may want to run profiler to see where it is having problems.
John
"Jane Reynolds" <nospam@.please.com> wrote in message
news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
> Hello all
> I am trying to stress test an SQL2000 server running on Windows 2003.
> I am using the reskit utility database hammer.
> The utility creates a table with 10,000,000 rows in it fine but when I try
> to use the query/update part of the tool(procmaster.exe), it fails and I
> get an error: 'Problem encountered during processing -2147217913'.
> There is plenty of space in my log and data files etc.
> Does anybody know what might be going on?
> Thanks in advance.
> Jane
> PS I have also left a copy of this post in the sqlserver tools group.
>
|||Thanks
It looks like it is a code problem iin the utility then. I have done some
more research and found that there is a bug in the code. I don't know VB
though to try to edit it so will have to think of something else.
Jane
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23ZiKizV1EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Hi
> Sounds something like:
> http://support.microsoft.com/default...b;en-us;265166
> You may want to run profiler to see where it is having problems.
> John
> "Jane Reynolds" <nospam@.please.com> wrote in message
> news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
>
|||Hi
The article does not relate to a SQL Server back end, therefore if you did
profile this you can get the exact statement that fails and see what error
message Query Analyser would give you. If it is a datatype problem then you
may want to remove the column from the test or possibly install a different
version of MDAC.
John
"Jane Reynolds" <nospam@.please.com> wrote in message
news:OkyHRvY1EHA.2540@.TK2MSFTNGP09.phx.gbl...
> Thanks
> It looks like it is a code problem iin the utility then. I have done some
> more research and found that there is a bug in the code. I don't know VB
> though to try to edit it so will have to think of something else.
> Jane
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23ZiKizV1EHA.1404@.TK2MSFTNGP11.phx.gbl...
>
sql
I am trying to stress test an SQL2000 server running on Windows 2003.
I am using the reskit utility database hammer.
The utility creates a table with 10,000,000 rows in it fine but when I try
to use the query/update part of the tool(procmaster.exe), it fails and I get
an error: 'Problem encountered during processing -2147217913'.
There is plenty of space in my log and data files etc.
Does anybody know what might be going on?
Thanks in advance.
Jane
PS I have also left a copy of this post in the sqlserver tools group.
Hi
Sounds something like:
http://support.microsoft.com/default...b;en-us;265166
You may want to run profiler to see where it is having problems.
John
"Jane Reynolds" <nospam@.please.com> wrote in message
news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
> Hello all
> I am trying to stress test an SQL2000 server running on Windows 2003.
> I am using the reskit utility database hammer.
> The utility creates a table with 10,000,000 rows in it fine but when I try
> to use the query/update part of the tool(procmaster.exe), it fails and I
> get an error: 'Problem encountered during processing -2147217913'.
> There is plenty of space in my log and data files etc.
> Does anybody know what might be going on?
> Thanks in advance.
> Jane
> PS I have also left a copy of this post in the sqlserver tools group.
>
|||Thanks
It looks like it is a code problem iin the utility then. I have done some
more research and found that there is a bug in the code. I don't know VB
though to try to edit it so will have to think of something else.
Jane
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23ZiKizV1EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Hi
> Sounds something like:
> http://support.microsoft.com/default...b;en-us;265166
> You may want to run profiler to see where it is having problems.
> John
> "Jane Reynolds" <nospam@.please.com> wrote in message
> news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
>
|||Hi
The article does not relate to a SQL Server back end, therefore if you did
profile this you can get the exact statement that fails and see what error
message Query Analyser would give you. If it is a datatype problem then you
may want to remove the column from the test or possibly install a different
version of MDAC.
John
"Jane Reynolds" <nospam@.please.com> wrote in message
news:OkyHRvY1EHA.2540@.TK2MSFTNGP09.phx.gbl...
> Thanks
> It looks like it is a code problem iin the utility then. I have done some
> more research and found that there is a bug in the code. I don't know VB
> though to try to edit it so will have to think of something else.
> Jane
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23ZiKizV1EHA.1404@.TK2MSFTNGP11.phx.gbl...
>
sql
Database Hammer & Stress testing
Hello all
I am trying to stress test an SQL2000 server running on Windows 2003.
I am using the reskit utility database hammer.
The utility creates a table with 10,000,000 rows in it fine but when I try
to use the query/update part of the tool(procmaster.exe), it fails and I get
an error: 'Problem encountered during processing -2147217913'.
There is plenty of space in my log and data files etc.
Does anybody know what might be going on?
Thanks in advance.
Jane
PS I have also left a copy of this post in the sqlserver tools group.Hi
Sounds something like:
http://support.microsoft.com/default.aspx?scid=kb;en-us;265166
You may want to run profiler to see where it is having problems.
John
"Jane Reynolds" <nospam@.please.com> wrote in message
news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
> Hello all
> I am trying to stress test an SQL2000 server running on Windows 2003.
> I am using the reskit utility database hammer.
> The utility creates a table with 10,000,000 rows in it fine but when I try
> to use the query/update part of the tool(procmaster.exe), it fails and I
> get an error: 'Problem encountered during processing -2147217913'.
> There is plenty of space in my log and data files etc.
> Does anybody know what might be going on?
> Thanks in advance.
> Jane
> PS I have also left a copy of this post in the sqlserver tools group.
>|||Thanks
It looks like it is a code problem iin the utility then. I have done some
more research and found that there is a bug in the code. I don't know VB
though to try to edit it so will have to think of something else.
Jane
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23ZiKizV1EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Hi
> Sounds something like:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;265166
> You may want to run profiler to see where it is having problems.
> John
> "Jane Reynolds" <nospam@.please.com> wrote in message
> news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> Hello all
>> I am trying to stress test an SQL2000 server running on Windows 2003.
>> I am using the reskit utility database hammer.
>> The utility creates a table with 10,000,000 rows in it fine but when I
>> try to use the query/update part of the tool(procmaster.exe), it fails
>> and I get an error: 'Problem encountered during processing -2147217913'.
>> There is plenty of space in my log and data files etc.
>> Does anybody know what might be going on?
>> Thanks in advance.
>> Jane
>> PS I have also left a copy of this post in the sqlserver tools group.
>|||Hi
The article does not relate to a SQL Server back end, therefore if you did
profile this you can get the exact statement that fails and see what error
message Query Analyser would give you. If it is a datatype problem then you
may want to remove the column from the test or possibly install a different
version of MDAC.
John
"Jane Reynolds" <nospam@.please.com> wrote in message
news:OkyHRvY1EHA.2540@.TK2MSFTNGP09.phx.gbl...
> Thanks
> It looks like it is a code problem iin the utility then. I have done some
> more research and found that there is a bug in the code. I don't know VB
> though to try to edit it so will have to think of something else.
> Jane
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23ZiKizV1EHA.1404@.TK2MSFTNGP11.phx.gbl...
>> Hi
>> Sounds something like:
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;265166
>> You may want to run profiler to see where it is having problems.
>> John
>> "Jane Reynolds" <nospam@.please.com> wrote in message
>> news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> Hello all
>> I am trying to stress test an SQL2000 server running on Windows 2003.
>> I am using the reskit utility database hammer.
>> The utility creates a table with 10,000,000 rows in it fine but when I
>> try to use the query/update part of the tool(procmaster.exe), it fails
>> and I get an error: 'Problem encountered during processing -2147217913'.
>> There is plenty of space in my log and data files etc.
>> Does anybody know what might be going on?
>> Thanks in advance.
>> Jane
>> PS I have also left a copy of this post in the sqlserver tools group.
>>
>
I am trying to stress test an SQL2000 server running on Windows 2003.
I am using the reskit utility database hammer.
The utility creates a table with 10,000,000 rows in it fine but when I try
to use the query/update part of the tool(procmaster.exe), it fails and I get
an error: 'Problem encountered during processing -2147217913'.
There is plenty of space in my log and data files etc.
Does anybody know what might be going on?
Thanks in advance.
Jane
PS I have also left a copy of this post in the sqlserver tools group.Hi
Sounds something like:
http://support.microsoft.com/default.aspx?scid=kb;en-us;265166
You may want to run profiler to see where it is having problems.
John
"Jane Reynolds" <nospam@.please.com> wrote in message
news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
> Hello all
> I am trying to stress test an SQL2000 server running on Windows 2003.
> I am using the reskit utility database hammer.
> The utility creates a table with 10,000,000 rows in it fine but when I try
> to use the query/update part of the tool(procmaster.exe), it fails and I
> get an error: 'Problem encountered during processing -2147217913'.
> There is plenty of space in my log and data files etc.
> Does anybody know what might be going on?
> Thanks in advance.
> Jane
> PS I have also left a copy of this post in the sqlserver tools group.
>|||Thanks
It looks like it is a code problem iin the utility then. I have done some
more research and found that there is a bug in the code. I don't know VB
though to try to edit it so will have to think of something else.
Jane
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23ZiKizV1EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Hi
> Sounds something like:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;265166
> You may want to run profiler to see where it is having problems.
> John
> "Jane Reynolds" <nospam@.please.com> wrote in message
> news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> Hello all
>> I am trying to stress test an SQL2000 server running on Windows 2003.
>> I am using the reskit utility database hammer.
>> The utility creates a table with 10,000,000 rows in it fine but when I
>> try to use the query/update part of the tool(procmaster.exe), it fails
>> and I get an error: 'Problem encountered during processing -2147217913'.
>> There is plenty of space in my log and data files etc.
>> Does anybody know what might be going on?
>> Thanks in advance.
>> Jane
>> PS I have also left a copy of this post in the sqlserver tools group.
>|||Hi
The article does not relate to a SQL Server back end, therefore if you did
profile this you can get the exact statement that fails and see what error
message Query Analyser would give you. If it is a datatype problem then you
may want to remove the column from the test or possibly install a different
version of MDAC.
John
"Jane Reynolds" <nospam@.please.com> wrote in message
news:OkyHRvY1EHA.2540@.TK2MSFTNGP09.phx.gbl...
> Thanks
> It looks like it is a code problem iin the utility then. I have done some
> more research and found that there is a bug in the code. I don't know VB
> though to try to edit it so will have to think of something else.
> Jane
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23ZiKizV1EHA.1404@.TK2MSFTNGP11.phx.gbl...
>> Hi
>> Sounds something like:
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;265166
>> You may want to run profiler to see where it is having problems.
>> John
>> "Jane Reynolds" <nospam@.please.com> wrote in message
>> news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> Hello all
>> I am trying to stress test an SQL2000 server running on Windows 2003.
>> I am using the reskit utility database hammer.
>> The utility creates a table with 10,000,000 rows in it fine but when I
>> try to use the query/update part of the tool(procmaster.exe), it fails
>> and I get an error: 'Problem encountered during processing -2147217913'.
>> There is plenty of space in my log and data files etc.
>> Does anybody know what might be going on?
>> Thanks in advance.
>> Jane
>> PS I have also left a copy of this post in the sqlserver tools group.
>>
>
Database Hammer & Stress testing
Hello all
I am trying to stress test an SQL2000 server running on Windows 2003.
I am using the reskit utility database hammer.
The utility creates a table with 10,000,000 rows in it fine but when I try
to use the query/update part of the tool(procmaster.exe), it fails and I get
an error: 'Problem encountered during processing -2147217913'.
There is plenty of space in my log and data files etc.
Does anybody know what might be going on?
Thanks in advance.
Jane
PS I have also left a copy of this post in the sqlserver tools group.Hi
Sounds something like:
http://support.microsoft.com/defaul...kb;en-us;265166
You may want to run profiler to see where it is having problems.
John
"Jane Reynolds" <nospam@.please.com> wrote in message
news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
> Hello all
> I am trying to stress test an SQL2000 server running on Windows 2003.
> I am using the reskit utility database hammer.
> The utility creates a table with 10,000,000 rows in it fine but when I try
> to use the query/update part of the tool(procmaster.exe), it fails and I
> get an error: 'Problem encountered during processing -2147217913'.
> There is plenty of space in my log and data files etc.
> Does anybody know what might be going on?
> Thanks in advance.
> Jane
> PS I have also left a copy of this post in the sqlserver tools group.
>|||Thanks
It looks like it is a code problem iin the utility then. I have done some
more research and found that there is a bug in the code. I don't know VB
though to try to edit it so will have to think of something else.
Jane
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23ZiKizV1EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Hi
> Sounds something like:
> http://support.microsoft.com/defaul...kb;en-us;265166
> You may want to run profiler to see where it is having problems.
> John
> "Jane Reynolds" <nospam@.please.com> wrote in message
> news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
>|||Hi
The article does not relate to a SQL Server back end, therefore if you did
profile this you can get the exact statement that fails and see what error
message Query Analyser would give you. If it is a datatype problem then you
may want to remove the column from the test or possibly install a different
version of MDAC.
John
"Jane Reynolds" <nospam@.please.com> wrote in message
news:OkyHRvY1EHA.2540@.TK2MSFTNGP09.phx.gbl...
> Thanks
> It looks like it is a code problem iin the utility then. I have done some
> more research and found that there is a bug in the code. I don't know VB
> though to try to edit it so will have to think of something else.
> Jane
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23ZiKizV1EHA.1404@.TK2MSFTNGP11.phx.gbl...
>
I am trying to stress test an SQL2000 server running on Windows 2003.
I am using the reskit utility database hammer.
The utility creates a table with 10,000,000 rows in it fine but when I try
to use the query/update part of the tool(procmaster.exe), it fails and I get
an error: 'Problem encountered during processing -2147217913'.
There is plenty of space in my log and data files etc.
Does anybody know what might be going on?
Thanks in advance.
Jane
PS I have also left a copy of this post in the sqlserver tools group.Hi
Sounds something like:
http://support.microsoft.com/defaul...kb;en-us;265166
You may want to run profiler to see where it is having problems.
John
"Jane Reynolds" <nospam@.please.com> wrote in message
news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
> Hello all
> I am trying to stress test an SQL2000 server running on Windows 2003.
> I am using the reskit utility database hammer.
> The utility creates a table with 10,000,000 rows in it fine but when I try
> to use the query/update part of the tool(procmaster.exe), it fails and I
> get an error: 'Problem encountered during processing -2147217913'.
> There is plenty of space in my log and data files etc.
> Does anybody know what might be going on?
> Thanks in advance.
> Jane
> PS I have also left a copy of this post in the sqlserver tools group.
>|||Thanks
It looks like it is a code problem iin the utility then. I have done some
more research and found that there is a bug in the code. I don't know VB
though to try to edit it so will have to think of something else.
Jane
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23ZiKizV1EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Hi
> Sounds something like:
> http://support.microsoft.com/defaul...kb;en-us;265166
> You may want to run profiler to see where it is having problems.
> John
> "Jane Reynolds" <nospam@.please.com> wrote in message
> news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
>|||Hi
The article does not relate to a SQL Server back end, therefore if you did
profile this you can get the exact statement that fails and see what error
message Query Analyser would give you. If it is a datatype problem then you
may want to remove the column from the test or possibly install a different
version of MDAC.
John
"Jane Reynolds" <nospam@.please.com> wrote in message
news:OkyHRvY1EHA.2540@.TK2MSFTNGP09.phx.gbl...
> Thanks
> It looks like it is a code problem iin the utility then. I have done some
> more research and found that there is a bug in the code. I don't know VB
> though to try to edit it so will have to think of something else.
> Jane
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23ZiKizV1EHA.1404@.TK2MSFTNGP11.phx.gbl...
>
Monday, March 19, 2012
Database dump size
Hi there. Running a Sql 2000 installation with latest service pack on
Windows 2000 server. My database dump to disk backup keeps increasing
by about 1 meg per day. The database itself is increasing by a small
percentage of that. In fact the dump is now about the same size as the
database. What's going on? Thanks.Hello
Can you please give us details of the type of backup your
doing as well as your recovery model.
J
>--Original Message--
>Hi there. Running a Sql 2000 installation with latest
service pack on
>Windows 2000 server. My database dump to disk backup
keeps increasing
>by about 1 meg per day. The database itself is increasing
by a small
>percentage of that. In fact the dump is now about the
same size as the
>database. What's going on? Thanks.
>.
>|||What kind of backup are you doing? If you don't use the INIT option the
current backup will append to the existing ones in the dump device.
--
Andrew J. Kelly
SQL Server MVP
"cscott" <christopher@.uncommonlaw.com> wrote in message
news:a94f8da8.0406070533.6a59d6fb@.posting.google.com...
> Hi there. Running a Sql 2000 installation with latest service pack on
> Windows 2000 server. My database dump to disk backup keeps increasing
> by about 1 meg per day. The database itself is increasing by a small
> percentage of that. In fact the dump is now about the same size as the
> database. What's going on? Thanks.|||Hi ,
To add on to Andrew post, Execute the below comand from query analyzer to
check if BACKUP is executed in append mode.
restore headeronly from disk='Directory\dbname.BAK'
If this list more than 1 entry (Check the postion column in output), means
you have taken the backup in Append mode. To remove he append mode add an
OPTION
INIT along with backup database command
BACKUP DATABASE dbname to disk='c:\dbname.bak' with INIT
Thanks
Hari
MCDBA
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uYtrikJTEHA.2324@.TK2MSFTNGP10.phx.gbl...
> What kind of backup are you doing? If you don't use the INIT option the
> current backup will append to the existing ones in the dump device.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "cscott" <christopher@.uncommonlaw.com> wrote in message
> news:a94f8da8.0406070533.6a59d6fb@.posting.google.com...
> > Hi there. Running a Sql 2000 installation with latest service pack on
> > Windows 2000 server. My database dump to disk backup keeps increasing
> > by about 1 meg per day. The database itself is increasing by a small
> > percentage of that. In fact the dump is now about the same size as the
> > database. What's going on? Thanks.
>
Windows 2000 server. My database dump to disk backup keeps increasing
by about 1 meg per day. The database itself is increasing by a small
percentage of that. In fact the dump is now about the same size as the
database. What's going on? Thanks.Hello
Can you please give us details of the type of backup your
doing as well as your recovery model.
J
>--Original Message--
>Hi there. Running a Sql 2000 installation with latest
service pack on
>Windows 2000 server. My database dump to disk backup
keeps increasing
>by about 1 meg per day. The database itself is increasing
by a small
>percentage of that. In fact the dump is now about the
same size as the
>database. What's going on? Thanks.
>.
>|||What kind of backup are you doing? If you don't use the INIT option the
current backup will append to the existing ones in the dump device.
--
Andrew J. Kelly
SQL Server MVP
"cscott" <christopher@.uncommonlaw.com> wrote in message
news:a94f8da8.0406070533.6a59d6fb@.posting.google.com...
> Hi there. Running a Sql 2000 installation with latest service pack on
> Windows 2000 server. My database dump to disk backup keeps increasing
> by about 1 meg per day. The database itself is increasing by a small
> percentage of that. In fact the dump is now about the same size as the
> database. What's going on? Thanks.|||Hi ,
To add on to Andrew post, Execute the below comand from query analyzer to
check if BACKUP is executed in append mode.
restore headeronly from disk='Directory\dbname.BAK'
If this list more than 1 entry (Check the postion column in output), means
you have taken the backup in Append mode. To remove he append mode add an
OPTION
INIT along with backup database command
BACKUP DATABASE dbname to disk='c:\dbname.bak' with INIT
Thanks
Hari
MCDBA
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uYtrikJTEHA.2324@.TK2MSFTNGP10.phx.gbl...
> What kind of backup are you doing? If you don't use the INIT option the
> current backup will append to the existing ones in the dump device.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "cscott" <christopher@.uncommonlaw.com> wrote in message
> news:a94f8da8.0406070533.6a59d6fb@.posting.google.com...
> > Hi there. Running a Sql 2000 installation with latest service pack on
> > Windows 2000 server. My database dump to disk backup keeps increasing
> > by about 1 meg per day. The database itself is increasing by a small
> > percentage of that. In fact the dump is now about the same size as the
> > database. What's going on? Thanks.
>
Friday, February 17, 2012
Database deployment with VisualStudio 2005 Express vor Windows Vista
I want to create deployment for MS SQL 2005 Express database, that
creates database, tables and inserts data. I have made a similar with
VisualStudio 2003 and MSDN
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msdedepl.asp?_r=1
For Windows Vista it won`t work. I have tried to create with
Visual Basic 2005 Express, but I didn`t get how can I do it with
ClickOnce.
If you can help me, I`ll bee thankful!!!!
I'm not sure what your exact problem is, but you may want to check here first:
http://www.microsoft.com/sql/howtobuy/windowsvistasupport.mspx
Buck Woody
|||Hi Laula,
"Won't Work" covers a lot of ground, how about if you post some details?
Mike
Database deployment with VisualStudio 2005 Express vor Windows Vista
I want to create deployment for MS SQL 2005 Express database, that
creates database, tables and inserts data. I have made a similar with
VisualStudio 2003 and MSDN
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msdedepl.asp?_r=1
For Windows Vista it won`t work. I have tried to create with
Visual Basic 2005 Express, but I didn`t get how can I do it with
ClickOnce.
If you can help me, I`ll bee thankful!!!!
I'm not sure what your exact problem is, but you may want to check here first:
http://www.microsoft.com/sql/howtobuy/windowsvistasupport.mspx
Buck Woody
|||Hi Laula,
"Won't Work" covers a lot of ground, how about if you post some details?
Mike
Database deployment with VisualStudio 2005 Express vor Windows Vista
I want to create deployment for MS SQL 2005 Express database, that
creates database, tables and inserts data. I have made a similar with
VisualStudio 2003 and MSDN
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msdedepl.asp?_r=1
For Windows Vista it won`t work. I have tried to create with
Visual Basic 2005 Express, but I didn`t get how can I do it with
ClickOnce.
If you can help me, I`ll bee thankful!!!!
I'm not sure what your exact problem is, but you may want to check here first:
http://www.microsoft.com/sql/howtobuy/windowsvistasupport.mspx
Buck Woody
|||Hi Laula,
"Won't Work" covers a lot of ground, how about if you post some details?
Mike
Database data file does not auto-grow
Dear all,
We are using SQL2000 sp4 on Windows 2000 Svr.
We found one of the database size become zero in Enterprise manager.
We have checked the database setting and the database is already set
auto-growth, without limit, by 1000Mb each time.
The data file size reach 6G now.
Is there anything we miss? That's the first time we meet this case.
We have checked the Harddisk drive for the data file and it still have over
100G space.
IvanIvan wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have over
> 100G space.
> Ivan
Do you get an error message saying the filegroup is full?
What is the output of EXEC sp_spaceused?
Auto-growth is usually a bad idea and isn't something I would normally
recommend for a production application. Why would you want to grow a
6GB database in 1GB increments?
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||dbcc updateusage?
Cheers,
"Ivan" wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have over
> 100G space.
> Ivan
>
>
We are using SQL2000 sp4 on Windows 2000 Svr.
We found one of the database size become zero in Enterprise manager.
We have checked the database setting and the database is already set
auto-growth, without limit, by 1000Mb each time.
The data file size reach 6G now.
Is there anything we miss? That's the first time we meet this case.
We have checked the Harddisk drive for the data file and it still have over
100G space.
IvanIvan wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have over
> 100G space.
> Ivan
Do you get an error message saying the filegroup is full?
What is the output of EXEC sp_spaceused?
Auto-growth is usually a bad idea and isn't something I would normally
recommend for a production application. Why would you want to grow a
6GB database in 1GB increments?
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||dbcc updateusage?
Cheers,
"Ivan" wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have over
> 100G space.
> Ivan
>
>
Database data file does not auto-grow
Dear all,
We are using SQL2000 sp4 on Windows 2000 Svr.
We found one of the database size become zero in Enterprise manager.
We have checked the database setting and the database is already set
auto-growth, without limit, by 1000Mb each time.
The data file size reach 6G now.
Is there anything we miss? That's the first time we meet this case.
We have checked the Harddisk drive for the data file and it still have over
100G space.
Ivan
Ivan wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have over
> 100G space.
> Ivan
Do you get an error message saying the filegroup is full?
What is the output of EXEC sp_spaceused?
Auto-growth is usually a bad idea and isn't something I would normally
recommend for a production application. Why would you want to grow a
6GB database in 1GB increments?
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||dbcc updateusage?
Cheers,
"Ivan" wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have over
> 100G space.
> Ivan
>
>
We are using SQL2000 sp4 on Windows 2000 Svr.
We found one of the database size become zero in Enterprise manager.
We have checked the database setting and the database is already set
auto-growth, without limit, by 1000Mb each time.
The data file size reach 6G now.
Is there anything we miss? That's the first time we meet this case.
We have checked the Harddisk drive for the data file and it still have over
100G space.
Ivan
Ivan wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have over
> 100G space.
> Ivan
Do you get an error message saying the filegroup is full?
What is the output of EXEC sp_spaceused?
Auto-growth is usually a bad idea and isn't something I would normally
recommend for a production application. Why would you want to grow a
6GB database in 1GB increments?
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||dbcc updateusage?
Cheers,
"Ivan" wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have over
> 100G space.
> Ivan
>
>
Database data file does not auto-grow
Dear all,
We are using SQL2000 sp4 on Windows 2000 Svr.
We found one of the database size become zero in Enterprise manager.
We have checked the database setting and the database is already set
auto-growth, without limit, by 1000Mb each time.
The data file size reach 6G now.
Is there anything we miss? That's the first time we meet this case.
We have checked the Harddisk drive for the data file and it still have over
100G space.
IvanIvan wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have ove
r
> 100G space.
> Ivan
Do you get an error message saying the filegroup is full?
What is the output of EXEC sp_spaceused?
Auto-growth is usually a bad idea and isn't something I would normally
recommend for a production application. Why would you want to grow a
6GB database in 1GB increments?
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||dbcc updateusage?
Cheers,
"Ivan" wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have ove
r
> 100G space.
> Ivan
>
>
We are using SQL2000 sp4 on Windows 2000 Svr.
We found one of the database size become zero in Enterprise manager.
We have checked the database setting and the database is already set
auto-growth, without limit, by 1000Mb each time.
The data file size reach 6G now.
Is there anything we miss? That's the first time we meet this case.
We have checked the Harddisk drive for the data file and it still have over
100G space.
IvanIvan wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have ove
r
> 100G space.
> Ivan
Do you get an error message saying the filegroup is full?
What is the output of EXEC sp_spaceused?
Auto-growth is usually a bad idea and isn't something I would normally
recommend for a production application. Why would you want to grow a
6GB database in 1GB increments?
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||dbcc updateusage?
Cheers,
"Ivan" wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have ove
r
> 100G space.
> Ivan
>
>
database creation in XP
I am an SQL beginer, and have installed SQL 2000 in Windows XP SP2. Only the client components of SQL were installed by default in XP. SQL query analyser doesnot detect any servers (I already have IIS installed). In such a scenario how do I create a Database and gain access to it ?Do you know SQL server name?|||
No. The SQL Query analyser doesnot show any available servers. Also I am not connected to any networked PC. I wish to connect to the local/virtual server in IIS in C drive. I have an ASP.Net application in my wwwroot forlder for which I need to create a database to store and access data. Please note that while installing SQL server in XP I was prompted with the following message: "Microsoft SQL Server 2000 Enterprise Edition server component is not suported on this operating system. Only client components will be available for installation". Also due to this reason the MSSQL server service has not been installed.|||IIS server is a web server and not SQL server.
As far as I understand you didn't install SQL server at all and this is why you can't connect to it.
Yes you were right. Although SQL was installed the server components were not installed. I have added the server components and now its working fine.
Thanks a lot.
Quote:
Originally Posted by iburyak
Do you know SQL server name?
No. The SQL Query analyser doesnot show any available servers. Also I am not connected to any networked PC. I wish to connect to the local/virtual server in IIS in C drive. I have an ASP.Net application in my wwwroot forlder for which I need to create a database to store and access data. Please note that while installing SQL server in XP I was prompted with the following message: "Microsoft SQL Server 2000 Enterprise Edition server component is not suported on this operating system. Only client components will be available for installation". Also due to this reason the MSSQL server service has not been installed.|||IIS server is a web server and not SQL server.
As far as I understand you didn't install SQL server at all and this is why you can't connect to it.
The only option you have is to use Access database instead. Go to Microsoft Office and you will be able to find it.|||
Quote:
Originally Posted by iburyak
IIS server is a web server and not SQL server.
As far as I understand you didn't install SQL server at all and this is why you can't connect to it.
The only option you have is to use Access database instead. Go to Microsoft Office and you will be able to find it.
Yes you were right. Although SQL was installed the server components were not installed. I have added the server components and now its working fine.
Thanks a lot.
Tuesday, February 14, 2012
Database could not be removed
We are running SQL Server 2000 Ent SP4 on Windows Server 2003 Ent SP1. Now we
are facing a strange case where when we tried to restore and overwrite a
database, it always say database is in use and cannot be overwritten. I have
tried to detach and even delete it but everytime it just said the database is
in use and refused to give up. I have checked and make sure no users and
connections are make to the said database. Eventually I have to resort to
restarting the SQL service to remove this database.
Is there a way to remove or overwrite a database without restarting the SQL
service?Are you sure YOU are not in the database when you are trying to restore or
detach?
If you run the sp_lock procedure, look for DB locks in the database you are
trying to remove. There will then be a spid, which can let you determine who
is in the database.
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"mpWong" <mpWong@.discussions.microsoft.com> wrote in message
news:C1F40A29-F5E0-4A8A-A993-4167AB6A76F2@.microsoft.com...
> We are running SQL Server 2000 Ent SP4 on Windows Server 2003 Ent SP1. Now
> we
> are facing a strange case where when we tried to restore and overwrite a
> database, it always say database is in use and cannot be overwritten. I
> have
> tried to detach and even delete it but everytime it just said the database
> is
> in use and refused to give up. I have checked and make sure no users and
> connections are make to the said database. Eventually I have to resort to
> restarting the SQL service to remove this database.
> Is there a way to remove or overwrite a database without restarting the
> SQL
> service?
>|||Thanks for your advice. I will check next time this happens again. I am
absolutely sure nobody or myself was using the database when I tried the
restore.
"Kalen Delaney" wrote:
> Are you sure YOU are not in the database when you are trying to restore or
> detach?
> If you run the sp_lock procedure, look for DB locks in the database you are
> trying to remove. There will then be a spid, which can let you determine who
> is in the database.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "mpWong" <mpWong@.discussions.microsoft.com> wrote in message
> news:C1F40A29-F5E0-4A8A-A993-4167AB6A76F2@.microsoft.com...
> > We are running SQL Server 2000 Ent SP4 on Windows Server 2003 Ent SP1. Now
> > we
> > are facing a strange case where when we tried to restore and overwrite a
> > database, it always say database is in use and cannot be overwritten. I
> > have
> > tried to detach and even delete it but everytime it just said the database
> > is
> > in use and refused to give up. I have checked and make sure no users and
> > connections are make to the said database. Eventually I have to resort to
> > restarting the SQL service to remove this database.
> > Is there a way to remove or overwrite a database without restarting the
> > SQL
> > service?
> >
>
>
are facing a strange case where when we tried to restore and overwrite a
database, it always say database is in use and cannot be overwritten. I have
tried to detach and even delete it but everytime it just said the database is
in use and refused to give up. I have checked and make sure no users and
connections are make to the said database. Eventually I have to resort to
restarting the SQL service to remove this database.
Is there a way to remove or overwrite a database without restarting the SQL
service?Are you sure YOU are not in the database when you are trying to restore or
detach?
If you run the sp_lock procedure, look for DB locks in the database you are
trying to remove. There will then be a spid, which can let you determine who
is in the database.
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"mpWong" <mpWong@.discussions.microsoft.com> wrote in message
news:C1F40A29-F5E0-4A8A-A993-4167AB6A76F2@.microsoft.com...
> We are running SQL Server 2000 Ent SP4 on Windows Server 2003 Ent SP1. Now
> we
> are facing a strange case where when we tried to restore and overwrite a
> database, it always say database is in use and cannot be overwritten. I
> have
> tried to detach and even delete it but everytime it just said the database
> is
> in use and refused to give up. I have checked and make sure no users and
> connections are make to the said database. Eventually I have to resort to
> restarting the SQL service to remove this database.
> Is there a way to remove or overwrite a database without restarting the
> SQL
> service?
>|||Thanks for your advice. I will check next time this happens again. I am
absolutely sure nobody or myself was using the database when I tried the
restore.
"Kalen Delaney" wrote:
> Are you sure YOU are not in the database when you are trying to restore or
> detach?
> If you run the sp_lock procedure, look for DB locks in the database you are
> trying to remove. There will then be a spid, which can let you determine who
> is in the database.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "mpWong" <mpWong@.discussions.microsoft.com> wrote in message
> news:C1F40A29-F5E0-4A8A-A993-4167AB6A76F2@.microsoft.com...
> > We are running SQL Server 2000 Ent SP4 on Windows Server 2003 Ent SP1. Now
> > we
> > are facing a strange case where when we tried to restore and overwrite a
> > database, it always say database is in use and cannot be overwritten. I
> > have
> > tried to detach and even delete it but everytime it just said the database
> > is
> > in use and refused to give up. I have checked and make sure no users and
> > connections are make to the said database. Eventually I have to resort to
> > restarting the SQL service to remove this database.
> > Is there a way to remove or overwrite a database without restarting the
> > SQL
> > service?
> >
>
>
Database could not be removed
We are running SQL Server 2000 Ent SP4 on Windows Server 2003 Ent SP1. Now we
are facing a strange case where when we tried to restore and overwrite a
database, it always say database is in use and cannot be overwritten. I have
tried to detach and even delete it but everytime it just said the database is
in use and refused to give up. I have checked and make sure no users and
connections are make to the said database. Eventually I have to resort to
restarting the SQL service to remove this database.
Is there a way to remove or overwrite a database without restarting the SQL
service?
Are you sure YOU are not in the database when you are trying to restore or
detach?
If you run the sp_lock procedure, look for DB locks in the database you are
trying to remove. There will then be a spid, which can let you determine who
is in the database.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"mpWong" <mpWong@.discussions.microsoft.com> wrote in message
news:C1F40A29-F5E0-4A8A-A993-4167AB6A76F2@.microsoft.com...
> We are running SQL Server 2000 Ent SP4 on Windows Server 2003 Ent SP1. Now
> we
> are facing a strange case where when we tried to restore and overwrite a
> database, it always say database is in use and cannot be overwritten. I
> have
> tried to detach and even delete it but everytime it just said the database
> is
> in use and refused to give up. I have checked and make sure no users and
> connections are make to the said database. Eventually I have to resort to
> restarting the SQL service to remove this database.
> Is there a way to remove or overwrite a database without restarting the
> SQL
> service?
>
|||Thanks for your advice. I will check next time this happens again. I am
absolutely sure nobody or myself was using the database when I tried the
restore.
"Kalen Delaney" wrote:
> Are you sure YOU are not in the database when you are trying to restore or
> detach?
> If you run the sp_lock procedure, look for DB locks in the database you are
> trying to remove. There will then be a spid, which can let you determine who
> is in the database.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "mpWong" <mpWong@.discussions.microsoft.com> wrote in message
> news:C1F40A29-F5E0-4A8A-A993-4167AB6A76F2@.microsoft.com...
>
>
are facing a strange case where when we tried to restore and overwrite a
database, it always say database is in use and cannot be overwritten. I have
tried to detach and even delete it but everytime it just said the database is
in use and refused to give up. I have checked and make sure no users and
connections are make to the said database. Eventually I have to resort to
restarting the SQL service to remove this database.
Is there a way to remove or overwrite a database without restarting the SQL
service?
Are you sure YOU are not in the database when you are trying to restore or
detach?
If you run the sp_lock procedure, look for DB locks in the database you are
trying to remove. There will then be a spid, which can let you determine who
is in the database.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"mpWong" <mpWong@.discussions.microsoft.com> wrote in message
news:C1F40A29-F5E0-4A8A-A993-4167AB6A76F2@.microsoft.com...
> We are running SQL Server 2000 Ent SP4 on Windows Server 2003 Ent SP1. Now
> we
> are facing a strange case where when we tried to restore and overwrite a
> database, it always say database is in use and cannot be overwritten. I
> have
> tried to detach and even delete it but everytime it just said the database
> is
> in use and refused to give up. I have checked and make sure no users and
> connections are make to the said database. Eventually I have to resort to
> restarting the SQL service to remove this database.
> Is there a way to remove or overwrite a database without restarting the
> SQL
> service?
>
|||Thanks for your advice. I will check next time this happens again. I am
absolutely sure nobody or myself was using the database when I tried the
restore.
"Kalen Delaney" wrote:
> Are you sure YOU are not in the database when you are trying to restore or
> detach?
> If you run the sp_lock procedure, look for DB locks in the database you are
> trying to remove. There will then be a spid, which can let you determine who
> is in the database.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "mpWong" <mpWong@.discussions.microsoft.com> wrote in message
> news:C1F40A29-F5E0-4A8A-A993-4167AB6A76F2@.microsoft.com...
>
>
Database could not be removed
We are running SQL Server 2000 Ent SP4 on Windows Server 2003 Ent SP1. Now w
e
are facing a strange case where when we tried to restore and overwrite a
database, it always say database is in use and cannot be overwritten. I have
tried to detach and even delete it but everytime it just said the database i
s
in use and refused to give up. I have checked and make sure no users and
connections are make to the said database. Eventually I have to resort to
restarting the SQL service to remove this database.
Is there a way to remove or overwrite a database without restarting the SQL
service?Are you sure YOU are not in the database when you are trying to restore or
detach?
If you run the sp_lock procedure, look for DB locks in the database you are
trying to remove. There will then be a spid, which can let you determine who
is in the database.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"mpWong" <mpWong@.discussions.microsoft.com> wrote in message
news:C1F40A29-F5E0-4A8A-A993-4167AB6A76F2@.microsoft.com...
> We are running SQL Server 2000 Ent SP4 on Windows Server 2003 Ent SP1. Now
> we
> are facing a strange case where when we tried to restore and overwrite a
> database, it always say database is in use and cannot be overwritten. I
> have
> tried to detach and even delete it but everytime it just said the database
> is
> in use and refused to give up. I have checked and make sure no users and
> connections are make to the said database. Eventually I have to resort to
> restarting the SQL service to remove this database.
> Is there a way to remove or overwrite a database without restarting the
> SQL
> service?
>|||Thanks for your advice. I will check next time this happens again. I am
absolutely sure nobody or myself was using the database when I tried the
restore.
"Kalen Delaney" wrote:
> Are you sure YOU are not in the database when you are trying to restore or
> detach?
> If you run the sp_lock procedure, look for DB locks in the database you ar
e
> trying to remove. There will then be a spid, which can let you determine w
ho
> is in the database.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "mpWong" <mpWong@.discussions.microsoft.com> wrote in message
> news:C1F40A29-F5E0-4A8A-A993-4167AB6A76F2@.microsoft.com...
>
>
e
are facing a strange case where when we tried to restore and overwrite a
database, it always say database is in use and cannot be overwritten. I have
tried to detach and even delete it but everytime it just said the database i
s
in use and refused to give up. I have checked and make sure no users and
connections are make to the said database. Eventually I have to resort to
restarting the SQL service to remove this database.
Is there a way to remove or overwrite a database without restarting the SQL
service?Are you sure YOU are not in the database when you are trying to restore or
detach?
If you run the sp_lock procedure, look for DB locks in the database you are
trying to remove. There will then be a spid, which can let you determine who
is in the database.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"mpWong" <mpWong@.discussions.microsoft.com> wrote in message
news:C1F40A29-F5E0-4A8A-A993-4167AB6A76F2@.microsoft.com...
> We are running SQL Server 2000 Ent SP4 on Windows Server 2003 Ent SP1. Now
> we
> are facing a strange case where when we tried to restore and overwrite a
> database, it always say database is in use and cannot be overwritten. I
> have
> tried to detach and even delete it but everytime it just said the database
> is
> in use and refused to give up. I have checked and make sure no users and
> connections are make to the said database. Eventually I have to resort to
> restarting the SQL service to remove this database.
> Is there a way to remove or overwrite a database without restarting the
> SQL
> service?
>|||Thanks for your advice. I will check next time this happens again. I am
absolutely sure nobody or myself was using the database when I tried the
restore.
"Kalen Delaney" wrote:
> Are you sure YOU are not in the database when you are trying to restore or
> detach?
> If you run the sp_lock procedure, look for DB locks in the database you ar
e
> trying to remove. There will then be a spid, which can let you determine w
ho
> is in the database.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.solidqualitylearning.com
>
> "mpWong" <mpWong@.discussions.microsoft.com> wrote in message
> news:C1F40A29-F5E0-4A8A-A993-4167AB6A76F2@.microsoft.com...
>
>
Database corrupted since windows reboot
Hi,
My librarian has a problem with is computer. He uses it to store all of
his client's asks, his inventory, etc... on a SQL server's database,
with the help of a third part program, and he never restart his computer.
He few weeks ago, some problems on our city (in France), make his
computer turn off, then restart. And while windows was restarting, it
install to him the latest version of some software - but he didn't
notice which one. And when he turns on the program, the sql server's
database where corrupted, and he wasn't able to use it again:
unfortunately, the program was using it when the computer turn off.
Nonetheless, he didn't made any daily save, so he lost all the
information about his business since a month...
He would like to know if there a way to repair the database, in order to
use it again, instead of restart from 0. He write to the program's
maker, but he wasn't able to restore the data, and a google search
didn't help: none of the answer where about this problem... So is there
any special keywords that I could use, or a known way to repair the base?
Thanks a lot for answer,
Aramiil
Hi,
Could you please answer to below queries:-
1. Are you able to start your SQL Server Service?
2. Did you gone thru the SQL Server Error logs and Event viewer?
3. What is the exact error you ere getting or you have pointed out?
4. How did you come to the conclusion that your database is crached?
Thanks
Hari
SQL Server MVP
"Yann PIQUET" <aramiil@.neobelari.com> wrote in message
news:42dac42e$0$12992$7a628cd7@.news.club-internet.fr...
> Hi,
> My librarian has a problem with is computer. He uses it to store all of
> his client's asks, his inventory, etc... on a SQL server's database, with
> the help of a third part program, and he never restart his computer.
> He few weeks ago, some problems on our city (in France), make his computer
> turn off, then restart. And while windows was restarting, it install to
> him the latest version of some software - but he didn't notice which one.
> And when he turns on the program, the sql server's database where
> corrupted, and he wasn't able to use it again: unfortunately, the program
> was using it when the computer turn off. Nonetheless, he didn't made any
> daily save, so he lost all the information about his business since a
> month...
> He would like to know if there a way to repair the database, in order to
> use it again, instead of restart from 0. He write to the program's maker,
> but he wasn't able to restore the data, and a google search didn't help:
> none of the answer where about this problem... So is there any special
> keywords that I could use, or a known way to repair the base?
> Thanks a lot for answer,
> Aramiil
|||Hi,
Well, I don't really know about SQL server, so I just can answer a few
of your questions:
1=2E Yes, I'm able to start my SQL Server Service, and to use an older
save of the databse, aged of near a month.
2=2E Here are the logs: http://www.neobelari.com/SQLAGENT.zip
3=2E The program (called Octave) display a message with this: "Base
corrompue, impossible d'acceder =E0 la base". I'm not used to work with
SQL server, so I don't have any other informations by the sql server
4=2E idem
Thanks a lot for answer.
Hari Prasad a =E9crit :[vbcol=seagreen]
> Hi,
> Could you please answer to below queries:-
> 1. Are you able to start your SQL Server Service?
> 2. Did you gone thru the SQL Server Error logs and Event viewer?
> 3. What is the exact error you ere getting or you have pointed out?
> 4. How did you come to the conclusion that your database is crached?
>
> Thanks
> Hari
> SQL Server MVP
>
> "Yann PIQUET" <aramiil@.neobelari.com> wrote in message
> news:42dac42e$0$12992$7a628cd7@.news.club-internet.fr...
th[vbcol=seagreen]
ter[vbcol=seagreen]
e=2E[vbcol=seagreen]
am[vbcol=seagreen]
r,[vbcol=seagreen]
|||Hi,
The error logs attached are in French.. Sorry , I am not able to understand.
Thanks
Hari
<apislibrairie@.wanadoo.fr> wrote in message
news:1121684158.709635.26710@.g14g2000cwa.googlegro ups.com...
Hi,
Well, I don't really know about SQL server, so I just can answer a few
of your questions:
1. Yes, I'm able to start my SQL Server Service, and to use an older
save of the databse, aged of near a month.
2. Here are the logs: http://www.neobelari.com/SQLAGENT.zip
3. The program (called Octave) display a message with this: "Base
corrompue, impossible d'acceder la base". I'm not used to work with
SQL server, so I don't have any other informations by the sql server
4. idem
Thanks a lot for answer.
Hari Prasad a crit :[vbcol=seagreen]
> Hi,
> Could you please answer to below queries:-
> 1. Are you able to start your SQL Server Service?
> 2. Did you gone thru the SQL Server Error logs and Event viewer?
> 3. What is the exact error you ere getting or you have pointed out?
> 4. How did you come to the conclusion that your database is crached?
>
> Thanks
> Hari
> SQL Server MVP
>
> "Yann PIQUET" <aramiil@.neobelari.com> wrote in message
> news:42dac42e$0$12992$7a628cd7@.news.club-internet.fr...
|||Hi,
Sorry, I've forgot to translate them... Here are two of them translated
in english (I hope I didn't do too many errors in translation :-/), I'll
post a link to the others one when I'll have finish them.
http://www.neobelari.com/SQLAGENT_eng_part1.zip
Thanks,
Aramiil
Hari Prasad a crit :
> Hi,
> The error logs attached are in French.. Sorry , I am not able to understand.
> Thanks
> Hari
> <apislibrairie@.wanadoo.fr> wrote in message
> news:1121684158.709635.26710@.g14g2000cwa.googlegro ups.com...
> Hi,
> Well, I don't really know about SQL server, so I just can answer a few
> of your questions:
> 1. Yes, I'm able to start my SQL Server Service, and to use an older
> save of the databse, aged of near a month.
> 2. Here are the logs: http://www.neobelari.com/SQLAGENT.zip
> 3. The program (called Octave) display a message with this: "Base
> corrompue, impossible d'acceder la base". I'm not used to work with
> SQL server, so I don't have any other informations by the sql server
> 4. idem
> Thanks a lot for answer.
> Hari Prasad a crit :
>
>
My librarian has a problem with is computer. He uses it to store all of
his client's asks, his inventory, etc... on a SQL server's database,
with the help of a third part program, and he never restart his computer.
He few weeks ago, some problems on our city (in France), make his
computer turn off, then restart. And while windows was restarting, it
install to him the latest version of some software - but he didn't
notice which one. And when he turns on the program, the sql server's
database where corrupted, and he wasn't able to use it again:
unfortunately, the program was using it when the computer turn off.
Nonetheless, he didn't made any daily save, so he lost all the
information about his business since a month...
He would like to know if there a way to repair the database, in order to
use it again, instead of restart from 0. He write to the program's
maker, but he wasn't able to restore the data, and a google search
didn't help: none of the answer where about this problem... So is there
any special keywords that I could use, or a known way to repair the base?
Thanks a lot for answer,
Aramiil
Hi,
Could you please answer to below queries:-
1. Are you able to start your SQL Server Service?
2. Did you gone thru the SQL Server Error logs and Event viewer?
3. What is the exact error you ere getting or you have pointed out?
4. How did you come to the conclusion that your database is crached?
Thanks
Hari
SQL Server MVP
"Yann PIQUET" <aramiil@.neobelari.com> wrote in message
news:42dac42e$0$12992$7a628cd7@.news.club-internet.fr...
> Hi,
> My librarian has a problem with is computer. He uses it to store all of
> his client's asks, his inventory, etc... on a SQL server's database, with
> the help of a third part program, and he never restart his computer.
> He few weeks ago, some problems on our city (in France), make his computer
> turn off, then restart. And while windows was restarting, it install to
> him the latest version of some software - but he didn't notice which one.
> And when he turns on the program, the sql server's database where
> corrupted, and he wasn't able to use it again: unfortunately, the program
> was using it when the computer turn off. Nonetheless, he didn't made any
> daily save, so he lost all the information about his business since a
> month...
> He would like to know if there a way to repair the database, in order to
> use it again, instead of restart from 0. He write to the program's maker,
> but he wasn't able to restore the data, and a google search didn't help:
> none of the answer where about this problem... So is there any special
> keywords that I could use, or a known way to repair the base?
> Thanks a lot for answer,
> Aramiil
|||Hi,
Well, I don't really know about SQL server, so I just can answer a few
of your questions:
1=2E Yes, I'm able to start my SQL Server Service, and to use an older
save of the databse, aged of near a month.
2=2E Here are the logs: http://www.neobelari.com/SQLAGENT.zip
3=2E The program (called Octave) display a message with this: "Base
corrompue, impossible d'acceder =E0 la base". I'm not used to work with
SQL server, so I don't have any other informations by the sql server
4=2E idem
Thanks a lot for answer.
Hari Prasad a =E9crit :[vbcol=seagreen]
> Hi,
> Could you please answer to below queries:-
> 1. Are you able to start your SQL Server Service?
> 2. Did you gone thru the SQL Server Error logs and Event viewer?
> 3. What is the exact error you ere getting or you have pointed out?
> 4. How did you come to the conclusion that your database is crached?
>
> Thanks
> Hari
> SQL Server MVP
>
> "Yann PIQUET" <aramiil@.neobelari.com> wrote in message
> news:42dac42e$0$12992$7a628cd7@.news.club-internet.fr...
th[vbcol=seagreen]
ter[vbcol=seagreen]
e=2E[vbcol=seagreen]
am[vbcol=seagreen]
r,[vbcol=seagreen]
|||Hi,
The error logs attached are in French.. Sorry , I am not able to understand.
Thanks
Hari
<apislibrairie@.wanadoo.fr> wrote in message
news:1121684158.709635.26710@.g14g2000cwa.googlegro ups.com...
Hi,
Well, I don't really know about SQL server, so I just can answer a few
of your questions:
1. Yes, I'm able to start my SQL Server Service, and to use an older
save of the databse, aged of near a month.
2. Here are the logs: http://www.neobelari.com/SQLAGENT.zip
3. The program (called Octave) display a message with this: "Base
corrompue, impossible d'acceder la base". I'm not used to work with
SQL server, so I don't have any other informations by the sql server
4. idem
Thanks a lot for answer.
Hari Prasad a crit :[vbcol=seagreen]
> Hi,
> Could you please answer to below queries:-
> 1. Are you able to start your SQL Server Service?
> 2. Did you gone thru the SQL Server Error logs and Event viewer?
> 3. What is the exact error you ere getting or you have pointed out?
> 4. How did you come to the conclusion that your database is crached?
>
> Thanks
> Hari
> SQL Server MVP
>
> "Yann PIQUET" <aramiil@.neobelari.com> wrote in message
> news:42dac42e$0$12992$7a628cd7@.news.club-internet.fr...
|||Hi,
Sorry, I've forgot to translate them... Here are two of them translated
in english (I hope I didn't do too many errors in translation :-/), I'll
post a link to the others one when I'll have finish them.
http://www.neobelari.com/SQLAGENT_eng_part1.zip
Thanks,
Aramiil
Hari Prasad a crit :
> Hi,
> The error logs attached are in French.. Sorry , I am not able to understand.
> Thanks
> Hari
> <apislibrairie@.wanadoo.fr> wrote in message
> news:1121684158.709635.26710@.g14g2000cwa.googlegro ups.com...
> Hi,
> Well, I don't really know about SQL server, so I just can answer a few
> of your questions:
> 1. Yes, I'm able to start my SQL Server Service, and to use an older
> save of the databse, aged of near a month.
> 2. Here are the logs: http://www.neobelari.com/SQLAGENT.zip
> 3. The program (called Octave) display a message with this: "Base
> corrompue, impossible d'acceder la base". I'm not used to work with
> SQL server, so I don't have any other informations by the sql server
> 4. idem
> Thanks a lot for answer.
> Hari Prasad a crit :
>
>
Subscribe to:
Posts (Atom)