Sql Cannot connect: copy

Showing posts with label copy. Show all posts

Sunday, March 25, 2012

Cannot drop database (hanging in loading and marked for replication)

Hi
I have restored a database to the same instance as it was backup, but as a
copy of the original database (I need a couple of Stored Procedures), but
while restoring the database is to hanging with (Loading).
I've tried to drop the database but it says that it cannot be dropped
because it is marked for replication, I've then tried to drop the
replication on the database but it can't, it says that the database cannot
be opened because it is in the middle of a restore.
What to do? I'm pretty stuck...
I've running SQL Server 2000 on a windows 2003 server SP1, the database is
less than 100MB in size.
-KimI was having the same problem restoring my database (without replication
issue) and it's stuck loading for an hour, so stoped SQL Server and removed
that datbase mdf and log files..
Then restarted my server and run mentanance task (optmizing & fix intgerity)
on master database..
Then restore my database from the backup
it finished in less than a minute.
"Kim" <webdrift_nospam_@.carlbro.dk> wrote in message
news:43f6ec88$1@.news.carlbro.dk...
> Hi
> I have restored a database to the same instance as it was backup, but as a
> copy of the original database (I need a couple of Stored Procedures), but
> while restoring the database is to hanging with (Loading).
> I've tried to drop the database but it says that it cannot be dropped
> because it is marked for replication, I've then tried to drop the
> replication on the database but it can't, it says that the database cannot
> be opened because it is in the middle of a restore.
> What to do? I'm pretty stuck...
> I've running SQL Server 2000 on a windows 2003 server SP1, the database is
> less than 100MB in size.
> -Kim
>|||Hi,
I've removed the psysical files as suggested and runned the maintenance task
"check database integrity" on master (couldn't find optimize + fix
integrity).
This hasn't removed the entry from the enterprise manager... should I make
a new restore and then remove the entry ? (I don't need to restore it
anymore)
-KIm
"Islamegy®" <NULL_Islamegy_NULL@.yahoo.com> wrote in message
news:ummPctJNGHA.532@.TK2MSFTNGP15.phx.gbl...
>I was having the same problem restoring my database (without replication
>issue) and it's stuck loading for an hour, so stoped SQL Server and removed
>that datbase mdf and log files..
> Then restarted my server and run mentanance task (optmizing & fix
> intgerity) on master database..
> Then restore my database from the backup
> it finished in less than a minute.
> "Kim" <webdrift_nospam_@.carlbro.dk> wrote in message
> news:43f6ec88$1@.news.carlbro.dk...
>> Hi
>> I have restored a database to the same instance as it was backup, but as
>> a copy of the original database (I need a couple of Stored Procedures),
>> but while restoring the database is to hanging with (Loading).
>> I've tried to drop the database but it says that it cannot be dropped
>> because it is marked for replication, I've then tried to drop the
>> replication on the database but it can't, it says that the database
>> cannot be opened because it is in the middle of a restore.
>> What to do? I'm pretty stuck...
>> I've running SQL Server 2000 on a windows 2003 server SP1, the database
>> is less than 100MB in size.
>> -Kim
>|||"Islamegy®":
>>I was having the same problem restoring my database (without replication
>>issue) and it's stuck loading for an hour, so stoped SQL Server and
>>removed that datbase mdf and log files..
>> Then restarted my server and run mentanance task (optmizing & fix
>> intgerity) on master database..
>> Then restore my database from the backup
>> it finished in less than a minute.
>> "Kim":
>> I have restored a database to the same instance as it was backup, but as
>> a copy of the original database (I need a couple of Stored Procedures),
>> but while restoring the database is to hanging with (Loading).
>> I've tried to drop the database but it says that it cannot be dropped
>> because it is marked for replication, I've then tried to drop the
>> replication on the database but it can't, it says that the database
>> cannot be opened because it is in the middle of a restore.
>> What to do? I'm pretty stuck...
>> I've running SQL Server 2000 on a windows 2003 server SP1, the database
>> is less than 100MB in size.
>> -Kim
Hi again,
I've removed the psysical files as suggested and runned the maintenance task
"check database integrity" on master (couldn't find optimize + fix
integrity).
This hasn't removed the entry from the enterprise manager... should I make
a new restore and then remove the entry ? (I don't need to restore it
anymore)
-KIm

Tuesday, March 20, 2012

Cannot Delete Job

quote:

> I used the DTS transfer Jobs to copy a couple of jobs from one server to
> another, I now aant to delete those jobs on the target server but I get

quote:

> error saying
> "Error14274" Cannot add, update, or delete a job (or its steps or
> schedule) that originated from an MSX server"
> How can I delete these jobs I urgently need to get rid of these....
> Thanks for your help,
> Brian
>

|||Dandy,
Thank you very much for your response, however, I am not using an MSX and
TXS server, at least not knowingly. When I right click Server Agent, I only
get the options to make the server a Master or a Target, is there anyway
that I can edit a system table to remove these?
The original server that the jobs came from will be going away today......
Thanks again,
Brian
"Dandy Weyn" <mct@.dandyman_nospam.net> wrote in message
news:40096d0e$0$773$ba620e4c@.news.skynet.be...

quote:

> You are using an MSX and TSX server, which means that the job you have on
> your server was targetted from a master server.
> The targetted client can not delete the job, it needs to be done on the
> master server.
> Check books online on master server jobs
> To defect a target server from a master server
> 1.. Expand a server group, and then expand a server configured as a

target

quote:

> server.
>
> 2.. Expand Management.
>
> 3.. Right-click SQL Server Agent, point to Multi Server Administration,
> and then click Defect from MSX.
>
> 4.. Click Yes to confirm that you want to defect this target server from

quote:

> master server.
> --
> Regards,
> Dandy Weyn
> MCSE, MCSA, MCDBA, MCT
> www.dandyman.net
> "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> news:%23Gw%23YoR3DHA.3936@.TK2MSFTNGP11.phx.gbl...
> an
>

|||Brian,
I am interested in the answer to this one too. My situation occurred becaus
e we renamed the server and sql name when jobs were still there. now the or
iginal server doesnt exist but the jobs do. I've tried removejobbyid method.
The next thing I was look
at is how to defect a master server. these servers are not really multi-hom
ed, they just think they are because the owner of the job is not part of the
new sql server. sp_help_job will tell you who owns it
Mitch|||Brian
check out Can't delete job.
Tibor put a script in there that fixed it for me
mitchsql

Cannot Delete Job

I used the DTS transfer Jobs to copy a couple of jobs from one server to
another, I now aant to delete those jobs on the target server but I get an
error saying
"Error14274" Cannot add, update, or delete a job (or its steps or
schedule) that originated from an MSX server"
How can I delete these jobs I urgently need to get rid of these....
Thanks for your help,
BrianYou are using an MSX and TSX server, which means that the job you have on
your server was targetted from a master server.
The targetted client can not delete the job, it needs to be done on the
master server.
Check books online on master server jobs
To defect a target server from a master server
1.. Expand a server group, and then expand a server configured as a target
server.
2.. Expand Management.
3.. Right-click SQL Server Agent, point to Multi Server Administration,
and then click Defect from MSX.
4.. Click Yes to confirm that you want to defect this target server from a
master server.
--
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Brian" <bfordSPAMOFF@.markem.com> wrote in message
news:%23Gw%23YoR3DHA.3936@.TK2MSFTNGP11.phx.gbl...
> I used the DTS transfer Jobs to copy a couple of jobs from one server to
> another, I now aant to delete those jobs on the target server but I get
an
> error saying
> "Error14274" Cannot add, update, or delete a job (or its steps or
> schedule) that originated from an MSX server"
> How can I delete these jobs I urgently need to get rid of these....
> Thanks for your help,
> Brian
>|||Dandy,
Thank you very much for your response, however, I am not using an MSX and
TXS server, at least not knowingly. When I right click Server Agent, I only
get the options to make the server a Master or a Target, is there anyway
that I can edit a system table to remove these?
The original server that the jobs came from will be going away today......
Thanks again,
Brian
"Dandy Weyn" <mct@.dandyman_nospam.net> wrote in message
news:40096d0e$0$773$ba620e4c@.news.skynet.be...
> You are using an MSX and TSX server, which means that the job you have on
> your server was targetted from a master server.
> The targetted client can not delete the job, it needs to be done on the
> master server.
> Check books online on master server jobs
> To defect a target server from a master server
> 1.. Expand a server group, and then expand a server configured as a
target
> server.
>
> 2.. Expand Management.
>
> 3.. Right-click SQL Server Agent, point to Multi Server Administration,
> and then click Defect from MSX.
>
> 4.. Click Yes to confirm that you want to defect this target server from
a
> master server.
> --
> Regards,
> Dandy Weyn
> MCSE, MCSA, MCDBA, MCT
> www.dandyman.net
> "Brian" <bfordSPAMOFF@.markem.com> wrote in message
> news:%23Gw%23YoR3DHA.3936@.TK2MSFTNGP11.phx.gbl...
> > I used the DTS transfer Jobs to copy a couple of jobs from one server to
> > another, I now aant to delete those jobs on the target server but I get
> an
> > error saying
> >
> > "Error14274" Cannot add, update, or delete a job (or its steps or
> > schedule) that originated from an MSX server"
> >
> > How can I delete these jobs I urgently need to get rid of these....
> >
> > Thanks for your help,
> >
> > Brian
> >
> >
>

Monday, March 19, 2012

Cannot create DSN to SQL Express

I installed SQL Express and was able to create a new DB using Management Studio. I was able to copy over tables from another DB using DTS, but strangely the Native Client would not work I had to use OLE for SQL Server.

But I am unable to create a DSN to the database using ODBC Administrator. I keep getting Login Timeout expired error message, using both Native Client and SQL Server drivers. What am I missing?

Thanks

Mark

WHat is the exact error message you are getting ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

This is the error message when I try using Native Client:

Attempting connection
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].
[Microsoft][SQL Native Client]Login timeout expired
[Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

This when I try SQL Server driver:

Attempting connection
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

BTW this is a local connection, I'm trying to get it all working on my laptop. I also tried playing with the SQLEXPRESS and CLient Protocols. I enabled Shared Memory, Named Pipes and TCP/IP, to no avail.

Thanks

Mark

|||

Finallly I managed to get it to work, when I realized the ODBC Administrator does not display the full name of the server. It displayed MARK_LAP, which is the name of my computer. I realized I needed to type in MARK_LAP\SQLEXPRESS which is the name of the server, and it works now. Connecting to [local] does not work either.

So, I thought I would post this in case someone else has the same problem.

Mark

|||The statement "MARK_LAP\SQLEXPRESS which is the name of the server" is a bit misleading as this is the name of the named instance which the service uses. YOu always have to name the instance with the "\instanceName" snippet if its not a default instance. Otherwise the client tries to connect to a default instance which is probably not installed in all cases.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

Cannot create DSN to SQL Express

But I am unable to create a DSN to the database using ODBC Administrator. I keep getting Login Timeout expired error message, using both Native Client and SQL Server drivers. What am I missing?

Thanks

Mark

WHat is the exact error message you are getting ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

This is the error message when I try using Native Client:

This when I try SQL Server driver:

Attempting connection
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

Thanks

Mark

|||

So, I thought I would post this in case someone else has the same problem.

Mark

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

Thursday, March 8, 2012

Cannot copy the mdf file after processing

I have a windows service that connects to a regular sql server 2005 database and basically bulk copies data into a SQL express database. Afterwards, I just want to copy the MDF file into a different directory. I keep getting the "Process cannot access file because it is being used by another process" error. I've tried changing the connection strings but nothing seems to work. I'm closing the connections in the code as well. Here is the code. Any thoughts or help would be appreciated. RefreshDB calls Sync 3 times and if all three calls are successful, it attempts to copy the database file to the specified location. This is where I get the error.

Public Function RefreshDB() As Boolean
Dim success As Boolean = True
Dim tables() As String = {"Job", "Equipment", "PMScheduled"}
For Each tableName As String In tables
If SyncTable(tableName) = False Then
success = False
Exit For
End If
Next
If success Then
'copy the new database to the target directory
Try
File.Copy(My.Settings.DBFilePath, My.Settings.TargetDirectory + "\EMField.mdf")
Catch ex As Exception
My.Application.Log.WriteEntry(ex.Message + "(RefreshDB)", TraceEventType.Critical)
Return False
End Try
End If
Return success
End Function

Private Function SyncTable(ByVal tableName As String) As Boolean
Dim reader As SqlDataReader
Dim sourceViewName As String = String.Format("EMField{0}View", tableName)
Dim connectionString As String = My.Settings.EMFieldConnectionString
'insert the path to the database into the connectionstring
connectionString = connectionString.Replace("[DBFilePath]", My.Settings.DBFilePath)
Try
'clear the target table first
Using targetConnection As New SqlConnection(connectionString)
Using truncateCommand As New SqlCommand(String.Format("TRUNCATE TABLE {0}", tableName), targetConnection)
targetConnection.Open()
truncateCommand.ExecuteNonQuery()
targetConnection.Close()
End Using
End Using
'create a datareader from the source database
Using sourceConnection As New SqlConnection(My.Settings.EMLiteConnectionString)
Using readCommand As New SqlCommand(String.Format("SELECT * FROM {0}", sourceViewName), sourceConnection)
sourceConnection.Open()
reader = readCommand.ExecuteReader
BulkCopy(tableName, reader, connectionString)
reader.Close()
sourceConnection.Close()
End Using
End Using
Return True
Catch ex As SqlException
My.Application.Log.WriteEntry(ex.Message + "(sync)", TraceEventType.Critical)
Return False
End Try
End Function

Public Sub BulkCopy(ByVal tableName As String, ByRef reader As SqlDataReader, ByVal connectionString As String)
Try
'bulk copy from source to target database
Using bulkCopy As New SqlBulkCopy(connectionString)
bulkCopy.DestinationTableName = tableName
bulkCopy.WriteToServer(reader)
bulkCopy.Close()
End Using
Catch ex As SqlException
'throw exception back to calling sub
Throw ex
End Try
End Sub

hi,

the database is probably still in use and an active connection is still referencing it, so even if the database autoclose property is set (for SQLExpress created databases), the physical file(s) is/are still locked and file system operations are not allowed..

first verify no active connection is still alive.. consider that connection pooling will keep them in the pool for about 1 minute after the connection has been disposed and released..

again, even if the autoclose property set is the default for SQLExpress instances, consider first "detaching" the database via sp_detach_db before performing file system operations...

regards

|||

Thanks for your help. I can say with certainty that no other process is connected the sql express database because I am testing it on my own machine. That leaves the connection pooling, but I put pooling=false in the connection string. I have never "detached" a sql express database before. So where exactly (ie what database) do I run this sp_detach_db and are there any consequences in doing so? In other words when the service runs again, will I need to reattach the database before connecting to it?

Thanks,

Bob

|||

hi Bob,

Coach24 wrote:

Thanks for your help. I can say with certainty that no other process is connected the sql express database because I am testing it on my own machine. That leaves the connection pooling, but I put pooling=false in the connection string. I have never "detached" a sql express database before. So where exactly (ie what database) do I run this sp_detach_db

sp_detach_db "unregister" the database from it's related SQL Server instance so that file system operations are allowed on the database's physical files..

and are there any consequences in doing so? In other words when the service runs again, will I need to reattach the database before connecting to it?
Thanks,
Bob

no consequences but, obviously, any connection to the unregistered database will fail until you "reattach" it via the

USE [master]

CREATE DATABASE [test] ON

( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Data\test.mdf' ),

( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Data\test_log.LDF' )

FOR ATTACH;

statement... so, yes, you have to reattach the database before referencing it..

regards

|||

While I'm certain your suggestion works, I ended up not needing it. As it turns out, even though I had pooling = false in the connection string, and I closed the connection in the code, the connection was still open when I attempted the File.Copy statement. I put a System.Threading.Thread.Sleep(5000) right before the File.Copy statement and that fixed the problem. Thanks again for your help.

Bob

cannot copy sqlexpress to another pc for vb.net 2.0 project update

Hi. I have done alot of searching around but can't find answer to this specific problem.

Here is my connection string in vb.net app config

The database is locally attached to the vb.net project residing in a data directory in the project. I am testing installation on a virtual pc - with no sql express managment or other sql server databases attached.

When I do a vb.net setup project and run this on, there is no problem. However, once having done that, when I want to update the app, I can't just copy in the new database along with exe. I get the error:"sql server does not allow remote connections (provider:sql network interfaces error 26 - error locating server/instance specified).

Is this a problem of the virtual PC? I am testing this because I need to be able to send updates to another local machine without using setup program.

Hi,

the destination machine where you copy the files on, does that have SQL Server Express installed ? Otherwise you won′t be able to use the .\SQLEXPRESS instance which points to a local SQLExpress instance on that computer. If there is a SQLExpress instance installed on that machine, make sure you enabled remote connections on this instance. I made a screencast for that, which can be found on my site in the screencast section which will show you how to enabled the remote conenction feature.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Wednesday, March 7, 2012

Cannot copy indexes w 2005 Import/Export Wizard

In SQL 2000, the 'Copy SQL Server Objects' task allows 'copy indexes' under
'Advanced Copy Options' when transferring tables. But I cannot see where the
SQL 2005 Import and Export Wizard allows this option. Is there an easy way
to do this (I hope) ?
Hello Mark,
You could check "Transfer SQL server objects" task in SSIS project in
VS.net 2005. DTS is ugpraded to SSIS in SQL 2005.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Cannot copy indexes w 2005 Import/Export Wizard
>thread-index: AcYnif7U0qKGdOuRRFuiyisljvKhWg==
>X-WBNR-Posting-Host: 67.96.43.11
>From: "=?Utf-8?B?TWFya0dzY2g=?=" <markgsch@.noemail.noemail>
>Subject: Cannot copy indexes w 2005 Import/Export Wizard
>Date: Wed, 1 Feb 2006 15:48:26 -0800
>Lines: 4
>Message-ID: <D1072BA0-E4FF-4E06-8F4C-018F334730F9@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:419786
>X-Tomcat-NG: microsoft.public.sqlserver.server
>In SQL 2000, the 'Copy SQL Server Objects' task allows 'copy indexes'
under
>'Advanced Copy Options' when transferring tables. But I cannot see where
the
>SQL 2005 Import and Export Wizard allows this option. Is there an easy
way
>to do this (I hope) ?
>

Cannot copy indexes w 2005 Import/Export Wizard

In SQL 2000, the 'Copy SQL Server Objects' task allows 'copy indexes' under
'Advanced Copy Options' when transferring tables. But I cannot see where the
SQL 2005 Import and Export Wizard allows this option. Is there an easy way
to do this (I hope) ?Hello Mark,
You could check "Transfer SQL server objects" task in SSIS project in
VS.net 2005. DTS is ugpraded to SSIS in SQL 2005.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Cannot copy indexes w 2005 Import/Export Wizard
>thread-index: AcYnif7U0qKGdOuRRFuiyisljvKhWg==
>X-WBNR-Posting-Host: 67.96.43.11
>From: "examnotes" <markgsch@.noemail.noemail>
>Subject: Cannot copy indexes w 2005 Import/Export Wizard
>Date: Wed, 1 Feb 2006 15:48:26 -0800
>Lines: 4
>Message-ID: <D1072BA0-E4FF-4E06-8F4C-018F334730F9@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:419786
>X-Tomcat-NG: microsoft.public.sqlserver.server
>In SQL 2000, the 'Copy SQL Server Objects' task allows 'copy indexes'
under
>'Advanced Copy Options' when transferring tables. But I cannot see where
the
>SQL 2005 Import and Export Wizard allows this option. Is there an easy
way
>to do this (I hope) ?
>

Cannot copy indexes w 2005 Import/Export Wizard

In SQL 2000, the 'Copy SQL Server Objects' task allows 'copy indexes' under
'Advanced Copy Options' when transferring tables. But I cannot see where the
SQL 2005 Import and Export Wizard allows this option. Is there an easy way
to do this (I hope) ?Hello Mark,
You could check "Transfer SQL server objects" task in SSIS project in
VS.net 2005. DTS is ugpraded to SSIS in SQL 2005.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>Thread-Topic: Cannot copy indexes w 2005 Import/Export Wizard
>thread-index: AcYnif7U0qKGdOuRRFuiyisljvKhWg==>X-WBNR-Posting-Host: 67.96.43.11
>From: "=?Utf-8?B?TWFya0dzY2g=?=" <markgsch@.noemail.noemail>
>Subject: Cannot copy indexes w 2005 Import/Export Wizard
>Date: Wed, 1 Feb 2006 15:48:26 -0800
>Lines: 4
>Message-ID: <D1072BA0-E4FF-4E06-8F4C-018F334730F9@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:419786
>X-Tomcat-NG: microsoft.public.sqlserver.server
>In SQL 2000, the 'Copy SQL Server Objects' task allows 'copy indexes'
under
>'Advanced Copy Options' when transferring tables. But I cannot see where
the
>SQL 2005 Import and Export Wizard allows this option. Is there an easy
way
>to do this (I hope) ?
>

cannot copy files

I copied a database using backup and restore from Sql server 2000 to Sql server 2005. I noticed the data(mdf) and log(ldf) files did not copy. when I try to do a copy and past it gives me an error: cannot copy lof: it is being used by another person or program. Close all programs and try again. Does this mean I have to stop both servers to copy between them? Please help.just to clarify, did you successfully restore the db on 2005? if so, then I assure you the mdf and ldf are there. maybe they are not where you think they should be however.

to find out where they are, do this:

use MyDatabase
exec sp_helpfile

Cannot copy column names view result set

In SQL 2005 - when I display the results of a View and Copy all rows and columns, the resulting Paste in Excel does not include the column names.

How can I set SQL 2005 so the names of the columns will come along with the content of the copy function?

Background:

When I am using a SQL Query (instead of a view) I have the ability to control whether or not I am able to Include the Column Headers when copying or saving results. The control exists in the Options > Query Results > Results to Grid > Include column headings etc.

My question is how to get this same ability when attempting to copy the results of a VIEW vs. a Query.

Thank you,

Poppa Mike

The same way. Instead of opening the view into that grid thingy, open a query window and do a select from the view.|||

Yes Michael - I've thought of that but it causes me to take two steps. One to create the view and a second to get the results of the view by running a query against the view. I'd like to avoid the SQL Two-Step and just have the ability to copy the results from the view like I used to be able to do in SQL 2000. I appreciate your thoughts.

Regards, Poppa Mike

|||I was searching for the the same thing ..what i did was instead of selecting results to grid..choose the result as result to text and U can open the result file in excel and sort it out.

Cannot copy : Insufficient system resources

Production Server: Win2k Advanced Server, SQL 2k Advanced Server, Both fully
patched, 4 processors, 5 GB RAM, 320 GB partition, 68 GB DataBase, SAN, 2 2GB
Fiber NICS teamed
Development Server: Win2k Server, SQL 2k Server, two processors, 2 GB RAM,
Raid 5 SCSI controller, 4 100 mb NICS teamed
Both servers have lots of room on the partition.
We've been refreshing the development server with fresh production data
every three months. My method for doing this has been to do a local backup of
the production server, then copy the bak file to the development server. This
has been working for several years. The bak file is now 70 GB. The last time
it worked the bak file was around 65 GB. Last night the copy of the bak file
over the network failed about halfway through with a popup:
"Cannot copy prd. bak : Insufficient system resources exist to complete the
requested service" There are no entries in either server's application or
system event logs. I've read the MSFT KB Article 259837 but that doesn't seem
to apply because (a) the failure occured about one hour into the copy process
and (b) both servers are fully patched.
Developers are beating on me to get this done tonight. I suspect in the long
run, I will have to get something like SQL lite speed. But I would like a
quick fix for tonight. I would prefer not to shut down the production db and
copy the individual files.
Here are my thoughts:
1. Would I have better luck if I backed up with a UNC path to the
development server?
2. Can I compress the bak file with something?
Any suggestions?Personally, I prefer working with UNC paths for backups.
HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"MangroveGeek" <carl@.tenthousandislands.net(DoNotSpam)> wrote in message
news:130BD949-316B-44F2-9117-B30B9477D24C@.microsoft.com...
> Production Server: Win2k Advanced Server, SQL 2k Advanced Server, Both
> fully
> patched, 4 processors, 5 GB RAM, 320 GB partition, 68 GB DataBase, SAN, 2
> 2GB
> Fiber NICS teamed
> Development Server: Win2k Server, SQL 2k Server, two processors, 2 GB RAM,
> Raid 5 SCSI controller, 4 100 mb NICS teamed
> Both servers have lots of room on the partition.
> We've been refreshing the development server with fresh production data
> every three months. My method for doing this has been to do a local backup
> of
> the production server, then copy the bak file to the development server.
> This
> has been working for several years. The bak file is now 70 GB. The last
> time
> it worked the bak file was around 65 GB. Last night the copy of the bak
> file
> over the network failed about halfway through with a popup:
> "Cannot copy prd. bak : Insufficient system resources exist to complete
> the
> requested service" There are no entries in either server's application or
> system event logs. I've read the MSFT KB Article 259837 but that doesn't
> seem
> to apply because (a) the failure occured about one hour into the copy
> process
> and (b) both servers are fully patched.
> Developers are beating on me to get this done tonight. I suspect in the
> long
> run, I will have to get something like SQL lite speed. But I would like a
> quick fix for tonight. I would prefer not to shut down the production db
> and
> copy the individual files.
> Here are my thoughts:
> 1. Would I have better luck if I backed up with a UNC path to the
> development server?
> 2. Can I compress the bak file with something?
> Any suggestions?

Cannot copy : Insufficient system resources

Production Server: Win2k Advanced Server, SQL 2k Advanced Server, Both fully
patched, 4 processors, 5 GB RAM, 320 GB partition, 68 GB DataBase, SAN, 2 2G
B
Fiber NICS teamed
Development Server: Win2k Server, SQL 2k Server, two processors, 2 GB RAM,
Raid 5 SCSI controller, 4 100 mb NICS teamed
Both servers have lots of room on the partition.
We've been refreshing the development server with fresh production data
every three months. My method for doing this has been to do a local backup o
f
the production server, then copy the bak file to the development server. Thi
s
has been working for several years. The bak file is now 70 GB. The last time
it worked the bak file was around 65 GB. Last night the copy of the bak file
over the network failed about halfway through with a popup:
"Cannot copy prd. bak : Insufficient system resources exist to complete the
requested service" There are no entries in either server's application or
system event logs. I've read the MSFT KB Article 259837 but that doesn't see
m
to apply because (a) the failure occured about one hour into the copy proces
s
and (b) both servers are fully patched.
Developers are beating on me to get this done tonight. I suspect in the long
run, I will have to get something like SQL lite speed. But I would like a
quick fix for tonight. I would prefer not to shut down the production db and
copy the individual files.
Here are my thoughts:
1. Would I have better luck if I backed up with a UNC path to the
development server?
2. Can I compress the bak file with something?
Any suggestions?Personally, I prefer working with UNC paths for backups.
HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/defaul...kb;en-us;555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"MangroveGeek" <carl@.tenthousandislands.net(DoNotSpam)> wrote in message
news:130BD949-316B-44F2-9117-B30B9477D24C@.microsoft.com...
> Production Server: Win2k Advanced Server, SQL 2k Advanced Server, Both
> fully
> patched, 4 processors, 5 GB RAM, 320 GB partition, 68 GB DataBase, SAN, 2
> 2GB
> Fiber NICS teamed
> Development Server: Win2k Server, SQL 2k Server, two processors, 2 GB RAM,
> Raid 5 SCSI controller, 4 100 mb NICS teamed
> Both servers have lots of room on the partition.
> We've been refreshing the development server with fresh production data
> every three months. My method for doing this has been to do a local backup
> of
> the production server, then copy the bak file to the development server.
> This
> has been working for several years. The bak file is now 70 GB. The last
> time
> it worked the bak file was around 65 GB. Last night the copy of the bak
> file
> over the network failed about halfway through with a popup:
> "Cannot copy prd. bak : Insufficient system resources exist to complete
> the
> requested service" There are no entries in either server's application or
> system event logs. I've read the MSFT KB Article 259837 but that doesn't
> seem
> to apply because (a) the failure occured about one hour into the copy
> process
> and (b) both servers are fully patched.
> Developers are beating on me to get this done tonight. I suspect in the
> long
> run, I will have to get something like SQL lite speed. But I would like a
> quick fix for tonight. I would prefer not to shut down the production db
> and
> copy the individual files.
> Here are my thoughts:
> 1. Would I have better luck if I backed up with a UNC path to the
> development server?
> 2. Can I compress the bak file with something?
> Any suggestions?

Cannot copy : Insufficient system resources

Production Server: Win2k Advanced Server, SQL 2k Advanced Server, Both fully
patched, 4 processors, 5 GB RAM, 320 GB partition, 68 GB DataBase, SAN, 2 2GB
Fiber NICS teamed
Development Server: Win2k Server, SQL 2k Server, two processors, 2 GB RAM,
Raid 5 SCSI controller, 4 100 mb NICS teamed
Both servers have lots of room on the partition.
We've been refreshing the development server with fresh production data
every three months. My method for doing this has been to do a local backup of
the production server, then copy the bak file to the development server. This
has been working for several years. The bak file is now 70 GB. The last time
it worked the bak file was around 65 GB. Last night the copy of the bak file
over the network failed about halfway through with a popup:
"Cannot copy prd. bak : Insufficient system resources exist to complete the
requested service" There are no entries in either server's application or
system event logs. I've read the MSFT KB Article 259837 but that doesn't seem
to apply because (a) the failure occured about one hour into the copy process
and (b) both servers are fully patched.
Developers are beating on me to get this done tonight. I suspect in the long
run, I will have to get something like SQL lite speed. But I would like a
quick fix for tonight. I would prefer not to shut down the production db and
copy the individual files.
Here are my thoughts:
1. Would I have better luck if I backed up with a UNC path to the
development server?
2. Can I compress the bak file with something?
Any suggestions?
Personally, I prefer working with UNC paths for backups.
HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default...b;en-us;555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"MangroveGeek" <carl@.tenthousandislands.net(DoNotSpam)> wrote in message
news:130BD949-316B-44F2-9117-B30B9477D24C@.microsoft.com...
> Production Server: Win2k Advanced Server, SQL 2k Advanced Server, Both
> fully
> patched, 4 processors, 5 GB RAM, 320 GB partition, 68 GB DataBase, SAN, 2
> 2GB
> Fiber NICS teamed
> Development Server: Win2k Server, SQL 2k Server, two processors, 2 GB RAM,
> Raid 5 SCSI controller, 4 100 mb NICS teamed
> Both servers have lots of room on the partition.
> We've been refreshing the development server with fresh production data
> every three months. My method for doing this has been to do a local backup
> of
> the production server, then copy the bak file to the development server.
> This
> has been working for several years. The bak file is now 70 GB. The last
> time
> it worked the bak file was around 65 GB. Last night the copy of the bak
> file
> over the network failed about halfway through with a popup:
> "Cannot copy prd. bak : Insufficient system resources exist to complete
> the
> requested service" There are no entries in either server's application or
> system event logs. I've read the MSFT KB Article 259837 but that doesn't
> seem
> to apply because (a) the failure occured about one hour into the copy
> process
> and (b) both servers are fully patched.
> Developers are beating on me to get this done tonight. I suspect in the
> long
> run, I will have to get something like SQL lite speed. But I would like a
> quick fix for tonight. I would prefer not to shut down the production db
> and
> copy the individual files.
> Here are my thoughts:
> 1. Would I have better luck if I backed up with a UNC path to the
> development server?
> 2. Can I compress the bak file with something?
> Any suggestions?

Sunday, February 19, 2012

Cannot connect to SQL Server

Recently, I installed a fresh copy of Windows Vista Business.

Then, I installed SQL Server 2005 Developer Edition.

Upon completion I get a message saying that I should update my SQL Server with SQL

Server SP1.

Good. Go to Microsoft.com, download and installed it. Update succesful.

Then I get another message telling me that I need to update to SQL Server 2005 SP2

because that one is also need it for compatibility with Windows Vista.

Good. Go again to Microsoft.com and install SP2.

Trying to connect to the server is imposible. When I try I get the folowing message:

Cannot connect to Val-PC ( the server name )

Can anyone help? It would be very much appriciated.

Thanks.

What is the state of the error message ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de|||It seems that you are using windows authentication. check whether this user has enough permission to the server|||

For some reason, as soon as Service Pack 2 was installed successfully, the problem

was gone. I could connect to the server right away.

I understand by looking at the documentation that previous versions of SQL Server 2005 have

compatibility problems with Windows Vista and Service Pack 2 is supposed to address them.

Thanks for the help, anyway!

Sunday, February 12, 2012

Cannot connect to Local after change domain password

I have a Developer copy of Sql Server on my XP workstation, which I use to
access the Domain server's Sql Data and a local (name of my workstation) set
of practice data in a seperate sql server registration.
If I change my password on the domain, I can no longer connect to the local
server.
I'm running mixed mode on both with the sa login and a non-blank password.
I uninstalled my local copy of sql server, deleted the registry files I
could find, re-installed sql to a different drive partition, and then it
immediately showed the domain server registration but logon failure to the
local server registration.
I then changed my domain password back to what it used to be and everything
works fine. Problem is, my domain password is compromised and I need to
change it.
How do I clear all the real data about my install or get it to accept my new
authentication?
Bob Graham
My problem seems to have gone away after changing my network password back
to the same new one a second time.
As though it took several 'hits' to get sql to recognize the password
change.
Bob
"Bob Graham" <rvgtech@.pacbell.net> wrote in message
news:Io8ce.2370$zu.852@.newssvr13.news.prodigy.com. ..
> I have a Developer copy of Sql Server on my XP workstation, which I use
to
> access the Domain server's Sql Data and a local (name of my workstation)
set
> of practice data in a seperate sql server registration.
> If I change my password on the domain, I can no longer connect to the
local
> server.
> I'm running mixed mode on both with the sa login and a non-blank password.
> I uninstalled my local copy of sql server, deleted the registry files I
> could find, re-installed sql to a different drive partition, and then it
> immediately showed the domain server registration but logon failure to the
> local server registration.
> I then changed my domain password back to what it used to be and
everything
> works fine. Problem is, my domain password is compromised and I need to
> change it.
> How do I clear all the real data about my install or get it to accept my
new
> authentication?
> Bob Graham
>

Cannot connect to Local after change domain password

I have a Developer copy of Sql Server on my XP workstation, which I use to
access the Domain server's Sql Data and a local (name of my workstation) set
of practice data in a seperate sql server registration.
If I change my password on the domain, I can no longer connect to the local
server.
I'm running mixed mode on both with the sa login and a non-blank password.
I uninstalled my local copy of sql server, deleted the registry files I
could find, re-installed sql to a different drive partition, and then it
immediately showed the domain server registration but logon failure to the
local server registration.
I then changed my domain password back to what it used to be and everything
works fine. Problem is, my domain password is compromised and I need to
change it.
How do I clear all the real data about my install or get it to accept my new
authentication?
Bob GrahamMy problem seems to have gone away after changing my network password back
to the same new one a second time.
As though it took several 'hits' to get sql to recognize the password
change.
Bob
"Bob Graham" <rvgtech@.pacbell.net> wrote in message
news:Io8ce.2370$zu.852@.newssvr13.news.prodigy.com...
> I have a Developer copy of Sql Server on my XP workstation, which I use
to
> access the Domain server's Sql Data and a local (name of my workstation)
set
> of practice data in a seperate sql server registration.
> If I change my password on the domain, I can no longer connect to the
local
> server.
> I'm running mixed mode on both with the sa login and a non-blank password.
> I uninstalled my local copy of sql server, deleted the registry files I
> could find, re-installed sql to a different drive partition, and then it
> immediately showed the domain server registration but logon failure to the
> local server registration.
> I then changed my domain password back to what it used to be and
everything
> works fine. Problem is, my domain password is compromised and I need to
> change it.
> How do I clear all the real data about my install or get it to accept my
new
> authentication?
> Bob Graham
>

Sunday, March 25, 2012

Cannot drop database (hanging in loading and marked for replication)

Tuesday, March 20, 2012

Cannot Delete Job

Cannot Delete Job

Monday, March 19, 2012

Cannot create DSN to SQL Express

Cannot create DSN to SQL Express

Thursday, March 8, 2012

Cannot copy the mdf file after processing

cannot copy sqlexpress to another pc for vb.net 2.0 project update

Wednesday, March 7, 2012

Cannot copy indexes w 2005 Import/Export Wizard

Cannot copy indexes w 2005 Import/Export Wizard

Cannot copy indexes w 2005 Import/Export Wizard

cannot copy files

Cannot copy column names view result set

Cannot copy : Insufficient system resources

Cannot copy : Insufficient system resources

Cannot copy : Insufficient system resources

Sunday, February 19, 2012

Cannot connect to SQL Server

Sunday, February 12, 2012

Cannot connect to Local after change domain password

Cannot connect to Local after change domain password

Sql Cannot connect

Blog Archive

About Me