Disk Dump To Another Machine
May 12, 2000
We are trying to set up a disk dump to another machine (our backup SQL machine). I mapped a drive to the other machine
but it only sees the local drives when I try to create the dump device. I typed in the path, but I
get error messages stating that it can't open the file when I try to do a dump. From what I have read, I thought I could
do a disk backup to another machine. Am I trying to do something impossible? Any help would
be appreciated. Thanks.
View 1 Replies
ADVERTISEMENT
Dec 28, 2006
hello,all
I am new to Sql 2000,I installed sql 2000 database in C disk,but Now I found my C disk space is smaller than before,So I want to move my databse(include data and structure) from C Disk to D Disk(its space is very large) .
is it possible to do it ?
if its can be done ,do I need to change my asp.net program source code (exp: chaneg my crystal report connectstring ) ?
thanks in advanced!
View 1 Replies
View Related
Sep 10, 2007
If I return the Average, Minimum, and Maximum values for the counter Physical Disk: Avg. Disk Queue Length, and those values are 10, 0, 87 respectively, which value do I use to compute the Avg. Disk Queue Length for a 4 disk array(RAID 10): Average, Minimum, or Maximum? The disk(lun) is on a SAN.
View 1 Replies
View Related
Nov 13, 2007
-- Initialize Control Mechanism
DECLARE@Drive TINYINT,
@SQL VARCHAR(100)
SET@Drive = 97
-- Setup Staging Area
DECLARE@Drives TABLE
(
Drive CHAR(1),
Info VARCHAR(80)
)
WHILE @Drive <= 122
BEGIN
SET@SQL = 'EXEC XP_CMDSHELL ''fsutil volume diskfree ' + CHAR(@Drive) + ':'''
INSERT@Drives
(
Info
)
EXEC(@SQL)
UPDATE@Drives
SETDrive = CHAR(@Drive)
WHEREDrive IS NULL
SET@Drive = @Drive + 1
END
-- Show the expected output
SELECTDrive,
SUM(CASE WHEN Info LIKE 'Total # of bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS TotalBytes,
SUM(CASE WHEN Info LIKE 'Total # of free bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS FreeBytes,
SUM(CASE WHEN Info LIKE 'Total # of avail free bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS AvailFreeBytes
FROM(
SELECTDrive,
Info
FROM@Drives
WHEREInfo LIKE 'Total # of %'
) AS d
GROUP BYDrive
ORDER BYDrive
E 12°55'05.25"
N 56°04'39.16"
View 16 Replies
View Related
Nov 15, 2006
Hello,
I am trying to setup a test cluster and am having an issue. When I try to create the resource of a physical disk it takes both the drive e: and drive q: and doesn't seperate them into two physical disks as resources. This means when I try to associate the quorum disk it links the to physcial disk resource of drive e and q. Then when I try to install SQL2k5 I get the warning about installing SQL on the quorum disk. Am I missing something? Is there a way to seperate e and q onto two physical disk resources so I can specifically associate the quorum to q and the sql to e or should I be setting the quorum disk to a majority node set? Thanks in advance.
John
View 4 Replies
View Related
Feb 20, 2001
Hello,
this is my configuration :
1) 3 disks in RAID5 that hold the SQL data
2) 1 disk in RAID0 that holds the only paging file.
What will happen to the SQL data (DB) when the disk that holds the paging file crashes?
Kindest regards,
Luc.
View 1 Replies
View Related
May 7, 2004
Hi all,
Ok here goes,
I have a three tier system using SQL server 2000, we are currently experiencing IO bottle necks on our SCSI Raid 10 array, which holds the Data and the logs in separate partitions.
So my options as I understand it are:
Get Enterprise edition
or
Get another physical raid 10 array and separate the logs and data i.e. data on one array and logs on the other array.
I would like to try the latter but I am totally unsure how much difference this will make or whether it will make any difference at all.
Does anyone know how much performance increase I will get from using two arrays as opposed to one?
Any other advice on this scenario would be greatly appreciated.
Thanks
View 4 Replies
View Related
May 4, 2007
Help!
I am using Script Transformation to output a new column as image[DT_IMAGE]
field to store serialized object. In the VB script, the sample code as
Row.serializedobject.AddBlobData ( binaryArrayReturnedFromC#dll )
The package always runs fine on my developing machine and will halt on other
machine at AddBlobData after certain number row records were processed. I am
stuck here. Anyone has any suggestion?
What I need is reading data from mutiple tables in one database and writing
into a single table in another datable. In order preserve all the columns
data, I use input column fields to construct a new object and then serialize
it, and store the serialize data into detination db table. (The object and
serialization function is coming from c# dll.)
Dim b As BusinessLicense = New BusinessLicense()
b.ApprovalDate = Row.approvaldate
b.BusinessId = Row.busid
b.BusinessName = Row.busname
b.NaicsCode = Row.naicscode
b.NaicsDescription = Row.naicsdescr
b.OwnerName = Row.ownername
b.Phone = Row.phone
b.Pkey = Row.pkey
b.RenewalDate = Row.renewaldate
b.StartDate = Row.startdate
b.Suite = Row.suite
Row.serializedobject.AddBlobData(Serializer.Serialize(b)) '''----This is blocking line
Row.infoType = BusinessLicense.TYPE
Both machine is xp with sp2. and standard SQL Server 2005 - 9.00.1399.06
Thanks!
View 4 Replies
View Related
Nov 28, 2006
Hi All,
I have enterprise version software CD1 and CD2 of SQL server 2005
when i try to run setup.exe..the following error pops -up
The image file Setup.exe is valid, but is for a machine type other than the current machine
MY OS version is windows 2003 32bit Operating system...
I am suspecting the binarie may be of 64bit.. How do we check the binaries are 32 bit and 64 bit software
Thanks for your Help
Mohan
View 4 Replies
View Related
Nov 16, 2006
Hi to everyone,
I'm facing a problem that drives me crazy. I've a web application that has the following problem. When I test the application on my developement machine all runs fine, but when I put into production server there is a problem in connection pooling. Look at the following image, the blue line is the number of connection in the pool and the violet line is the number of connection reclaimed. From the image it is clear that connection are returned on the pool only in block, maybe when the garbage collection pass and reclaim the object. The strange thing is that on my developement machine all is good, and also I'm using Enterprise Library and the connection are managed internally.- Thanks to everyone for any help.
View 2 Replies
View Related
Oct 2, 2000
Hullo all
I have two machines,
One is a standalone machine and the other is on a domain network. How can I run a stored procedure/job on the standalone machine from the domain machine ?
running the procedure as a Domain user results in a failed job/stored proc.
also creating an sql login and attempting to run it as that user also fails. How can I solve this problem ?
please e-mail me at wayde@sunnygrp.com if you have any thoughts...
View 1 Replies
View Related
Jul 23, 2005
Hi All;We are going to change our application server. We will copy all of ourDatabase from Mic 2000 Server OS to Mic 2003 Server OS. I found anarticle that how to move all the folders from same OS. My question isthat Would the 2003 OS be a problem when we copy all of the MC SQL 2000folders to New OS ? Has anybody done this before? Could you gimme yoursuggestions please?ThanksASA
View 1 Replies
View Related
Jan 17, 2008
Hi,
here goes the question:
i have 1 sqlserver 2k5 machine (machine A) and sqlserver 2k (machine b)
how do i build a query to select data from 2k machine in a query of 2k5?
i mean something like
select *
from login:passw@machineb.dabatase.dbo.customers
thanks!
View 2 Replies
View Related
Jan 17, 2008
Hi,
here goes the question:
i have 1 sqlserver 2k5 machine (machine A) and sqlserver 2k (machine b)
how do i build a query to select data from 2k machine in a query of 2k5?
i mean something like
select *
from loginassw@machineb.dabatase.dbo.customers
thanks!
View 6 Replies
View Related
Oct 23, 2006
Hi,
If I use GetDate() function from client machine (using "\ServerMachineSQLExpress" instance from client machine "ClientMachine"), then from where I will get the DateTime value ?
From "ServerMachine" or from "ClientMachine"
Thanks
View 3 Replies
View Related
Jul 13, 2007
Hi Guys,
I was wondering if there was any white papers on the migration part from microsoft?
Apparently the situation is like this
Currently installed MOSS 2007 in a testing pc as application server. This application server will refer another testing database server which running SQL Server 2005.
Now, wanted to move this 2 temporary server into another 2 new servers.
Correct me if I'm wrong, it cannot be done by using image like Norton Ghost due to difference hardware spec.
So, if I install another fresh copy of MOSS2007 & SQL server 2005 in that 2 new servers, how can I migrate the contents, documents, etc from the testing database server?
It would be great if someone can show me the links to kb article. Thanks
View 1 Replies
View Related
Jun 30, 2006
Dear All:
When i try to debug the northwindoledb example with VS2005 i get the foolwing error message.
Is there a way to configure the solution to run witn WM5 emulator.
The application run with wm5 emulator when i set the plataform to Windows Mobile 2003, but i want to use the wm5 platform to debug my application with wm5 emulator.
------ Rebuild All started: Project: northwindoledb, Configuration: Debug Windows Mobile 5.0 Pocket PC SDK (ARMV4I) ------
Deleting intermediate and output files for project 'northwindoledb', configuration 'Debug|Windows Mobile 5.0 Pocket PC SDK (ARMV4I)'
Compiling...
Employees.cpp
northwindoledb.cpp
stdafx.cpp
Generating Code...
Compiling resources...
Linking...
coredll.lib(COREDLL.dll) : fatal error LNK1112: module machine type 'THUMB' conflicts with target machine type 'ARM'
Build log was saved at "file://d:Proyectos_VS2005Northwindoledb_WM2003_SQLEW_Windows Mobile 5.0 Pocket PC SDK (ARMV4I)DebugBuildLog.htm"
northwindoledb - 1 error(s), 0 warning(s)
========== Rebuild All: 0 succeeded, 1 failed, 0 skipped ==========
View 1 Replies
View Related
Feb 23, 2008
Hi, I have added a new SQL Server database to my project and I was wondering how to do generate a SQL dump of the database, tables, and queries? I couldn't find any utilities in Visual Studio 2008 Pro. I also couldn't figure out how to create indexes using VS. Thanks!
View 2 Replies
View Related
May 29, 2008
Dear all
I am working with database programming and maintaining
from last 3 years and this days i want to sit for 70-431 exam.
if some one have the dump of 70-431 please send it to my mail
shohan_mcp@yahoo.com
thanks
shohan
mcp
shohan
View 2 Replies
View Related
Aug 30, 2007
Can we have Reporting Services having its database on a server and distribution server (http://IISserver/Reports)
on another server?We dont want our database server to have IIS and dont want SqlServer installed on our IIS server
kind regards
View 4 Replies
View Related
Oct 26, 2005
I am trying to dump my mssql DB so I can upload it to my web server.
I am using SQLDump v3.0b1 from sourceforge.net.
My problem is, when generating the dump file, any value greater than 1000 in a money column is set to 1.0000 in the dump file.
Does anyone know of a better program I should be using or a way for me to correct this?
My DB is huge and it would take far too much time to go through the dump file and correct the changed values.
Any help would be appreciated,
Thanx
View 6 Replies
View Related
Mar 6, 2000
Hi,
I need a good suggestion from you.
1. I need to create a replication enviroment. In that i want to snapshot the database as and when i want from my Java program, so that selective tables are updated with latest data. Is there anyway i can do with out creating native replication methods.
2. Is there any way with out creating a snapshot or replication. I need to copy the data from my master database to child database(my reporting database) with out straining much my master database
Thanks in advance
Regards Jagannadh
View 1 Replies
View Related
May 18, 2000
Hi guys & gals
I get the following error when doing a dump on a 6.5 database.
***
Page '697569' of database 'FOREX_UPLOAD' in the database has the PG_DMPTRLR bit set.
Page '698121' of database 'FOREX_UPLOAD' in the database has the PG_DMPTRLR bit set.
Page '698233' of database 'FOREX_UPLOAD' in the database has the PG_DMPTRLR bit set.
***
I have run SP5 as suggested,and can see that more of the db has been dumped than before but still I get the error
I get no errors when doing dbcc's.
Any ideas???
Rgds
De Waal
View 1 Replies
View Related
Oct 5, 2000
Hi people
when doing a dump on a Win2000/SQL7 database from and NT4/SQL6 machine I get the following error:
SqlDumpExceptionHandler*****
EXEPTION_ACCESS_VIOLATION. SqlServer is terminating the process.
Can anybody tell me why?
What should I do?
Tks
De waal
View 1 Replies
View Related
Aug 3, 1999
Hi all,
When I use "DUMP DATABASE", it will help me to backup both database and
transaction log. However, it will not help me to clean up the transaction log.
Therefore, I am worry that will the following happen?
1. DUMP DATABASE
Start backup database
( there are transactions during the backup process )
Finish backup database
Start backup transaction
Finish backup transaction
2. DUMP TRANSACTION
Start backup transaction and clean up the transaction log
So, will the transactions been backuped twice? If yes, will it cause those
transaction do twice when I restore the database then restore the transaction?
Thanks
View 2 Replies
View Related
Feb 22, 1999
Hi,
I need to dump transaction log every night. Before I do that I'd like to check those open transactions and kill the ones not part of sa or SQL server dba's activity. How can I achieve this?
Thanks in advance.
May
View 1 Replies
View Related
Aug 10, 1998
Hello, All!
Can anyone explain what happens to Transaction Log
when DUMP DATABASE is issued?
Thanx.
John.
View 1 Replies
View Related
Mar 19, 1999
After Dumping a database device, I still find the xxx.DAT files inthe /Data directory. Can these be 'safely' removed/backed up ?
They are taking up WAY too much space.
Question 2: After installation and after creating devices & databases, is there any way to reassign the /Data directory on another drive?
Either for future devices/databases or existing?
Thank you much,
-James
View 1 Replies
View Related
Oct 28, 1998
I understand from the beta sql 7 newsgroups that 7 can't restore a 6.5 dump. This is extremely frustrating that MS wouldn't put this type of backword compatibility into 7.
Has anyone found another way to accomplish this? I can't use transfer manager as the 2 servers are on seperate, non-connected boxes. I ftp'd the dump from 6.5 server to a middle-man machine, then copied it to the 7.0 server.
Am I looking at bcp'ing out all 203 tables in my 1GB db then bcp'ing them back in?
Any help would be greatly appreciated.
Thanks, Andre
View 1 Replies
View Related
Dec 16, 2005
Is there a way to dump sql in Access like in Transact SQL or mysqldump?
I've gotta convert an Access Database into a MySQL database, it is a small database, but I'd not want to put it in by hand .
If not, I'll just make a PHP script to rip it from a textfile.
View 1 Replies
View Related
Dec 23, 2004
I am trying to import a database from a dump file.
The dump file is from a sql server db.
I have created the db on another server and want to import the data from the
dump file.
I use the bcp like this :
bcp nnfdb.sa.users in x -Usa -P
nnfdb is the name of the database
users is the name of a table
x is the name of the dump file.
But I get this error :
SQLState = S0002, NativeError = 208
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'nnfdb.sa.users'.
also I am sure if I have to run the bcp for each table or if I can import
all tables in one bcp run.
Regards
Kris
View 6 Replies
View Related
Apr 26, 2007
Hi;
I am frequently seeing the below errors in our SQL 7 Server running on Windows NT. I need your help to analze the problem. Thanks.
nitconfig: Number of user connections limited to 32767.
Module(sqlservr+e4c0) (CMsqlExecContext::Execute+1bb)
Module(sqlservr+e9ab) (CMsqlExecContext::ExecuteStmts+11b)
Module(sqlservr+1ce59) (CStmtSelect::XretExecute+1f8)
Module(sqlservr+10d22) (CStmtQuery::FExecuteQuery+1df)
Module(sqlservr+11f86) (CQuery::Execute+4f)
Module(sqlservr+120f5) (CQueryScan::CQueryScan+22c)
Module(sqlservr+12336) (CQueryScan::InitLockClasses+c3)
Module(sqlservr+12373) (CTableIsolation::FNeedLockClass+14)
Short Stack Dump
******************************************************************************
*
* BEGIN STACK DUMP:
* 04/25/07 08:32:19 spid 22
*
* Exception Address = 00412373 (CTableIsolation::FNeedLockClass + 14)
* Exception Code = c0000005 E
* Access Violation occurred reading address 00000014
* Input Buffer 132 bytes -
* S E L E C T S u p F r o m , S u p T o F R O M S u p p o r t P r
* o f i l e s w h e r e S u p P r o f i l e = 3 0 4 5
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 008d2fff 004d3000
* ntdll 77f60000 77fbefff 0005f000
* KERNEL32 77f00000 77f5efff 0005f000
* ADVAPI32 77dc0000 77dfefff 0003f000
* USER32 77e70000 77ec1fff 00052000
* GDI32 78140000 78174fff 00035000
* RPCRT4 77e10000 77e66fff 00057000
* ole32 77b20000 77bd0fff 000b1000
* OLEAUT32 65340000 653dafff 0009b000
* VERSION 77a90000 77a9afff 0000b000
* SHELL32 77c40000 77d7afff 0013b000
* COMCTL32 71710000 71793fff 00084000
* LZ32 779c0000 779c7fff 00008000
* opends60 41060000 41085fff 00026000
* ums 41090000 4109cfff 0000d000
* MSVCRT 78000000 78045fff 00046000
* sqlsort 04000000 0408efff 0008f000
* MSVCIRT 780a0000 780b1fff 00012000
* sqlevn70 410a0000 410a6fff 00007000
* rpcltc1 77bf0000 77bf6fff 00007000
* COMNEVNT 410b0000 410fefff 0004f000
* ODBC32 1f7d0000 1f803fff 00034000
* comdlg32 77d80000 77db1fff 00032000
* SQLWOA 41100000 4110bfff 0000c000
* odbcint 1f8c0000 1f8d5fff 00016000
* NDDEAPI 75a80000 75a86fff 00007000
* WINSPOOL 77c00000 77c17fff 00018000
* SQLTrace 41130000 4117dfff 0004e000
* NETAPI32 4ca00000 4ca40fff 00041000
* NETRAP 77840000 77848fff 00009000
* SAMLIB 777e0000 777ecfff 0000d000
* WSOCK32 776d0000 776d7fff 00008000
* WS2_32 776b0000 776c3fff 00014000
* WS2HELP 776a0000 776a6fff 00007000
* WLDAP32 77950000 77978fff 00029000
* SQLFTQRY 41020000 4103afff 0001b000
* SSNMPN70 41190000 41195fff 00006000
* SSMSSO70 411a0000 411aafff 0000b000
* SSMSRP70 411b0000 411b7fff 00008000
* ENUDTC 74e20000 74e36fff 00017000
* XOLEHLP 74e40000 74e48fff 00009000
* MTXCLU 74e50000 74e5cfff 0000d000
* ADME 74e60000 74e72fff 00013000
* DTCUtil 74e80000 74e89fff 0000a000
* DTCTRACE 74e90000 74e96fff 00007000
* CLUSAPI 7f230000 7f23cfff 0000d000
* RESUTILS 7f250000 7f259fff 0000a000
* MSDTCPRX 74ea0000 74ed0fff 00031000
* DTCCM 74ee0000 74efdfff 0001e000
* msafd 77660000 7766efff 0000f000
* wshtcpip 77690000 77698fff 00009000
* rpclts1 77e00000 77e05fff 00006000
* RpcLtScm 755b0000 755bafff 0000b000
* MSWSOCK 77670000 77684fff 00015000
* rnr20 75600000 7560dfff 0000e000
* RpcLtCcm 756d0000 756defff 0000f000
* security 76e70000 76e81fff 00012000
* msapsspc 756e0000 756f3fff 00014000
* MSVCRT40 779d0000 779e4fff 00015000
* schannel 77400000 7741dfff 0001e000
* MSOSS 75710000 75734fff 00025000
* CRYPT32 75740000 757b4fff 00075000
* MSASN1 757c0000 757cffff 00010000
* msnsspc 757d0000 757eefff 0001f000
* digest 757f0000 757fffff 00010000
* SQLRGSTR 01b60000 01b64fff 00005000
* xpsqlbot 01bf0000 01bf5fff 00006000
* sqlboot 01c00000 01c07fff 00008000
* EntApi 0a000000 0a011fff 00012000
* PSAPI 76bf0000 76bfafff 0000b000
* WININET 01db0000 01e45fff 00096000
* SHLWAPI 01e50000 01eb8fff 00069000
* xpstar 02440000 02470fff 00031000
* SQLWID 02480000 02485fff 00006000
* SQLSVC 02490000 024a8fff 00019000
* odbcbcp 024b0000 024b5fff 00006000
* SQLRESLD 024c0000 024c5fff 00006000
* W95SCM 024d0000 024d7fff 00008000
* SQLSVC 024e0000 024e5fff 00006000
* sqlimage 02590000 025bcfff 0002d000
*
* Edi: 00100C70: 000a0100 00030008 00000000 00000000 00100e70 00100e50
* Esi: 00000000:
* Eax: 00000000:
* Ebx: 00000004:
* Ecx: 00000000:
* Edx: 00000004:
* Eip: 00412373: 007ea6e2 05f61577 01f88318 468b0013 d49f850f 00147e83
* Ebp: 01C8F864: 00000001 00000000 2149a1e4 00000000 00412336 01c8f898
* SegCs: 0000001B:
* EFlags: 00010246: 003d0052 00490044 005f004c 00410043 004f004c 005f0053
* Esp: 01C8F854: 00412336 01c8f898 00000000 00000004 2149a1e4 00000000
* SegSs: 00000023:
*******************************************************************************
SqlDumpExceptionHandler: Process 22 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Using 'sqlimage.dll' version '4.0.5'
Stack Dump being sent to C:MSSQL7logSQL00026.dmp
Sunrise406, creation date and time: 2001/11/16(14:34:00), first LSN: 647599:6555:1, last LSN: 647633:8427:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:MSSQL7BACKUPSunrise406_tlog_200704250000.TRN'}).
Using 'xpstar.dll' version '2000.28.09' to execute extended stored procedure 'xp_regread'.
Database backed up with following information: Database: Sunrise406, creation date and time: 2001/11/16(14:34:00), pages dumped: 47456, first LSN: 647633:8425:1, last LSN: 647633:8427:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:MSSQL7ackupSunriseDailyBackup9pm'}).
View 5 Replies
View Related
Jun 8, 2006
I have a sql 2000 database on my local machine that I need to get to a faraway server so he can make one like it on his server. The admin tells me Ineed to make a dump of it and send it to him. I just don't know how to dothat. Can someone help me out?Thanks,Jerry
View 2 Replies
View Related
