Database Movement

Hello, I normally use the database backup and restore commands when I am
moving one database for one computer to another. This time however, I
brought over the raw files for the log and data. How can I get sql server
to incorporate these files into the server that I am placing them on. This
server does not have that database at all. I moved the files to the
location it normally places the log and datafiles, but when I brought SQL
server up, it did not show me those files in enterprise manager.
Any ideas how to utilize these files in SQL server?
Thanks in advance for your assistance!!!!!!Look up sp_attach_db and sp_detach_db in BOL (Books On-Line).
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"C_Silin" <OverwhelmedButStillTrying@.hotmail.com> wrote in message
news:Xns9485989199631CSilinhotmailcom@.207.46.248.16...
> Hello, I normally use the database backup and restore commands when I am
> moving one database for one computer to another. This time however, I
> brought over the raw files for the log and data. How can I get sql server
> to incorporate these files into the server that I am placing them on.
This
> server does not have that database at all. I moved the files to the
> location it normally places the log and datafiles, but when I brought SQL
> server up, it did not show me those files in enterprise manager.
> Any ideas how to utilize these files in SQL server?
> Thanks in advance for your assistance!!!!!!

Database Movement

Hello, I normally use the database backup and restore commands when I am
moving one database for one computer to another. This time however, I
brought over the raw files for the log and data. How can I get sql server
to incorporate these files into the server that I am placing them on. This
server does not have that database at all. I moved the files to the
location it normally places the log and datafiles, but when I brought SQL
server up, it did not show me those files in enterprise manager.
Any ideas how to utilize these files in SQL server?
Thanks in advance for your assistance!!!!!!Look up sp_attach_db and sp_detach_db in BOL (Books On-Line).
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"C_Silin" <OverwhelmedButStillTrying@.hotmail.com> wrote in message
news:Xns9485989199631CSilinhotmailcom@.20
7.46.248.16...

quote:

---

> Hello, I normally use the database backup and restore commands when I am
> moving one database for one computer to another. This time however, I
> brought over the raw files for the log and data. How can I get sql server
> to incorporate these files into the server that I am placing them on.

---

This

quote:

---

> server does not have that database at all. I moved the files to the
> location it normally places the log and datafiles, but when I brought SQL
> server up, it did not show me those files in enterprise manager.
> Any ideas how to utilize these files in SQL server?
> Thanks in advance for your assistance!!!!!!

---

Database mirroring and raw partitions

I have several servers that I am setting up using raw disk partitions for th
e
data and log storage, and at the same time I am very interested in the new
database mirroring technology in SQL 2005. My question and problem is this,
I can get mirroring to work if I have the logs on a ntfs partition, but if I
place them on a raw partition the mirror goes into a suspended state and the
error logs have the following errors:
----
--
While acting as a mirroring partner for database 'RealTime', server instance
'DATA2' encountered error 5123, status 1, severity 16. Database mirroring
will be suspended. Try to resolve the error and resume mirroring.
Error: 1454, Severity: 16, State: 1.
CREATE FILE encountered operating system error 32(The process cannot access
the file because it is being used by another process.) while attempting to
open or create the physical file 'C:\DriveMapping\RealTime_Log_Disk3\'.
----
--
The raw partitions are set up using mapped folders on a ntfs partition, and
the database can execute queries 20-25% faster than an identical server I
have set up with the data and logs on NTFS partitions.Hi
As you can't do normal OS operations on a RAW partition it does not really
surprise me that this is not possible, but I have not found anything to say
that!!!
What was the sector size on the NTFS volume that did not perform?
John
"MDBVV" wrote:

> I have several servers that I am setting up using raw disk partitions for
the
> data and log storage, and at the same time I am very interested in the new
> database mirroring technology in SQL 2005. My question and problem is thi
s,
> I can get mirroring to work if I have the logs on a ntfs partition, but if
I
> place them on a raw partition the mirror goes into a suspended state and t
he
> error logs have the following errors:
> ----
--
> While acting as a mirroring partner for database 'RealTime', server instan
ce
> 'DATA2' encountered error 5123, status 1, severity 16. Database mirroring
> will be suspended. Try to resolve the error and resume mirroring.
> Error: 1454, Severity: 16, State: 1.
> CREATE FILE encountered operating system error 32(The process cannot acces
s
> the file because it is being used by another process.) while attempting to
> open or create the physical file 'C:\DriveMapping\RealTime_Log_Disk3'.
> ----
--
> The raw partitions are set up using mapped folders on a ntfs partition, an
d
> the database can execute queries 20-25% faster than an identical server I
> have set up with the data and logs on NTFS partitions.
>
>|||Hi
As you can't do normal OS operations on a RAW partition it does not really
surprise me that this is not possible, but I have not found anything to say
that!!!
What was the sector size on the NTFS volume that did not perform?
John
"MDBVV" wrote:

> I have several servers that I am setting up using raw disk partitions for
the
> data and log storage, and at the same time I am very interested in the new
> database mirroring technology in SQL 2005. My question and problem is thi
s,
> I can get mirroring to work if I have the logs on a ntfs partition, but if
I
> place them on a raw partition the mirror goes into a suspended state and t
he
> error logs have the following errors:
> ----
--
> While acting as a mirroring partner for database 'RealTime', server instan
ce
> 'DATA2' encountered error 5123, status 1, severity 16. Database mirroring
> will be suspended. Try to resolve the error and resume mirroring.
> Error: 1454, Severity: 16, State: 1.
> CREATE FILE encountered operating system error 32(The process cannot acces
s
> the file because it is being used by another process.) while attempting to
> open or create the physical file 'C:\DriveMapping\RealTime_Log_Disk3'.
> ----
--
> The raw partitions are set up using mapped folders on a ntfs partition, an
d
> the database can execute queries 20-25% faster than an identical server I
> have set up with the data and logs on NTFS partitions.
>
>

Database mirroring and raw partitions

I have several servers that I am setting up using raw disk partitions for the
data and log storage, and at the same time I am very interested in the new
database mirroring technology in SQL 2005. My question and problem is this,
I can get mirroring to work if I have the logs on a ntfs partition, but if I
place them on a raw partition the mirror goes into a suspended state and the
error logs have the following errors
-----
While acting as a mirroring partner for database 'RealTime', server instance
'DATA2' encountered error 5123, status 1, severity 16. Database mirroring
will be suspended. Try to resolve the error and resume mirroring.
Error: 1454, Severity: 16, State: 1.
CREATE FILE encountered operating system error 32(The process cannot access
the file because it is being used by another process.) while attempting to
open or create the physical file 'C:\DriveMapping\RealTime_Log_Disk3\'
-----
The raw partitions are set up using mapped folders on a ntfs partition, and
the database can execute queries 20-25% faster than an identical server I
have set up with the data and logs on NTFS partitions.Hi
As you can't do normal OS operations on a RAW partition it does not really
surprise me that this is not possible, but I have not found anything to say
that!!!
What was the sector size on the NTFS volume that did not perform?
John
"MDBVV" wrote:
> I have several servers that I am setting up using raw disk partitions for the
> data and log storage, and at the same time I am very interested in the new
> database mirroring technology in SQL 2005. My question and problem is this,
> I can get mirroring to work if I have the logs on a ntfs partition, but if I
> place them on a raw partition the mirror goes into a suspended state and the
> error logs have the following errors:
> -----
> While acting as a mirroring partner for database 'RealTime', server instance
> 'DATA2' encountered error 5123, status 1, severity 16. Database mirroring
> will be suspended. Try to resolve the error and resume mirroring.
> Error: 1454, Severity: 16, State: 1.
> CREATE FILE encountered operating system error 32(The process cannot access
> the file because it is being used by another process.) while attempting to
> open or create the physical file 'C:\DriveMapping\RealTime_Log_Disk3\'.
> -----
> The raw partitions are set up using mapped folders on a ntfs partition, and
> the database can execute queries 20-25% faster than an identical server I
> have set up with the data and logs on NTFS partitions.
>
>

database mirroring

Does anyone know if you can read the mirror database after installing sql
2005 sp1.
I did setup mirror config before sp1 came out, but at that time the mirror
db was not avilable to read, but I heard then in sp1 it was going to be
fixed, so you can read the mirror db.
Thank you.Check out this thread in this forum: SQL 2005 Architecture Question -
Active Secondary Database?|||Nope. You cannot read the mirror database. You can create a DB Snapshot of
the mirror database and read the snapshot, which has worked since the first
CTPs. For true reporting consider using replication.
Mark Wistrom [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"john" <john@.discussions.microsoft.com> wrote in message
news:89921180-B433-40F0-AB00-13185B8C115C@.microsoft.com...
> Does anyone know if you can read the mirror database after installing sql
> 2005 sp1.
> I did setup mirror config before sp1 came out, but at that time the mirror
> db was not avilable to read, but I heard then in sp1 it was going to be
> fixed, so you can read the mirror db.
> Thank you.|||This is a NNTP newsgroup. What "forum" are you talking about?
*mike hodgson*
http://sqlnerd.blogspot.com
sterillo@.hotmail.com wrote:

>Check out this thread in this forum: SQL 2005 Architecture Question -
>Active Secondary Database?
>
>|||You cannot read from nor update a database involved in a mirroring session
while is acting as the 'mirror' role, but you can create a snapshot at any
moment and read from the snapshot. See this link:
http://msdn2.microsoft.com/en-us/library/ms175511.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"john" <john@.discussions.microsoft.com> wrote in message
news:89921180-B433-40F0-AB00-13185B8C115C@.microsoft.com...
> Does anyone know if you can read the mirror database after installing sql
> 2005 sp1.
> I did setup mirror config before sp1 came out, but at that time the mirror
> db was not avilable to read, but I heard then in sp1 it was going to be
> fixed, so you can read the mirror db.
> Thank you.sql

database mirroring

Does anyone know if you can read the mirror database after installing sql
2005 sp1.
I did setup mirror config before sp1 came out, but at that time the mirror
db was not avilable to read, but I heard then in sp1 it was going to be
fixed, so you can read the mirror db.
Thank you.Check out this thread in this forum: SQL 2005 Architecture Question -
Active Secondary Database?|||Nope. You cannot read the mirror database. You can create a DB Snapshot of
the mirror database and read the snapshot, which has worked since the first
CTPs. For true reporting consider using replication.
--
Mark Wistrom [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"john" <john@.discussions.microsoft.com> wrote in message
news:89921180-B433-40F0-AB00-13185B8C115C@.microsoft.com...
> Does anyone know if you can read the mirror database after installing sql
> 2005 sp1.
> I did setup mirror config before sp1 came out, but at that time the mirror
> db was not avilable to read, but I heard then in sp1 it was going to be
> fixed, so you can read the mirror db.
> Thank you.|||This is a multi-part message in MIME format.
--020800020103060408080900
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
This is a NNTP newsgroup. What "forum" are you talking about?
--
*mike hodgson*
http://sqlnerd.blogspot.com
sterillo@.hotmail.com wrote:
>Check out this thread in this forum: SQL 2005 Architecture Question -
>Active Secondary Database?
>
>
--020800020103060408080900
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>This is a NNTP newsgroup. What "forum" are you talking about?</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
<a class="moz-txt-link-abbreviated" href="http://links.10026.com/?link=mailto:sterillo@.hotmail.com">sterillo@.hotmail.com</a> wrote:
<blockquote
cite="mid1146764469.171645.227080@.j33g2000cwa.googlegroups.com"
type="cite">
<pre wrap="">Check out this thread in this forum: SQL 2005 Architecture Question -
Active Secondary Database?
</pre>
</blockquote>
</body>
</html>
--020800020103060408080900--|||You cannot read from nor update a database involved in a mirroring session
while is acting as the 'mirror' role, but you can create a snapshot at any
moment and read from the snapshot. See this link:
http://msdn2.microsoft.com/en-us/library/ms175511.aspx
--
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"john" <john@.discussions.microsoft.com> wrote in message
news:89921180-B433-40F0-AB00-13185B8C115C@.microsoft.com...
> Does anyone know if you can read the mirror database after installing sql
> 2005 sp1.
> I did setup mirror config before sp1 came out, but at that time the mirror
> db was not avilable to read, but I heard then in sp1 it was going to be
> fixed, so you can read the mirror db.
> Thank you.

Database Maintenance Plan

I used the Database Maintenance Plan Wizard,
I have scheduled it once a day at a certain time.
And nothing happen. No program run at that time.
Is there something else to do to run the plan ?
And is it possible to run it immediatly ?
Thanks for help.
Pierre.The problem comes from a Loggin failure.

I am very confused with all these loggin !

My SQLdatabase have SQL login (not window).

When I run the SQL job, it takes my window login.

What should I do to be coherent.
(SQLserver 2000, and Windows 2000)

Thanks, Pierre.|||First of all check from EM --> Management --> JObs and specified job is enabled or not.

And use Local or domain account with admin privileges for SQL services account.

Try to execute the job manually and see the results.|||Ok, my problem is that I do not understand well Windows2000.

I understand that a User belong to a group.
And this group have priviledges.

But I do not see where to modify the group properties for assigning rights (priviledges).

Thanks for any help, if possible.|||On Win2K from Administrative tools --> Services and select MSSQLSErver & MSSqlAgent to add this user from that group/domain.

Restart the service to take the effect.|||I add the user I use to loggin Windows2000.
(MSSQLSERVER Service properties : Log On)

I restart the Server and run the job.
But the SQL job did fail again.

DataBase Log error.

Hi guys,

Toda i try to insert one row in my databse product table.....that time i got this kind of error.....

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'testDatabase' is full. Back up the transaction log for the database to free up some log space.

the transaction log for the database to free up some log space.

/xxxx/yyyy/zzzzzzzzzzzz.asp, line 109

any one know about this kind of error .......pls help me......

thanks in advanseHave a look at this:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#EYRAE|||ever since they changed the default recovery mode from 7 to 2000 I wish they had added a screen to the setup with big flashing letters about the implications.|||Can i use following command for this one,

dbcc shrinkfile ([dbname_log])|||well you could do a dbcc shrinkfile ([dbname_log],1) but the real issue you need to address here is your recovery model and what I suspect is your non-existent disaster recovery plan.

sql2k defaults to full recovery. which means you can recover to any point in time as long as you are performing database and transaction log backups. I suspect you are either not doing this or not doing it frequently enough because if you had been your transaction log would not have filled up your drive. unless of course you have your ldf and mdf on the same drive god forbid. In which case you are just straight running out of space and you do not really care what happens if you lose a drive or a machine which will eventually happen.

'Database Loading' state after Restore

I have a SQL 2000 Ent. SP3 on W2k3 cluster.
Every time when I restore a db from EM ( Use : leave database operational ...) it starts restoring, I se NO progression on the progressbar, and then it says: Successfully restored ...
And the db is gray and says Loading. I cant acess it in any way. No errors in any logs.
The db I now have problem with restores ok on another system.
I havent had this problem with small db's. The one I'm trying now is 9GB.try RESTORE DATABASE ... WITH RECOVERY option
"Bjørn" <anonymous@.discussions.microsoft.com> wrote in message
news:6DDC2092-7FCC-4C57-9759-812AAA5CEB84@.microsoft.com...
> I have a SQL 2000 Ent. SP3 on W2k3 cluster.
> Every time when I restore a db from EM ( Use : leave database operational
...) it starts restoring, I se NO progression on the progressbar, and then
it says: Successfully restored ...
> And the db is gray and says Loading. I cant acess it in any way. No errors
in any logs.
> The db I now have problem with restores ok on another system.
> I havent had this problem with small db's. The one I'm trying now is 9GB.
>
>|||Says :
File 'db_data' was only partially restored by a database or file restore. The entire file must be successfully restored before applying the log.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
And trying to get the properties of the db says:
Error 927. Database '...' cannot be opened. It is in the middle of a restore.

'Database Loading' state after Restore

I have a SQL 2000 Ent. SP3 on W2k3 cluster.
Every time when I restore a db from EM ( Use : leave database operational ..
.) it starts restoring, I se NO progression on the progressbar, and then it
says: Successfully restored ...
And the db is gray and says Loading. I cant acess it in any way. No errors i
n any logs.
The db I now have problem with restores ok on another system.
I havent had this problem with small db's. The one I'm trying now is 9GB.try RESTORE DATABASE ... WITH RECOVERY option
"Bjrn" <anonymous@.discussions.microsoft.com> wrote in message
news:6DDC2092-7FCC-4C57-9759-812AAA5CEB84@.microsoft.com...

quote:

---

> I have a SQL 2000 Ent. SP3 on W2k3 cluster.
> Every time when I restore a db from EM ( Use : leave database operational

---

...) it starts restoring, I se NO progression on the progressbar, and then
it says: Successfully restored ...

quote:

---

> And the db is gray and says Loading. I cant acess it in any way. No errors

---

in any logs.

quote:

---

> The db I now have problem with restores ok on another system.
> I havent had this problem with small db's. The one I'm trying now is 9GB.
>
>

---

|||Says :
File 'db_data' was only partially restored by a database or file restore. Th
e entire file must be successfully restored before applying the log.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
And trying to get the properties of the db says:
Error 927. Database '...' cannot be opened. It is in the middle of a restor
e.

Database last accessed

Hello All,
Is there a way to figure out/track when was the last time/date a
particular database was accessed by users? I am trying to determine
which databases haven't been used/accessed by users in a while so I can
find out if they are still needed or not. My environment is SQL 2000
SP3 with Windows 2000 as the OS. Any help will be appreciated.
Thanks,
Raziq.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Hi,
First option will be enable Profiler , otherwise write triggers to identify
the last accessed database.
Thanks
Hari
MCDBA
"Raziq Shekha" <raziq_shekha@.anadarko.com> wrote in message
news:eiZlyPr2DHA.1700@.TK2MSFTNGP12.phx.gbl...
> Hello All,
> Is there a way to figure out/track when was the last time/date a
> particular database was accessed by users? I am trying to determine
> which databases haven't been used/accessed by users in a while so I can
> find out if they are still needed or not. My environment is SQL 2000
> SP3 with Windows 2000 as the OS. Any help will be appreciated.
> Thanks,
> Raziq.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Database last accessed

Hello All,
Is there a way to figure out/track when was the last time/date a
particular database was accessed by users? I am trying to determine
which databases haven't been used/accessed by users in a while so I can
find out if they are still needed or not. My environment is SQL 2000
SP3 with Windows 2000 as the OS. Any help will be appreciated.
Thanks,
Raziq.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!Hi,
First option will be enable Profiler , otherwise write triggers to identify
the last accessed database.
Thanks
Hari
MCDBA
"Raziq Shekha" <raziq_shekha@.anadarko.com> wrote in message
news:eiZlyPr2DHA.1700@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Hello All,
> Is there a way to figure out/track when was the last time/date a
> particular database was accessed by users? I am trying to determine
> which databases haven't been used/accessed by users in a while so I can
> find out if they are still needed or not. My environment is SQL 2000
> SP3 with Windows 2000 as the OS. Any help will be appreciated.
> Thanks,
> Raziq.
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!

---

|||I'll have to run profiler for quite some time to see if anyone is using
that database or not. Isn't there a systable/sysdatabase where this
information is recorded?
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||are you saying where the data collected by profiler is stored? When you run
profiler you can tell it where to save the data, or you can run and save
later.
"Raziq Shekha" <raziq_shekha@.anadarko.com> wrote in message
news:uvPkRRs2DHA.3416@.tk2msftngp13.phx.gbl...

quote:

---

> I'll have to run profiler for quite some time to see if anyone is using
> that database or not. Isn't there a systable/sysdatabase where this
> information is recorded?
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!

---

|||No, what I am saying is that won't I have to keep the profiler running
for a few days to see if anyone had connected to a particular database?
What I am trying to find is a way to figure out when was the last time
someone had accessed this database. It could have been couple of months
ago that someone may have accessed it. It could have been last week,
and they may not access it again for another week. As far as the
profiler is concerned, I'll have to keep it running for a couple of
weeks to see if anyone logged on to a particular database while the
profiler was running. I hope this clarifies what I am trying to do.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!