Hi,
I have Sqlserver 7.0 cluster configured with Omniback 3.5. My backups were fine till yesterday.We moved the database to another node and bacups are failing with error in sql server error log.
backupVirtualDeviceset::Intialize:open failure on backup device 'Omniback_II_msdb' operating system error -2147024894(The system cannot find file specified)
I greatly appreciate if any one can help to solve this
thanks
Mohan
Can I backup a db which is on server1 by sitting at server2 by way of running a script on server2.
Thanks.
How do we know the list of all the backups that are present in a particualr backup device like file# and time of backup taken etc for the purose of restore?
When I run :
RESTORE HEADERONLY FROM BackupDeviceName
it doesn't give that info. Can anyone tell me the exact command to list all the files of a backup device so that I can restore the right one??
Thanks.
Shalini.
DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.CREATE PROCEDURE [dbo].[spu_Import_Export_Image](@srvr varchar(50),@db varchar(50),@usr varchar(15),@pwd varchar(50),@tbl varchar(50),@col varchar(50),@mod varchar(1),@imgpath1 varchar(1000),@pk varchar(50))ASBEGINdeclare @path varchar(50)declare @whr varchar(200)declare @fil varchar(100)declare @cmd varchar(1000)declare @imgpath varchar(800)declare @ext varchar(5)--declare @pk varchar(50)declare @KeyValue varchar(8000)declare @image varchar(50)--declare @imgpath1 varchar(1000)declare @imgpath2 varchar(1000)declare @sellist varchar(2000)set @path = 'c: extCopy.exe'select @sellist = 'DECLARE curKey CURSOR FOR SELECT ' + @pk +' FROM '+ @tbl + ' ORDER BY ' + @pkexec (@sellist)OPEN curKeyFETCH NEXT FROM curKey INTO @KeyValueWHILE (@@fetch_status = 0)BEGINset @whr = '"where '+ @pk +' = "' + @KeyValueset @fil = @imgpath1 + '' + @KeyValue --+ @extset @cmd = @path + ' /S ' + @srvr + ' /D ' + @db + ' /U ' + @usr+ ' /P ' + @pwd+ ' /T ' + @tbl + ' /C ' + @col + ' /W ' + @whr + '/F ' + @fil+ ' /' + @modexec Master..xp_cmdShell @cmdFETCH NEXT FROM curKey INTO @KeyValueENDCLOSE curKeyDEALLOCATE curKeyENDGOAbove srcipt runs fine with image data type in one table but when irun for some other table it gives me Error MessageTEXTCOPY Version 1.0DB-Library version 8.00.194SQL Server 'WSQL01' Message 170: Line 1: Incorrect syntax near '99'.(Concerning line 1)DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.ERROR: Could not use database 'test1'NULL-----------Aslo it only runs on server console if i run it from workstation uingsame files and tables it gives me an error again. Can anybody help meand reply me at Join Bytes! asap.thnx,dharmesh
View 1 Replies View RelatedI have three problems related to Sql Server
a.I am developing a database application using VB5/VB6, SQL server 7 and Crystal reports.When I try to generate reports I get the message 'Automation error'. Please help-urgent.
b. I am using temperorary tables to generate reports.ie Table is created by user.Tables are generated runtime ie created as well as deleted. Sometimes
Sometimes i get the message 'SQLServer error' What should I do.What are the rights to be assigned to LOGINS?.
c.Is there precaution while installing SQLserver in WIN98.
How can i solve this problem ???
Error: QueryEngine encountered error: Call SQLExecDirect got SQL_ERROR
[37000:1101: on HSTMT] [Microsoft][ODBC SQL Server Driver][SQL Server]Could
not allocate new page for database 'TEMPDB'. There are no more pages
available in filegroup DEFAULT. Space can be created by dropping objects,
adding additional files, or allowing file growth.
Error in Process method of Component: QueryEngineServer, Project 11, Job
14797, Error Code= -2147212544.
I already saw the growth and it is correct, i have already set it to 96%.
I have disk space.
How can i solve this problem
Thanks.
Hello All,
I am not sure what is going on, but ever since I installed my ASP.NET shopping cart I keep getting the following error message in my Event Viewer under Application.
If anyone out there has any idea why this is happening please let me know because it seems to be crashing my other sites on my web server.
I have a Web Server which connects to a separate SQL 2000 Server. This error message is on my Web Server.
Thank you all in advance for your help!
Error:--------------------------------------------------------------------------------------------------------------------------
Event code: 3005 Event message: An unhandled exception has occurred. Event time: 1/6/2007 1:07:17 PM Event time (UTC): 1/6/2007 6:07:17 PM Event ID: 518a9db199214e3e807dd676e85f3d5a Event sequence: 103 Event occurrence: 6 Event detail code: 0 Application information: Application domain: /LM/W3SVC/1309570491/Root-1-128125656181152736 Trust level: Full Application Virtual Path: / Application Path: C:InetpubStoreV7 Machine name: CDMLWEB Process information: Process ID: 2376 Process name: w3wp.exe Account name: NT AUTHORITYNETWORK SERVICE Exception information: Exception type: SqlException Exception message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Request information: Request URL: http://www.bestpricetags.com/default.aspx Request path: /default.aspx User host address: 207.38.200.139 User: c2e1ff27-e0ea-4c7f-ac61-5b1716651d3b Is authenticated: True Authentication Type: Forms Thread account name: NT AUTHORITYNETWORK SERVICE Thread information: Thread ID: 10 Thread account name: NT AUTHORITYNETWORK SERVICE Is impersonating: False Stack trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at AspDotNetStorefrontCommon.DB.GetRS(String Sql) at AspDotNetStorefrontCommon.DB.GetSqlN(String Sql) at AspDotNetStorefrontCommon.AppLogic.IPIsRestricted(String IPAddress) at AspDotNetStorefront.Global.Application_AuthenticateRequest(Object sender, EventArgs e) in C:InetpubStoreV7App_CodeGlobal.asax.vb:line 103 at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I get the following error in the SQL Agent log file
Password verification of the 'SQLAgentCmdExec' proxy account failed (reason: Logon failure: the user has not been granted the requested logon type at this computer)
Does anhbody know why this happens.
Let me know.
Thanks
Cynthia
Hi,
I have question. My SQL Server Agent Log has the following error messages logged. Does anyone know why this happens. It happens everyday when I back up a 40 GB Database. Let me know. I Appreciate the help.
Thanks,
Cynthia
6/14/01 9:30:58 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:30:59 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:01 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:30:58 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:30:59 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:00 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:01 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:02 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:03 PM - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
6/14/01 9:31:07 PM - ! [382] Logon to server '(local)' failed (JobManager)
I keep getting this error when I try to connect to my SQL Server DB
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'Administrator'. Reason: Not associated with a trusted SQL Server connection.
when I installed SQL Server I set username and password to windows default which is Administrator and no password
the asp files are on IIS (localhost)
connstr = "Provider=SQLOLEDB;" &_
"Data Source=(local);" &_
"Initial Catalog=ShotWatcher;"&_
"User ID=Administrator;"&_
"Password="
shouldn't this work?
Please Help
Justin
Hi there,
I access to server SQL by an application on web,I configured the ODBC box for using TCP/IP and the server use also the TCP/IP.
I have this message :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.
/medecin/IdentificationAcces/membre_enregistrer.asp, line 108
I don't know why there is Named Pipes in message.
Please help me
thanks in advance
Jalal
Intially my backup was working fine since couple of days it started failing, when i checked the backup through maintainance plan i saw that it does'nt recognize the mapped drive it says invalid drive.
Basically i want to take backup of the on database A from Server A to Server B which i mapped. G:oppxyz00t142linktest.
Both Sql server and Agent use the system account => kavitha is the user account through which i login hence i think this is the system user name, i have been give full access to the mapped drive.
I appreciate your help.
Kavitha
When i tried to take a backup on a remote server i got this error.Not only this master all the user tables and other system databases also failed,the also give the same error.
Database master: Database Backup...
Destination: [dgssmf01q001ackupmastermaster_db_200108220401.BA K]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL Server Driver][SQL Server]Write on 'dgssmf01q001ackupmastermaster_db_200108220401.B AK' failed, status = 5. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally.
could any one tell me what might have caused it and how do i go about to solve this.
Thanks for your precious help.
Kavitha
I get the following error when I try to access the database from my web application
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
The application works when I run it on my local machine, but when I move the application to a remote server, I get the above error.
Below is the connection string section in my web.config file.
<connectionStrings> <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|CiaaASPNETDB.MDF;user instance=true;Integrated Security=True;Initial Catalog=CiaaASPNETDB;Integrated Security=True;user instance=true;Connection Timeout = 0" providerName="System.Data.SqlClient"/> <!--Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|CiaaASPNETDB.MDF;user instance=true;Integrated Security=True;Initial Catalog=CiaaASPNETDB --> </connectionStrings>
Can anyone help me with this.
Hi,
Schedule backup job which usually completes in 1 to 2 minutes, it's been running for over three hours. Meanwhile transact log backup job executed and it's hanging also.
I stopped the jobs, which now shows last run status 'cancelled'. But the spid still exeists in 'current activity' pane with status 'runnable'.
No locks or blocks!
Is there anyway I can get rid of this spids so that I can start backup job again?
It's very urgent..
THanks
My database backup which was scheduled to run every day at 2A.M is still running, I issued kill command for the process at 10.45A.M , rollback process is still running for the last two hours. Can anyone help me out how to solve this problem.
Thankx
VS
My overnight backups hang occasionally. I say this because there is no consistancy to when the routine will hang. It happens on the first step where it reindexes. The only user database on the server is about 12GB. The server is dedicated to SQL so nothing else runs on it. It has 2x 800 MHz processors with 2 G of ram of which 1.5 is allocated to SQL.
I can't trace the error because it happens before the report is written to. There are a few tables with a million plus records that take up almost a 1G per table.
It was my understanding that if users were in the database they would notice a big performance loss but that the backups would still run. Could it dying because of resource contention? I'm at a loss and really could use some input. I can't afford to go a whole weekend without a backup.
Is there a way for me to progammatically check who is the database prior to the job kicking off?
Any ideas as to what would cause an inconsistant hang of job is greatly appreicated.
Thanks,
Kelsey
Hi,
What do I do if transaction log is full ?????
Can I automate the truncation of the transaction log????
Bindu
By mistake i restored a database to different one.
It actullay overwrote it.
Is it possible to roll it back to the state before i restored.
I need your answer as soon as possible
I have got a recent backup problem that just does not make sense. The system is able to perform hourly backups of my transaction logs fine but my daily backups of the entire database which occurs every night now fails. I tried recreating my daily backup job all over again from scratch and the job still fails.
When I perform a manual backup of the database however the system works fine.
Hi All,
Sql server 7.0
i have a db ABC and want to restore it as ABCbak, I am taking the backup of the db ABC and restoring it on ABCbak, i am also seeing that the physical names are different but logical names remains the same. Will this cause any kind of problem to db ABC.
Waiting for reply.
TIA
Adil
I have installed Beta 2 over SQL Express and when i wanted to install either Beta 2 or Express it dosn't allow e and i need to backup my databases urgently?
how can i do that?
is it possibe to do it with the phisyical files?
Hi
Is there a way to restore only one table from a DB backup.
I need restore one table not database because I have update others tables in this database.
thanks in advance
kinds regards
Abdel
Hi Every one,
According to our stratergy we are taking trans log backup of every user database everuy two hours.things seem to work great and with success at the day time and at night once at 12.03 and 2.03 they fail and when i checked the error log i found that there is only one database for which its failing and it gives the following error.
Database ors: Transaction Log Backup...
Destination: [D:BackupTranLogorsors_tlog_200108280203.TRN]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4213: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot allow BACKUP LOG because file 'ors_Data' has been subjected to nonlogged updates and cannot be rolled forward. Perform a full database, or differential database, backup.
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally.
We had a option called select into/bulccopy set which i disabled once this failure has occured but still the problem persists....there are no other options set...i am out of resources i donno what to do..could you suggest me something and how to solve this problem its happening in prod.
Thanks for your help.
Kavitha
Hi Every one,
According to our stratergy we are taking trans log backup of every user database everuy two hours.things seem to work great and with success at the day time and at night once at 12.03 and 2.03 they fail and when i checked the error log i found that there is only one database for which its failing and it gives the following error.
Database ors: Transaction Log Backup...
Destination: [D:BackupTranLogorsors_tlog_200108280203.TRN]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4213: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot allow BACKUP LOG because file 'ors_Data' has been subjected to nonlogged updates and cannot be rolled forward. Perform a full database, or differential database, backup.
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally.
We had a option called select into/bulccopy set which i disabled once this failure has occured but still the problem persists....there are no other options set...i am out of resources i donno what to do..could you suggest me something and how to solve this problem its happening in prod.
As Said by someone i took a full backup...tooooo it does not solve the issue.
Thanks for your help.
Kavitha
Hi All,
I am trying to restore transaction log using T_SQL:
restore log transfer from transfer_log with file = 2 ,norecovery
and also I was Trying--
restore log transfer from disk = 'c:mssql7ackupransfer_log.dat' with file = 2,norecovery
I am getting this error Message-
Server: Msg 4306, Level 16, State 2, Line 1
The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally.
Any Ideas,Please Let me Know ASAP
Thank You ALL--
Hi Everybody,
Our branch office in Europe has sent full 'backup' file of capacity 25GB.
I have to restore this backup to our database. Their database is 'Candidate'
and our database is 'client'. Both these databases have different logical
names and physical names.
The following Batch script only I hv executed,
RESTORE DATABASE Client
FROM DISK = 'd:dumppaw01dump.bak'
WITH MOVE 'candidatedata' TO 'e:mssqldataclient_data.mdf',
MOVE 'candidatelog' TO 'd:mssqllogclient_log.ldf',
REPLACE
Can anybody tell me, what I have executed above is correct or not. Now
restoration is going on for more than an hr. Still it is going on. Is there
any other way to restore this backup set very fastly.
Our server has got very good hardware setup. Good amount of hard disk space.
4GB RAM Memory. Running 4 processors. No other service is running apart from
SQL Server. Right now nobody is accessing the server.
How long it will take to restore this backupset?. This is urgent please.
Any help would be appreciated.
tks in advance,
Sri
hi,
my Backup job, took a backup at 3.00am , backup went well, but this job is still running , now the time is 10.00am.
I tried to kill this job but it is still running.
Why my process still running after taking a backup also.
Can anyone suggest me, how i have to resolve this.
Thanks!
--Ram
SQL7, SP3:
I backup the databases (Master, model, msdb, db1, db2) to disk every night on our test system. I then use Veritas Backup exec to backup the os files to tape. I'm using backup devices, I've recreated them several times to try and resolve. Theres' enough disk space as when I run a bu in Query analyser it's fine. But throught EM there's a problem:
I've been receiving an error in the EM job:
------------------------------------
Write on 'db1devicename' failed, status = 112. See the SQL Server error log for more details. [SQLSTATE 42000] (Error 3202) Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
------------------------------------
Then in the SQL log:
------------------------------------
BackupDiskFile::OpenMedia: Backup device 'E:dbaBackupdb1Full.bak' failed to open. Operating system error = 2(The system cannot find the file specified.).
I confirmed that the device is pointing to thecorrect path, there is space, the db activity is low or no users at the time.
This happens only on one server. Fine on three others with similar setup.
Thanks,
There is a database located at remote location we wanted the same on the local server..so we backed it up then restored the same on the local server everything went successfull.
When i tried to create user it says the user is already existing, but nither can i see the user nor drop the one..(ofcourse not existing) it gives me an error 15023.
The other problem is that when i check the storedprocedures i can see and open them when i try to look for permissions or assign it by clicking permissions tab it says the specific stored procedure doesnot exist and gives me a sql-dmo error 21770.
I donno what do..help would be appreciated.
Mark
Hello,
I'm in trouble, I have just dropped a table from a sql dbase and now need to recreate it. I have no backup and I am panicking!!! I need to know if I can recrreate them .
If this can't be done let me know I have to bit the bullet
thanx
Folks, this is the error i get when backing up user db to local disk:
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
10 percent backed up.
Connection Broken
If i copy a file (2gb) to local disk from network it works. The disk have much space. Any ideas;;; :confused:
I get the same error when backuping up even MSDB to a network path using UNC [\].
Mrs,
I'm having a serious problem in SQL 2000 SP3 Database which is used Business Applications.
Today, I tryied to take backup in service time by the Enterprize Manager, the following
error occured and could not take backup.
--------------------------------------------------------------------------------------------------------------------------------------
Error 926 : Database '[database name]' cannot opened. It has been marked SUSPECT by recovery.
See the SQL Server errorlog for more information.
--------------------------------------------------------------------------------------------------------------------------------------
After that, we tried same operation 3 times. But result is same.
After sometime, end-user report us that they can not log-in to database.
So we tried to dettach this database and attached it.
We success to dettach, but we can not attached it.
Also we tried to restore this database from Yesterday's backup file by using Enterprize Manager,
but the following error occured, and could not complete.
This backup file was generated daily backup task in Maintenance Plan in Enterprize Manager.
--------------------------------------------------------------------------------------------------------------------------------------
Microsoft SQl-DMO(ODBC SQLState:42000)
The media family on device "E:ccd......xxx.bak" is incorrectly formed.
SQL Server cannot process this media family.
RESTORE DATABASE is terminating abnormally.
--------------------------------------------------------------------------------------------------------------------------------------
We need to recover the database immediately not to stop the end-user business process.
Please help us.
Yamagury.