Set Up A Replication With ISCSI Drive
Nov 24, 2006
Hello,
I'm trying to set up a replication of SQL 2005. I have 2 servers running and I like to configure it that the second server takes over the SQL database when the first server fails. The database files are located at a ISCS network drive that can have only 1 initiator. We tried to set up a cluster server, but that seems not possible because of the 32 bit proccesors inside the servers. We have installed windows server 2003 EE on both servers. Is there a way that the second server can take over the connection to the ISCS from the first server??
Thanks, Remco
View 4 Replies
ADVERTISEMENT
Jan 30, 2004
Hello all,
I have Microsoft iSCSI Initiator (SAN) installed on a SQL Server machine and has this drive acting as a local drive. All the database's data files are residing on this drive, attached with SAN.
It runs as a service "Microsoft iSCSI Initiator" on the SQL Server machine.
Now the question is, when we restart the SQL Server all the databases change their status to "Suspect" and we have to stop all the sqlserver services (all the SQL instances) and start them all up. This is the only temporary solution we came up with.
Could any one has any real solution or had encounter such a problem before?
Any help is appreciated.
Thanks bunch!
imransi.
View 4 Replies
View Related
Apr 4, 2008
Hi
I have been trying to use openrowset with a shared drive, and even though the share has "full control" permissions granted to "everyone" and the accout that SQL runs under has been granted explicit full control permissions I am unable to open the file which itself has no security on it.
Can I not use a \ path and only use mapped drives?
Thanks
below works...
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:5People.xls', [Sheet1$])
below doesn't work...
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=\cluster02FileManager5People.xls', [Sheet1$])
View 3 Replies
View Related
Nov 9, 2000
I am trying to move a log file from one drive to another.
What I have done is add another file to my file group. So now my log has a file on the 'e' drive and one on the 'f' drive. I now want to remove the file on the 'e' drive. I have emptied the file on the 'e' drive. When doing the command:
ALTER DATABASE Uniprodruntime
REMOVE FILE m_rk_runtime_log
I get the following error message..
Server: Msg 5020, Level 16, State 1, Line 1
The primary data or log file cannot be removed from a database.
I have also gone into enterprise manager and tried to delete the file and it does nothing.
Has anyone run into this?
View 2 Replies
View Related
Feb 12, 2007
How do you compare SAN drive vs local drive on a 32 bit server?
Is it good idea to move my DB files to a SAN instead of local?
Canada DBA
View 4 Replies
View Related
Nov 28, 2015
Server: SQL 2008 R2
1: TempDB keeps getting filled. Restart of the server has not fixed it. I shrink it, but the space gets filled again. Now I can't even shrink it anymore
2: TempDB is at the wrong location. Its current location is this :C:Program FilesMicrosoft SQL ServerMSSQL10_50.SQLPROD6MSSQLDATA empdb
How do I change its location?
C:Program FilesMicrosoft SQL ServerMSSQL10_50.SQLPROD6MSSQLDATA empdb
Correct location of TempDB should be: TempDB(T:) But its not there
View 13 Replies
View Related
Jan 31, 2008
Being a very novice SQL Server administrator, I need to ask the experts a question.
How do I go about moving a database from 1 drive to another? The source drive (C is local to the server, but the target drive (E is on a Storage Area Network (SAN), although it is still a local drive for the server. I want to move the database from C: to E:. Can someone provide me with instructions?
Thanks,
Rick
View 4 Replies
View Related
Jan 16, 2015
How to backup half of dbs from a server on C drive and the other half on D drive and vice versa, first half on D drive and other half On C drive using only one job and one stored procedure??
Using scheduling from job add 2 schedules to the job so first schedule backup first half to C and second half to D , the second schedule backup first half to D and second half to D.
View 1 Replies
View Related
Aug 13, 2004
If my computer has a map drive, i want to delete it, how to do it? Is that right if i right click the map drive and click the disconnect?
View 3 Replies
View Related
Oct 26, 2006
I am installing the X86 Executable version of SQL Server. I copied it to my desktop and clicked RUN. It extracts the files and then the Install Wizard tells me there is not enough space on the C Drive to load the program. I have 23 gigabits of free space and the program only takes about 900 megabits.
Is there a solution to this problem?
Thanks,
Modez
View 2 Replies
View Related
Jun 19, 2002
I'm running out of space on my C. Is it possible to store additional DBs on another drive or do I need to load SQL server onto the new drive?
View 6 Replies
View Related
Jun 6, 2001
Would this be ok for a SQL Server?
Here's what we are thinking about doing:
3x18 GB RAID 5 for OS/apps/database/data.
2x9 GB mirrored for the log files.
(we normally don't have apps on the server besides SQL itself)
Thanks!
View 2 Replies
View Related
Aug 7, 2000
Hi
I have a database(CEB) and my CEB.mdf is on D Drive and CEB.LDF is on
G DRIVE ...NOw I want to move the CEB.LDF on to the different drive ..
can any one suggest me the way and will I have any effect on the database.
It is kind of urgent.
Thanks
RAGHU
View 1 Replies
View Related
Aug 15, 2000
How do I move all the databases to a new drive in the same machine?What effects/problems will be?
Thanks!
View 7 Replies
View Related
May 11, 2000
Hi,
I have a shared drive mapped to the h: drive letter on my sql server and I want to create new databases on that drive. Is this at all
possible?
I try it and I couldn't see h: even if I typed it in.
Thanks
View 2 Replies
View Related
Feb 4, 2001
Hi,
What problems will I get if the hard drive for the transaction logs becomes defective? Will this affect transactions and/or backup? What should I do to fix this problem?
View 1 Replies
View Related
Sep 28, 2005
In reading material on the quorum drive on a sql server cluster in mentions this is the drive the logs are written to. Is this referring to sql log files that are dumped by a process or scheduled job, or some other log files?
View 1 Replies
View Related
Jun 7, 2004
I have an MSDE installation on Windows server 2003. It looks like the C: drive is taking the brunt of the data when I load up the database. I would like to specify a different drive for data...Is there a way to do this?
View 1 Replies
View Related
Apr 23, 2008
I know this isn't exactly SQL help, but I alwasy get great help here and thought someone might know why I'm having problems. I'm trying to map to a drive where I have a SQLExpress database on another computer within a workgroup. This is the cmd line I'm using...
NET USE * \XPPRO1SQLExpress /USER:Admin /SAVECRED /PERSISTENT: YES
I'm thinking the problem is with the * (which names the new drive with the next available letter), or that I have to use a password. Everything I've found says nothing about specifying a password though.
The error message I get says "A command was used with conflicting switches."
View 1 Replies
View Related
Jun 19, 2008
How is it possible to use sql to verify F: drive is on disk 0 ?
Thanks
View 3 Replies
View Related
Apr 17, 2006
Hi
Can I de-frag the Drive in which the Data files & Log Files of the SQl Server Exists ???
Please Advice.
Thanks
View 5 Replies
View Related
Mar 19, 2007
Hello All,
Can anyone be so kind as to turn me on to a script to move a database from spilt drives C: and D: to just drive D:. (we have one of those Dell's that comes with C/D partitions so we split the .dta files with a limit on the primary file, but the damn C: drive still ran low on disk space and now we can't install Win 2003 SP2 on it!)
thanks in advance
Bill
View 1 Replies
View Related
Dec 5, 2007
Hi guys. I'm new to MySQL..
I've just installed MySQL on drive C: of the server, but now i need to change it from drive C: to drive D:. Is there anyway of doing this?
View 2 Replies
View Related
Jan 10, 2007
Has anyone here ever used a memory drive in conjunction with SQL Server? If so, how and did it help performance?
Dave
View 3 Replies
View Related
Aug 7, 2007
We are currently having a "lively" discussion between our DBAs and Server Builders and I am interested in what others are doing. Our DBAs want to take the default SQL install into the C: drive, making sure that NO logs are written to C:. That way there is no chance for the C: drive to become full, crashing the box. Server guys are insisting that we install to a drive other than C:.
I would appreciate any discussion re: what others consider best practice , industry standard, if such a things esist.
Thanks.
View 2 Replies
View Related
Jun 29, 2007
Any comments, please. I have a new server 5x160GB drives. It needs to run IIS for a web app and SQL Server 2005. One user database. I was thinking of dividing space as follows and wanted to get some thoughts from others.
2 drives = RAID 1 set, 160GB space, OS, IIS, SQL exe, tempDB, user database log file
3 drives = RAID 5 set, 320GB space, SQL data files, user database files
Thanks for looking...
View 5 Replies
View Related
Feb 22, 2008
I currently have about 4 databases on our SAN located in one of the drives. These databases are going to expand massively and I want o seperate 1 onto seperate drives located on the SAN. I figured using SQL Server Management Studio I could complete this with an easy "Detach / Attach" operation. When I go to attach the files back into SQL, it doesn't read any other drive other than the current drive all of the databases are located on.
Is there a way to do this?
View 2 Replies
View Related
Mar 19, 2007
Is there a way to install SQL 2005 Express on a different drive? The server that I want to use has 700MB availible on the C drive and 80 GB availible on the D drive. can I install SQL and all tools on the D drive?
View 3 Replies
View Related
Oct 7, 2004
When I ran the install for MSDE, it installed the DB server and the databases onto my C: drive and under program files...
The instructions I followed were listed here:
http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1
I'd like to be able to install it to my D: drive. I've looked through all of the docs but I can't find any information on how to change the install path. Would anyone know how to do this?
Thanks,
LD.....
View 2 Replies
View Related
Mar 1, 2002
I just upgraded SQL6.5 standard(Installed 7.0 and ran Wizard to upgrade dbs) to SQL7.0 by running the exe file.
It turned out that the MSSQL7 folder is follen on Drive C instead of Drive D which is what I wanted. When I was running the upgrade exe file, there was no prompt to ask me the right path.
How could I have the MSSQL7 folder installed on D drive?
Thank you for help
View 1 Replies
View Related
May 14, 2001
I need to move Sql of the C drive on a server to another drive. Any Ideas.
Thanks Brett
View 1 Replies
View Related
Aug 29, 2001
Hi
I have and issue with a query, I tried every thing but I couldn't find why. Here is the issue, I have one big DB1 with about 30 tables, the query based on a join of 5 tables, I have the right index in place, when I run the query it will take about a minute and 20 sec. But I have another DB2 on the same server and I imported just the 5 tables form DB1 with the same index, when I run the same query it will take 6 seconds.
I did drop and recreate the indexes and drop and recreate the statistics but still the same thing no difference.
I'm running SQL7 SP3.
Do you have any idea what might be the issue here?
Thanks for your help
View 4 Replies
View Related
Nov 14, 2000
hi, I have NT server which has drive c: 500 MB and drive d has 44 GB.
I know that the person who set up this server did not give enough space to the c drive, here is the problem. I am running sql server 7.0 which has 30 GB of data in the d drive. I need to reconfigure the NT hard drive so I can allocate 2 GB for C drive and 42 GB for D drive.
What is the best, safe method to accomplish this task.
Ahmed
View 3 Replies
View Related
