Hard Drive Crashed. Master && User Db Mdf && Ldf Files Lost
Jan 31, 2006
Hello.
One of our hard drives has crashed and as a result we have lost our master mdf/ldf & user db mdf/ldf files. It's not that a critical system by any means, but if the hard drive crashes and the master mdf/ldf files & user db mdf/ldf are lost, is there any way of restoring the system?
I'm thinking we probably need to re-install Enterprise Manager completely, and re-install the user db from a backup.
Any advice/suggestions would be much appreciated.
Thanks in advance,
View 1 Replies
ADVERTISEMENT
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
Sep 27, 1999
After experiencing a hard drive failure i have reinstaled MSSQL7 on one drive and have a database which I need to recover on separate physical drive. How can I go about doing this?
View 1 Replies
View Related
Jul 17, 2003
Hi,
I have ran
1. xp_fixeddrives and got the result
drive MB free
----- -----------
C 1708
D 16311
2. I ran Backup Wizard in EM and able to see only above drives
3. But if ran backup in EM able to see more than 10 Drives(like C,D,H,I,J,M,N and etc).
Why I can able to see those difference?.
How do I find out exactly how many drives are there in this server without directly going to that server?.
I appreciated your valuable answere.
Thanks,
Ravi
View 8 Replies
View Related
Apr 7, 2004
Hello, everyone:
Does any one have an idea for hard drive configuration on SQL Server 2K? How to determine the RAID level for datafile and log file? Thanks
ZYT
View 2 Replies
View Related
May 18, 2004
I was wondering if anyone played around with changing the allocation unit size when formatting the hard drive the SQL server is running on. I would think that setting it higher to account for the larger size of the database files would help, but I'm not sure.
Anyone have any thoughts?
View 3 Replies
View Related
Dec 29, 2005
Hi, paws.
My server crashed recently, I didn't give to much importance because I knew that having access to the partitions I could recover my DB files and attach my database to my new server, and everything was fine until ... I found that my DTS Packages and Jobs where not in my Attached DB.
Now, where can I find these ?
Can you help a tormented man ?
Thanks in advance.
Francisco J
View 4 Replies
View Related
Feb 2, 2007
Hi guys,
I have a general question. Would SQL server have slower performance if you placed the ldf or mdf files on a dynamic drive setup or should it always be basic? I noticed that a server had 2 dynamic drives and the log files and mdf files are located on these drives. Usually I see all the drives as basic not dynamic. Does this even matter?
thanks
View 1 Replies
View Related
Oct 19, 1998
I want to perform backups to a network drive. I need to know if I can access the backup drive via UNC. I have not been able to get it to work and, for now, I would just like to know if what I am trying to do SHOULD work.
For example I want to backup to device mdtnts_prod02LM2BackupNameBack.DAT.
Thanks,Bob
View 1 Replies
View Related
May 9, 2008
I'm wondering what other people do in regards to running hard drive defragmentation programs on SQL Server 2005 servers (assume 64-bit and Windows 2003). From what I can tell the most common opinions are:
1. Don't defragment because it doesn't help and it can cause problems.
2. Use Diskeeper
3. Use the built-in Windows defragmenter
Other respected defragmented programs are PerfectDisk, O&O Defrag, JkDefrag, and Contig.
What is your hard drive defragmentation strategy?
View 1 Replies
View Related
Apr 5, 2007
Hi. Has anyone else had any problem with their SQL Server 2005 going nuts after installing the SP2 + the above hotfix?
We reboot the SQL Server and as soon as SQL receives a command of any sort, the SCSI RAID 5 hard drives light up and start trashing. Therefore every query and even Windows response time is painfully slow or fails to respond. When we look at the Activity Monitor and sp_who2 there is a process running a Select Into from Microsoft SQL Server Management Studio using the sa account from the last database name in our system. So we can't kill the process as it says "Cannot use KILL to kill your own process. Microsoft SQL Server, Error: 6104)".
The last Transact-SQL command from this process is:
create table #tmpDBCCinputbuffer ((Event Type) nvarchar(512),
[Parameters] int, [Event Info] nvarchar(512))
insert into #tmpDBCCinputbuffer exec ('DBCC INPUTBUFFER(56)')
select [Event Info] from #tmpDBCCinputbuffer
The only other issue I should mention is that we had to uninstall and reinstall SQL Server yesterday as SP2 only half installed. The SP2 install log indicated that SQL SP1 wasn't in a good state as we previously (3 months ago) performed an upgrade from Windows 2000 Server to Windows 2003 R2 Server.
Our other 3 Windows 2003 R2 Servers which were a clean install of both Windows and SQL are running fine.
I've been insisting that we do a new clean Windows and SQL install, but the other team members insist that it's been fine until we installed SQL Server SP2.
So can anyone provide and help or evidence to say who is right either way?
Thanks.
View 3 Replies
View Related
May 12, 2007
In our SQL Server database we will have a table that will be populated with about 2000 recordsper day. That is 2000 records per day for 5 days per week. Currently the computer we are using has about 50 gigabytesof available hard drive space on it. We are concerned that maybe we will need a bigger hard drive,based solely on the number of records entered into this table per day. The problem is I don'tknow how to calculate how much hard drive space we need. I think I read that using varchar,sql server 2005 really optimizes a database. Here is a typical example of data in ourdatabase. I put dots on three lines between the first and last sample record to justillustrate that there are many records in between.
Basically we only need 8 months of data at a time in the table and then we can purgerecords older than 8 months.Can someone help me approximate how much hard drive space I might need for 8 months of data,given the following sample record in the database?
Sample: -->34.5 4.08 10.6 .0012
Sample Table in my DB just for illustration:
(PPsquare inch) (Diameter) (Weight gm) (coeffOfSatFriction)
34.5 4.08 10.6 .0012...21.7 3.54 6.22 .019
View 4 Replies
View Related
Nov 26, 2007
Hi,
I use sql server management express. I have created a table on my hosts remote database and i want to copy the table (or the data) in some format or other to my hard drive. does anyone have any good ideas how i may do this either through management express or other means.
thanks a lot
nick
View 2 Replies
View Related
Feb 20, 2004
Hi,
I am running sql server 7 with 200+GB database size. I have one table with following fields
IIINDEX
DOCTYPE
IMAGE BLOB
I need to dump all the information from this table to hard drive.
I have try with delphi ado and delphi odbc (limit 1mb), somehow when I run the program it gives me an error message E_ timeout.
How can I dump this information without using delphi.
Any help will be highly appreciated.
If you have any code that can help please email me samirp@ix.netcom.com
Thanks.
Samir
View 1 Replies
View Related
Jul 23, 2005
Dear group:I have removed my hard drive from my laptop (which is now toast) andhave managed to recover nearly all the data from it by installing thedrive into my desktop. I was hoping to reboot the dektop to see if Icould load the operating system on the laptop's hard drive so I coulddo a manual backup of the SQL database on it. This does not work.Does anyone know of a way to recover my SQL database and all its tablesgiven the circumstances above?TIAISZ
View 5 Replies
View Related
May 5, 2006
Installed SQL Server 2000 Enterprise trial a week ago on XP Pro. Installed new Seagate 80G HD; used Seagate's utility to copy old C: to new drive as new boot drive. All seems to work fine, except, when booting up, SQL server doesn't start. When I try to start it manually I get the following:
Could not start SQLSERVER service on the local computer. Error 3: the system cannot find the specified path.
1. What could be wrong?
2. How do I fix it?
View 9 Replies
View Related
Oct 18, 2007
Hi all,
I have one table with a column of type 'image'. There are manytypes of files saved in that column (i.e. .Doc,Xls,Pdf,jpg,gif etc.). What I want is, read that files from database and save it in temp folder on d drive of server. Can anyone help me in my problem?
Thanx in advance
View 1 Replies
View Related
Apr 25, 2006
Hi,
I've downloaded the sql server 2005 management studio express executable to my second hard drive, as there is no room on my main drive
However, when I try to install, the program shows me both drives, and shows that there is not enough room on my main drive, but it does not allow me to change the installation to my second drive.
I have previously installed the main sql express product to my second drive with visual studio. There's loads of room.
Can anyone give me a clue as to why this might be happening.
Thanks
John
View 1 Replies
View Related
Apr 9, 2007
I need to create a SQL server database and add some tables to it. Then access it with a C# application. The problem is that the new SQL server database and it's tables must reside on an external hard drive. How do I point SQL server to this external drive, so that I can create a database on this drive and then create tables and access data on it?
View 7 Replies
View Related
Apr 3, 2002
I have a 'need an opinion' question. I've always installed the system databases (master, msdb, model, tempdb) on the root drive (c:) with the sql application. Then I was thinking, the only things that really should be on the root drive is the sql app itself (and any other required apps). So...my question is, do y'all install the master, etc on a separate drive other than the root, ie d: or e:? The reason I ask is that if the tempdb database has alot of activity, and the database resides on the root drive, could it affect sql performance?
Just wondering. I just started working in a 'virgin' sql environment (setting up sql servers from scratch), and want to have sql installed in the best possible way for performance.
Thanks in advance for any info y'all can provide.
View 3 Replies
View Related
Jul 20, 2005
Can you restore the master database, running on windows server 2000, sqlserver 2000 from a backup that was taken from c: to another serverrestoring to d:?*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies
View Related
Oct 27, 2015
WHY master, msdb, model always seem to be on the " C " drive ....
View 4 Replies
View Related
Jan 26, 2001
Hi All,
I took a backup of master,model and msdb database which was on D: drive and i tried restore it on C:. Now if i try to start sql server it comes out with a erorr that model database cannot be found and it keeps looking for model in D: drive which is not there.I tried restore of model with move option but it says cannot drop model as its system database.I tried attach detach but it does not understand tempdb as temp db is also on d: and i cannot understand how to move or point it to c:
Suggestions will be greatly appreciated
Vishal
View 1 Replies
View Related
May 19, 2012
I am using Master Data Service for couple of months now. I can load, update, merge and soft delete data in MDS. Occasionally we even have to hard delete data from MDS. If we keep on soft deleting records in a MDS table eventually there will be huge number of soft deleted records. Is there an easy way to hard delete all the soft deleted records from all MDS tables in a specific Model.
View 18 Replies
View Related
Apr 19, 2007
I had several jobs scheduled in the SQL Server Agent before I upgraded from MSDE to 2005 Express. I planned to recreate the jobs in the scheduler later, now it's been a couple of months and I realize that we hadn't kept those scripts outside the database anywhere. Is there any way to recover those job files? We have database backup files going back quite a while, but I'm not sure how I'd go about restoring them. I guess I'd need an instance of SQL Server 2000 (which I have). Would I just restore an old backup there? Is there an easier way?
I'd be grateful for any help you can give.
Nate Baxley
View 2 Replies
View Related
Nov 2, 2006
I created a project with multiple packages. I created a global
config file that all packages reference. I also created a config file
for each package that contains the package specific settings. I
checked it all into TFS. I went to a different machine and checked it
all out. Upon loading a package into the IDE I got the following 3
warnings.
Warning loading MT_LSE_PROD_StageLoad.dtsx: The
configuration file "MT_LSE_PROD_StageLoad.dtsConfig" cannot be found.
Check the directory and file name.
e:contentloadersprint1aMT_LSE_PROD_StageLoad.dtsx
Warning
loading MT_LSE_PROD_StageLoad.dtsx: The configuration file
"Environment.dtsConfig" cannot be found. Check the directory and file
name. e:contentloadersprint1aMT_LSE_PROD_StageLoad.dtsx
Warning
loading MT_LSE_PROD_StageLoad.dtsx: Failed to load at least one of the
configuration entries for the package. Check configurations entries and
previous warnings to see descriptions of which configuration failed.
e:contentloadersprint1aMT_LSE_PROD_StageLoad.dtsxAny
ideas??? And yes, the files *ARE* there! I tried building the project
and it builds. I also tried doing a deployment build and that too
built. I am so confused!!!
View 2 Replies
View Related
Jul 20, 2005
HiWhen we issue a DBCC SHRINKFILE with empty option, the data fileis removed and the space is alloted back to the OS.Same way when we issue a an ALTER DATABASE to remove a database,all the data files and transaction log files are dropped.But can these files be recovered again by using any of the diskrecovery tools?Achilles
View 1 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
Apr 18, 2007
All,
I'm writing to ask if anyone knows whether or not MS SQL server stores in any system tables the association between a database and the drive letter/directory path where its corresponding MDF/LDF files are located.
Thanks,
Isaac
View 4 Replies
View Related
Jan 26, 2005
Hi friends, i want to know something abt sql server installation and database properties as under.1) how much disk space reqd by multiuser sqlserver 2000 db to install ?2) is it possible to install sql 2K on Flash Drive ( gen connect at USB) ?3) When v create a database user Enterprise Manager , which files created by database ?4) If i Know datafiles name of a database e.g. pubs , and if v copied on cd and paste on other system which has sql 2K install , does those database works ?5) is it possible to create database on flash drive ? thanx in advance.
View 2 Replies
View Related
Sep 27, 2005
Howdy y'all! :)
I have been instructed to move a large database we have on one of our servers off the current drive (local RAID-5 driveset in the server) to a EMC "drive" (logical drive, off-server).
I know one option is to back up the database, delete the database, re-create the db using the new drive for data/log files, then restore the database.
However, I was wondering if it would be better to just detach the DB, move the data/log files, then reattach to them?
Is it half-doz of one, and 6 of the other?
How should I go about this dastardly deed?
Off to poke around in BOL, but thought I would post first in case it's an incredibly easy answer for y'all
Thanks!
View 3 Replies
View Related
Nov 5, 2014
We have a cluster with two nodes and two instances of SQL Server 2012 Standard Edition running on them. Volume W: is a Fusion-IO card.
On one of these nodes a lot of database names are showing up in the resource monitor as *.mdf files (W:0MSSQL1…).
How and why SQL Server is using these files? They only show up on one of the nodes having more load.
Volume I: is the volume where the transaction log is written so we can explain these files.
View 3 Replies
View Related
