Copying Files Over Workgroup

Apr 8, 2004

I want to copy the database backup files to another server as a part of logshipping implementation. tried using xcopy it doesn't work.
it says "invalid drive specification"
also tried using a dll, the dll does the copying i just had to call the dll through an sp, while trying this the QA hanged, tried killing the process but the process didn't kill, i had to restart the service.

the network in not a domain its workgroup.
with sql server 2000 on win2k server.

any inputs are welcome.
thanks in advance
regards,
harshal.

View 5 Replies


ADVERTISEMENT

Copying DAT Files In 6.5

Mar 30, 2000

I have an 8 GB SQL 6.5 database that I need to move to another server. I know I can create the devices and the database on the new server exactly as they were created on the old server then replace the new DAT files with the old (after shuting down SQL Server). The issue I am running into is that the sort order and character sets on the two servers are different. Will this have an effect if I copy the DAT files? Am I better off using BCP? I'd hate to use BCP because of the time that it will take to move the files.

Thanks for you help

View 4 Replies View Related

Copying DB Files

Dec 1, 2005

Hi,
I would like to know where do I copy .mdf and .ldf files, for it to show up on the enterprise manager. I havent created the db using the enterprise manager, but am copying it from another location. So can you tell me what I need to do for this.
thanks

View 5 Replies View Related

Copying Files Between Servers

May 18, 2006

I'm trying to copy files between 2 servers on a local network from within aSQL Job (and Query Analyzer) using xp_cmdshell.xcopy but get an accessdenied message returned.I'm able to successfully do the copy from within a command window so thinkthe problem has something to do with using the default SQL Server accountbut as yet I don't know how to resolve.Any help/suggestions would be much appreciated.

View 1 Replies View Related

Copying Backup Files To Different Locations

Oct 25, 2007

I have a maintenace plan that copies production backup files in DR server. The production is mission critical and runs 24/7. We have a round the clock backups. Backups include full backup, differential backups and log backups.

To secure these backup files, I was asked to keep these files in different server at the same time as it goes to DR Server. As I am using maintenace plan for scheduled backups that go to DR server and I had no idea how to incorparate copying these files to another server in the same maintenence plan. I came up with idea using xp_cmdshell stored proc that I attached on the maintenace plan in executeT-SQL statement task. The statement looks like


Exec master..xp_cmdshell 'copy e:DRbackup*.bak \fgh-sql16ackup$'

Above statement copy all backup files on DR server and takes these to remote server called fgh-sql16.

My question here is ....are there any other effective methods to copy backup files simultaneously to different servers via maintenace plan.

Thanks all

View 6 Replies View Related

Saving Or Copying Enterprise Manager Files

Dec 11, 2000

hello all,

Does anyone know know which files Enterprise Manager uses to save the settings (i.e. registered computers and groups)?

I would like to reinstall enterprise manager, but I do not want to reconfigure all of the server registrations.

Thanks,

Matt

View 1 Replies View Related

Integration Services :: Copying Files From One Server To Another

Aug 25, 2015

I am copying files from one server to another and I have specific format for all jpg files. which is in 3 format

filename_reg.jpg,
filename_kat,
filename_pag

and I want to copy _reg files only using file system task.I have already created file sytem task using foreach loop and it is copying files but I want to copy only _reg files.

View 5 Replies View Related

Xcopy Not Copying All Files In Stored Procedure

Apr 8, 2008

I am executing xcopy with xp_cmdshell in a stored procedure and it is not copying all the files. There are about 600 files in the source directory and only around 190 are copied to the destination.

The command in the stored procedure is this N'xcopy c:source*.* c:dest'

Help please!!!!

Thanks,
Saied

View 14 Replies View Related

Why Is Simply Copying The Mdf/ldf Files NOT A Good Way To Backup?

Mar 12, 2008

Hi.

What I want to know is what the issues/scenarios are of only using copies of mdf/ldf files as backups.

TIA.

View 3 Replies View Related

DTS: Copying Data From Text Files To A SQL Server Table

Sep 10, 2001

Hi all,

I got a situation here.....

From a source table (in SERVER1) I get ids of candidates and from another source (in SERVER2) I get their CVs (text files stored in various Folders). My destination table (in SERVER3) has two fields, CandidateId & CandidateCV.

I have to transfer the data in above fashion for nearly 1 million records.
How can I write a DTS package which picks up the text file from SERVER2 based on the CandidateId which comes from SERVER1? Probably I need some kind of looping mechanism which changes the candidate id & his CV file.

Can anyone help???

Thanks...

View 2 Replies View Related

Copying Files From A Sharepoint Location To Local Machine Using SSIS

Apr 20, 2007

I have to copy files from a sharepoint or extranet location (basically https://.....) location to my local server using SSIS.



Any kind of early help would be really great.

View 1 Replies View Related

How To Set Access Workgroup

Jan 20, 2006

My package is to copy data from an Access 97 db into a SQL2k5 table.

Problem is that the 'mdb' is subscribed to a 'mdw' workgroup and I have been unable to workout / read how to get the SSIS manager to join the workgroup. Connection fails because "...you don't have necessary permission..."

I was able to do this previously for SQL 2k by messing with the registry, but I'm now on unfamiliar teritory.

Any answers? Cheers.

View 2 Replies View Related

Workgroup Upgrade

Jul 6, 2007

Has anyone had problems like this.
I recently got SQL Server 2005 Workgroup edition. I did the normal
'read everything I could' to make sure I was getting the correct version for my business.
After having to wait 4 weeks to upgrade, as we were waiting for our accounting system to be upgraded to come inline with SQL 2005, I came across the problem where DTS is not really compatible to the degree I needed with this edition.
I have since gone back to the reseller and they say we can't exchange it for Standard edition as 4 weeks has passed.
The only thing we can do is pay out (1 month later) another £6,000 to get the version we need, totaling £11,000
Being that we are a small business, paying out another £6,000 isn't an option.
Does anyone have any good advise on this?
Many thanks
Scott

View 4 Replies View Related

Domain Vs. Workgroup

Jan 31, 2008

My company has a large-ish website and we are migrating to new
servers. There will be a web server (accessible to the world) backed
by a SQL Server 2005 Standard server (only accessible by the web server and
through VPN/Remote Desktop to administrators and our internal
network). We can either put the database server (which is not in a
cluster) on our domain or leave it in a workgroup. My first thought
is leave it in a workgroup simply for security and reliability (i.e.
if the DC goes down or loses connectivity), but people here are
disagreeing with me.

Should I put the database server (which is not used internally at all)
on the domain or leave it in a workgroup?

View 1 Replies View Related

Domain Vs. Workgroup

Jan 31, 2008

My company has a large-ish website and we are migrating to new
servers. There will be a web server (accessible to the world) backed
by a SQL Server 2005 Standard server (only accessible by the web server and
through VPN/Remote Desktop to administrators and our internal
network). We can either put the database server (which is not in a
cluster) on our domain or leave it in a workgroup. My first thought
is leave it in a workgroup simply for security and reliability (i.e.
if the DC goes down or loses connectivity), but people here are
disagreeing with me.

Should I put the database server (which is not used internally at all)
on the domain or leave it in a workgroup?

View 1 Replies View Related

Connecting To MDF File Over Workgroup

Aug 16, 2006

Hi
I've build a client management (Windows) application in VS2005 which works fine on the local development machine but falls over when trying to connect to the SQL Server Express file located on a second machine on the same Workgroup. Several of the apllications will connect to the database file from networked computers.
The error I get when testing the connection or trying to connect via the App is:---------------------------------------------------------------The file "Z:BushBreaks.MDF" is on a network path that is not supported for database files.An attempt to attach and auto-named database for file z:ushbreaks.mdf failed. A database with the same name exists, or specified file cannot be opened or it is on a UNC share.---------------------------------------------------------------
How can I configure this database and/or connection to be able to allow connections to the MDF file? Please note that security is not an issue if that is at all relevant.
Many ThanksJohn

View 1 Replies View Related

Cluster On Workgroup And Then Domain

Sep 26, 2005

We have a set of client servers which will include a SQL Server 2000 active/passive cluster attached to a SAN. We have all the equipment here (no attachment to client site) to configure. My worry is since it will have to be setup as a workgroup, and then shipped to client to add to their domain, is this a doable option. has anyone had to do this or tried this? Or would we be better off shipping whole thing to client and setting up cluster there?

View 6 Replies View Related

Express Vs Workgroup - Should I Upgrade?

Apr 26, 2007

Hello,

I am currently hosting my ecommerce site on a dedicated server with dual AMD processors and 2 gigs of ram. I have on average 20 people on the site at one time.

on this server i have sql express, from which i understand, only utilizes one of the processors and 1gig of ram. I have the choice to pay an extra 150 a month to have my host put sql workgroup on my system.

My question is, will i notice any kind of real performace boost by upgrading. Or at the level that i am at, there wont be much difference?

Any help would be very useful.

Thanks

View 5 Replies View Related

SQL 2005 Workgroup Vs. Standard

Jul 18, 2007

I would like to ask regarding sa performance difference between the two version of SQL 2005. Which is better the SQL 2005 workgroup or the standard edition..?

Darren Bernabe Blanco

View 1 Replies View Related

SQL Server On Windows XP Workgroup

Jul 23, 2005

We're running a simple network with a Windows XP Pro machine runningSQL Server. I have a VB application that runs fine on machines withinthe workgroup. There are several computers outside the workgroup butphysically reside on the network that generate OLEDB errors. I knowwith certainty it is establishing a connection to SQL Server. Theerror occurs on a SELECT statement. The user has read and writepermission to the database. I even tried giving the user Admin rightsjust as a test and it still generated the error. Is this a result ofthe cnmputer not being a member of the Workgroup? Thanks.Damon

View 4 Replies View Related

SQL Server And Workgroup Networks, How?

Jan 4, 2006

How to establish connection string for sql server on non-domain network?

View 2 Replies View Related

Trusted Security In A Workgroup

Jan 17, 2007

Good afternoon,so here is a question I've been struggling with that I thought folks onthe forum might have some wisdom kicking around on. I have severalproduction servers that are living within a workgroup where there is nodomain controler. However, I would still like to set up trustedsecurity for my asp.net applications. IIS is living on one server, andSQL server on another. Is there a way I can add a trusted relationshipto the machine and account that the IIS app is running under?My thanks in advance!Jonathan Wiggs*** Sent via Developersdex http://www.developersdex.com ***

View 1 Replies View Related

MS Sql Server On Workgroup Not Domain.

Jul 20, 2005

Hi have a small network setup and have MS sql server on workstation.Can access it locally but cannot access it from other work stations.I am assuming it is some sort of logon error, being it is not adomain. Any ideas on getting by this ?

View 2 Replies View Related

Log Shipping In Workgroup Environment

Jul 19, 2007

I have two SQL servers that I am trying to setup log shipping on. I am unable to get the restore of the initial database to work on the standby server. It gets a "unable to open file" error when trying to do the restore.







I have created a "syncaccount" user on both machines, and both have same password. I have used configuration manager to set the user/password for the agents on both servers.



I have given syncaccount admin access. I have added syncaccount to the shares on both servers.



Wy am I getting this error.



Does anyone else think it is VERY difficult to make this function work.

View 7 Replies View Related

SQL Express Or Workgroup? How Do I Tell What Is Installed And Where?

Apr 5, 2007

Hi guys,



I am a Systems Engineer and was sent on a job to a site that has a newly created SBS 2003 R2 Premium box which was OEM pre-installed from Dell. The SBS install was evidently finished off by the I.T. guys at the site. Now along comes some software house to install their propritery application. During this install process, the software guy was unable to find an instance of SQL running and installs SQL 2005 Express and the Express Studio management console. He installs his application and before he leaves says to the I.T. guys "Oh and by the way, there is a 4GB limit per database on SQL Express. You will have to change that to workgroup edition before the data grows too big. Have a nice day byeee!!!".



The I.T. guys go "Huh? Lets call James." So now I have to get this database off the SQL Express instance and onto a workgroup instance. I understand about detaching a database and re-attaching it. No prob there. What is confusing me is when I look at the default instance which should be a Workgroup instance, all I see is an Express instance.



What I am planning to do is rip out all the SQL 2005 stuff, leaving behind only Sharepoint, SBSmonitoring and WSUS stuff. The, using the SBS Premium cd's, install SQL 2005 again and updating the service packs for it again. Then mount the databases under it and get the software guys back in to reconfigure their application if need be.



Thing is, I have no idea how to sort it all out other than "Add remove programs" in control panel and remove the SQL 2005 stuff. What scares me however, is the thought of also removing the Sharepoint, WSUS and SBSMonitoring databases too.



Can someone help me with a procedure for sorting it out? How can I tell what I should uninstall and what I shouldn't? How do I tell if workgroup is already there and why did express steal the default instance?



Cheers

James



View 1 Replies View Related

Mirroring On Workgroup Servers

Apr 6, 2007

I have 2 web servers in a workgroup both running SQl 2005 SP2. both servers have a user called sqluser which is the main login for sql on both boxes. When I use the mirroring wizard it creates the end points ok but does not like the fqdn of each server, these are called webserver1 and webserver2. Is the problem because of the name and lack of domain ? Can I add a user for server1 on server2 or do I need to use certificates to get Mirroring working in this type of environment ?

View 10 Replies View Related

Upgrade From Workgroup To Standard

Jul 6, 2007

We have got the wrong version of SQL Server 2005 due to not having SSIS. We have loads of DTS packages running and I have tried to import them and its shows no SSIS service installed.

Is the route to upgrade straight forward? We have a couple of databases running on 2005 upgraded from 2000 but most still are active on 2000.

Cheers

Scott

View 1 Replies View Related

Is It Possible To Run A Website With Sql 2005 Workgroup?

Dec 3, 2007



I am a very beginner in setting sql server 2005.
I was not sure if sql 2005 workgroup edition supported online database when I compared on MSN comparison chart.
Does workgroup edition only work in local computers?
Can I install 2005 workgroup edition on a windows server and run a business website requiring database?Thanks in advance.

View 1 Replies View Related

Workgroup -&&> Domain Impersonation

Jul 8, 2006

In the following scenario, I am getting the message 'Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection'.

I am running a Windows Server 2003 with development environment and Sql Server Management Studio in a workgroup on a virtual PC.

My SQL Server 2000 is running on a domain server.

On the virtual Pc I have setup my user login and password to be the same as my domain login and password. Why is the Management Studio not using impersonation and allowing me to connect to the SQL server on the domain?

View 4 Replies View Related

Can't Connect To A Sql Express On A Workgroup Pc

Aug 8, 2007

Hi Guys,
I'm trying to connect to a sql express on a workgroup PC through sql server 2005 standard edition remotely but i can't.
I have checked and make sure that tcp/ip and other protocals are allowed. There is no firewall on both PCs and the sql browser service is running as well.
Somehow i can connect using the IP address but not the name?

Any idea why?

TA
Gemma

View 4 Replies View Related

SQL Server 2005 Workgroup Installation

Feb 3, 2007

HI All,
After i installed SQL Server 2005 workgroups edition to my Laptop, P4 and 1 Giga memory. I had a problem.
my problem is: when i start my laptop need 4 minutes to start the windows xp pro edition.
then I format my laptop and install the windows again, and every thing works fine, but I installed the SQL again and i had same problem with windows startup, there is nothing related to SQL in ;msconfig utilities.
do you have any tip about this problem ?
Thank You

View 3 Replies View Related

Replication, Workgroup, And Sharing NT Login

Nov 15, 1999

Would someone please tell my how to share the same NT Login on a Publisher and a Subscriber Server. For example, one of
the requirements for Replication is that the Publication Server and
Subscription Servers should share the same SQL Executive account. I tried
doing this in Control Panel, Services Applet, Startup, and This Account Box. The Subscribing Server is not allowing me to map the login of the Publishing Server. I also tried within NT User Manager for Domains. I am not able to figure this out. I am trying to get Replication to work within a Workgroup on two NT 4.0 Servers SP3, with SQL Server 6.5 SP5a.

Thanks, Kevin

View 2 Replies View Related

Sharing SQL Server Express Among Workgroup

Sep 27, 2005

Hello -- Please excuse my extreme newbieness -- trying to get up to speed fast on SQL Server Express for work. I've been able to set up the software, create a database, and access it with no problems on my local computer, but I need to make the database available to other computers in my workgroup. I followed instructions -- enabled TCP/IP and Named Pipes and turned on SQL Server Browser, and I was actually able to manipulate one system database (the "master" database) from another computer but not any other databases, not even the other system databases. I can connect to any of the databases with the SQLCMD commands, but if I try to do any SELECT commands (other than in "master") I get an error: "SELECT permission denied on object '[MyTable]', database '[MyDatabase]', schema 'dbo'". I was only able to get into "master" after adding "guest" as a user, but adding this user to the other databases has no effect. One interesting thing: When I used the sp_table_privileges command on each database, all but "master" showed all privileges being granted to and from "dbo", but "master" didn't show anything being granted to or from anybody. Does anyone know what could be going on here? Am I missing something obvious? Thanks for any and all help!

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved