SQLServerCentral / Backups / SQL Server 7,2000

SQL SERVER EVENT ERROR

shani19831 — Mon, 21 May 2012 09:19:35 GMT

Hi guysI'm having trouble on finding out what causing this error on one of out sql servers.Date: 5/21/2012 Source: MSSQLSERVERTime: 3:00:00 AM Category (6)Type: Error Event ID 17055User: NT AUTHORITY\SYSTEMComputer: 'sqlserver name'Description3041:BACKUP failed to complete the command dump tranXpBL with truncate_onlydump tran PXBL with truncate_onlydump tran CMBL with truncate_onlydump tran RPBL with truncate_onlydump tran WRHBL with truncate_onlydump tran TLBL with truncate_onlydump tran RepDo you guys have any idea on what causes this errors and how to resolve them?I had searched on GOOGLE but there seems to be loads of typical errors but no exact resolution.Your effort will be highly appreciated.Regards,Shani

RedGate SQL BackupPro 7.0?

Ray Herring — Mon, 20 Feb 2012 09:02:01 GMT

Hi All,I know 6.5 has been out for awhile.Anyone know when/if 7.0 might come along?

How to automate a backup on prod and a restore on test?

kevinsql7 — Thu, 03 Sep 2009 08:14:24 GMT

We are running SQL Server 2000 (SP4) on Windows Server 2003. I am looking for a simple, easy to implement method that would allow me to automatically restore the production sql server backups to the test databases. Currently, I back up the sql server databases on the production server and then xcopy the backups (just for storage on another box) to the test server. Note the backup file name contains the date and time stamp (pubs_backup_200909020421.BAK) so the restore script would have to reference this exact name in a scheduled process. (I currently use the SQL Maintenance Plans on the Production Server to create my sql server backups with the date time stamp as part of the backup file name.) I would think I would have to use a script to backup the database on the production server, xcopy the backup to the test server, and then use a script to restore the database on the test server. 1) On Production Server:USE pubs BACKUP DATABASE pubs TO DISK= 'd:\sqlbackups\pubs_backup_200902031724.bak'; GO RESTORE VERIFYONLY FROM DISK = 'd:\sqlbackups\pubs_backup_200902031724.bak'; 2) On Test Server;Scheduled XCopy Process which copies the backup file from production server to test server.3) On Test Server:RESTORE DATABASE pubs FROM DISK = 'd:\sqlbackups\pubs_backup_200902031724.bak'; Please provide advice especially with how to handle the date time stamp placed on the backup file name by the SQL Maintenance Plans. Or, should I backup each daily file to a name like: 'd:\sqlbackups\pubs_backup_sunday.bak'And then have a scheduled restore script to restore this particular daily backup file name.Lastly, is there a way to spool the output of the backup, verify and restore commands to a text file?Thanks, Kevin

Operating System Error 999

JohnnyDBA — Sat, 27 Jun 2009 08:31:47 GMT

We have a customer that uses a snap server as storage for their SQL Server 2000 databases. Lately we've been getting issues creating the backups, especially on two of the very large databases (450 GB and 500 GB).The error that I see (among others) is the following:[quote]Operating system error 999(Error performing inpage operation.)[/quote]I haven't been able to find much explanation online regarding this error. The only two possibilities I've found are1) Not enough disk space - I don't think this is the issue, it looks like there is plenty of space2) Bad blocks on the drive - I don't know how to verify this.Please advise.John

Significance of backup_set_id field in restorehistory table??

dilip-196624 — Thu, 23 Jun 2005 08:37:00 GMT

Hi,In SQL BOL, it states that the below description for backup_set_id in restorehistorytable************************************************************backup_set_id int NOT NULL REFERENCES backupset(backup_set_id) ************************************************************But I dont think whether it actually references or not, becoz i did a backup and restore(on network server) chekced the backup_set_id in both tables i.e. backupset as well as restorehistory tables, But both are having different ids? So i think it wont be any useful if we want to relate both the tables. Any thoughts?Dilip

Database backup and Log backup Failing regularly, backups maintained in TDP

rgvala — Tue, 31 Jan 2012 07:29:00 GMT

I am getting regular backup failed tickets on a Database. When checked in server , database name dosnt exist, it comes with an extension of existing Database.The error i am getting on a database with database name and extension as DBName__20120131_140010_8237335. Here is the log of TDP“01/27/2012 20:05:36 Database Database_20120128_030053_1646338' does not exist. Make sure that the name is entered correctly.01/27/2012 20:05:36 BACKUP DATABASE is terminating abnormally.01/27/2012 20:05:36 Changed database context to 'master'. (HRESULT:0x80131501)”Can anyone give me the solution for this.Thanks in Advance.RegardsRam

Single table backup using sqlcmd

kamleshsinhchauhan — Tue, 31 Jan 2012 02:06:46 GMT

I need to take a single table backup using sqlcmd???? How can i take a backup of particular table using sqlcmd??

issue with rebuildm.exe

huy1002 — Wed, 20 Jul 2011 14:15:41 GMT

after i copied rebuildm.exe and sqlsui.dll from CD to the SQL instance where these files are missing, i i ran the exe file and here what i got:"There are no qualified maintainable instances to rebuild".Do you know why? Please help, i have never seen this issue before

db autogrowth settings

Tim Jacobs-356724 — Tue, 10 Jan 2012 05:46:09 GMT

I am not a DBA but get into it on a periodically basis. We have db size of 50G with 25.3G free or 50%. Breakdown is as follows: Data 42G allocated with 17G free or 40%. Log 8.3G with 8.2 free or 99%. DB backup every day. Trans log backup everyday from 6 am to 11 pm. Only indexes with pages > 10 and fragmentation > 10 are reindexed once per week(this should probably be changed). The current(legacy) auto-growth is set at 3% for both data and log. We do not expect rapid db growth but can setup scripts to monitor. Given these conditions should auto-growth be set to 0 for both data and log? What is the most reasonable page count and fragmentation level to do DBCC DBREINDEX for the selected table\index?

blocking

madhu.dba444 — Wed, 28 Dec 2011 13:15:55 GMT

wt type of blocking we will get in sqlserver

Restore DB backup from Enterprise Edition to Standard Edition

chetanr.jain — Mon, 10 Jan 2011 23:56:29 GMT

Team,i have my production database on SQL 2000 Enterprise Edition. Now to test one of the component, i need to restore the backup to another server. To save on the cost, we have been given SQL 2000 Standard Edition ( not the enterprise Edition).Can i restore the prod db backup (SQL 2000 Ent) to Dev Box ( SQL 2000 Std).

REFRESH PRODUCTION DB to DEVELOPMESQNT

goofy2sql — Mon, 12 Dec 2011 20:46:23 GMT

HI Friends;I have a database in production which needs to be backedup and restored on Development box. THE PROD and DEV are two separate servers. The Development box has same databases that are on production. This needs to be replaced with latest production db's. Please help me the process I should follow;1. TSQL SCRIPT to BACKUP (what options, like format, init etc)2. RESTORE TSQL SCRIPT (what happens to existing files names on dev box.)3. HOW are users need to be mapped again.4. THESE PROD AND DEV. are in 2000 environment.Thanks for the help.SS

Any one using Tivoli, TDP from IBM????

devereauxj — Thu, 17 Feb 2005 12:18:00 GMT

We are using Tivoli TDP from IBM to do our backups to our tape robitic system. It has worked very well for backing and restoreing user databases.

My issue is with full instance restore, including all system databases. I did do full restores with SQL Server 2000 using backup devices. Now I am trying to do the same thing with the TDP utility.

My problem: I need to restore the user and system databases to another machine with a different instance name and maybe different drive config. I can restore the master, but it knows about the missing user databases and paths for the system databases. I have not been able to restore any user or system databases after the master.

Looking for someone who has done this with TDP, or might have more detail documentation. I have the standard document and the red book.

Thanks,

Joseph

Error on Backup to Netweork Location

Jack Corbett — Tue, 28 Dec 2004 13:15:00 GMT

I have a database, about 7GB, that I am attempting to backu pacross the network to a Firewire drive connected to another server. The bakcup runs and seems to be complete, but ends with an error. When I check the SQL Server log the error is:

BackupDiskFile::RequestDurableMedia: failure on backup device '\\cherry\dumps\mole\molert_full.BAK'. Operating system error 87(The parameter is incorrect.).

I have googled the error and have not found anything that is of any help. Most of the hits are just MS error code listings. Does anyone know anything about this Operating System Error?

I am successfully using htis backup strategy at another location.

Thanks,

sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

Cary P. Thrasher — Wed, 28 Jul 2004 12:25:00 GMT

At my Company, I set up a Maintenence Plan to back up one of our Databases (quite large) prior to the monthend processing. This was to ensure if data needed prior to month end load, data would be avaialble. I can run this myself and it works fine, but as a scheduled job it received this error. Does anyone know the answer to this. Additional info is that I set the plan to delete any backup old than three months, which hasn't been reached yet.

Error received -

sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

install Infosphere CDC SQL 2000

santuzzo01 — Thu, 20 Jan 2011 14:54:42 GMT

I’m trying to install IBM Infosphere CDC (old DataMirror Transformation Server) and I receive the message: IBM Infosphere Change Data Capture has detected multiple backups to the same file: C:\backups\mybase.trn.I deleted the file mybase.trn but still receive the same message. There is a requirement of Infosphere CDC to have only one backup in each file.I have SQL server 2000 SP4.Can anybody help me?

killing a large bcp

EamonSQL — Mon, 26 Mar 2007 09:54:00 GMT

Hi,

I kicked off a bcp that will dump over 20 millions records and needed to kill the process.Howevere this takes forvere to stop.

Is there a quick way of doing this?I am using xp_cmdshell 'bcp....out........' to dump the data.

Any help welcome.

Thanks in advance,Eamon

Would like to take sqlbackups in commvault completly

d.srikanth50 — Fri, 21 Oct 2011 04:00:55 GMT

Hi Friends,Requesting you to let me know the some information using your valuable time.In our organization we have 800 sql servers as of now for some servers SQL backups are configured through commvault. If we request backup team to configure the SQL backups for all the servers in the region wise (as assigned by you) it will help us to decrease the ticket count like backup failed, disk space issues etc.So please advised your thoughts,if it is good to have to take only commvault backups instead of sql backups in disk.please be advised disadvantages and advantages if we will not backedup databases in disk.

Backup DB structure

David Lester — Wed, 28 Sep 2011 12:46:36 GMT

I have an unusual situation where I want to be backing up the structure, views, stored procs etc, but not the data for one particular database. Is there a simple way to do this? The database is essentially a staging place for ETL, the important part for recovery are all the objects rather than the data.Thanks!

master restore in sqlserver 7.0

smileswithharish86 — Thu, 15 Sep 2011 09:26:55 GMT

Hi All,I am trying to restore the master database in sqlserver7.0 following the below steps.1)net stop msssqlserver 2)sqlservr -mexecution of sqlservr -m taking much time to get executed .Can any one please let me know if there is any other process to put sqlserver in single user modeor How to come out of this error?Regards,Harish.Gannnavarapu

Backup to SQL Server NULL device

ronss — Tue, 17 Mar 2009 10:37:44 GMT

How do I perform a SQL Server backup to a SQL Server NULL device. I have a need toperform SQL Server backups, but I don't want to send them to tape or a disk file. I wantthem to go to SQL Server's equivilent of the NULL device.Thanks

Backups and HIPAA

sbarlow — Tue, 10 May 2005 07:41:00 GMT

What are the sql backup requirements with HIPAA? does backups need to be password protected? Any Info would be helpful.

Backing up multiple databases on the Daily baises

tt-615680 — Tue, 24 Aug 2010 14:55:59 GMT

I want to backup multiple Databases on Daily biases and create a file for each Database. I would like the backups to have datetime stamp. I was going to use either Differential or incremental but I don't know the best solution. I would be grateful for your suggestions.Thank you in advance.

bcp out in UTF 8 format

rkjayaraj — Sat, 21 Jun 2008 07:38:43 GMT

I have SQL Server database table with International characters. Is there any way I can bcp out the table into csv file in UTF-8 format?

All of a sudden, DB restore very slow

matt_jk — Tue, 02 Aug 2011 17:59:17 GMT

Nightly, database from server1 is backed up, the dump file copied to server2, and then restored on server2.The copy takes about 45 min, and the restore used to be about an hour. A week ago, for no reason that we can think of, the restore just decided to start taking 4 to 5 hours. We loaded on the pssdiag tool and ran it all night. Checked for blocking contention through the night, there is none. The perfmon output is so huge I'm not sure what to look for. Nothing changed on the machine, nothing installed. Disk array shows no bad disks, all error logs are clean. Can anybody shed some light on what to look for, before we end up calling MS support?

Too much for too little

Nilesh Deshpande — Tue, 28 Jun 2011 19:39:15 GMT

Hi,I work on a sql server 2000 database at office and then at my residence. Till now, when the database size was small enough, I used to do a full backup at one place, take it on my pen drive and restore it at the other. Work on the database there and repeat the above sequence.The database size has now grown and the backup itself is now more than 1 GB.During each work session, I insert / update only a few rows in only a few tables.Is there no alternative to carrying a 1 GB backup to and fro everyday??Both the database servers are not connected to each other, so i guess replication is not the idea. But I might be wrong.What would be the best solution to this?Thanks

2 Instances backing up to same file

Carolyn Richardson — Tue, 12 Jul 2011 05:38:00 GMT

On a SQL Server 2000 instance we had a failure at the weekend, it was then noticed that a test instance that had been cloned from a production copy, had been writing its backups to the same location. I now have valid backups one full backup at 28/06 plus differentials and logs, but they contain info from 2 sources. That is looking that the header files we have 2 lines in each, part of header file shown below.[code="other"]LastLSN Checkpoint LSN BackupStartDate BackupFinishDate221292000000060100001 221292000000059700001 220587000000839300008 2011-07-10 02:00:02.000 2011-07-10 02:04:46.000219682000000489600001 219682000000488100004 219091000000169800003 2011-07-10 02:00:03.000 2011-07-10 03:45:10.000[/code]I was wondering if anyone knows of any tools or can help with a script that can unravel this for us as I'm struggling to find a way to restore everything. We have managed to manually restore up to Saturday night but are still missing some data.

Restoring 100Gb SQL 2000 Database ends with Nonrecoverable I/O error on file '???'

rthsw — Fri, 08 Jul 2011 09:34:08 GMT

Hi, i'm getting often (NOT allways!!) the errorMsg 3271, Level 16, State 1, Server SRVBACK, Line 1Nonrecoverable i/o error ocured on file '???'.Msg 3013, Level 16, State 1, Server SRVBACK, Line 1RESTORE DATABASE is terminating abnormallyi'm using a SQL-Server for archiving tasks. He holds for every Day of the month and for every Month one copy of our ERP-database. Every Database is about 100 Gb, so i need to use the onlinecompression from the hosting OS (Windows 2003 Server 32 Bit). I've done this for over 2 Years without any problems. Since some Updates to the SQL-Server in feb.2011 he doesn't like something in the restore process.The backupfile ist copied from the productive system via network to the uncompressed Drive d: on the archive sql server.some minutes later a dos-t-sql scripts starts, and restores from the same bak-file up to 4 copys of the productive database1) finPL 2) fin_test3) fin_d084) fin_2011_08_01every database is spread about 4 physical Harddisks (every Harddisk is mirrored):m:ndf1n:ndf2o:ndf3p:mdf & ldf1) is stored to uncompressed subdirectorys 2)-4) ist stored to a compressed subdirectoyThe first Database is mostly (every time?) without any error.the 2) Database is mosty restored without any error, but not allways.the 3) Database often returns with the error written above. Not allways!! The Database stays in the state "loading", and switches later to Loading/Suspect.the 4) Database is only generated at the first Day of the month, and is allways correct restored.If i start the task again, maybe the database 2 will be restored with an error, and the 3) will be restored corectly. If i start the task again, maybe one of the databases 2-4 are not able to be restored, but the one from before.The file remarked is really '???' , no usable Filename.For saving this archive, i'Ve also bought allready storage compress from red gate, and switched all directorys to uncompressed (but did not uncompress the allready compressed files, they will allways work without any problems if they are restored without error!). with storage compress the Server restored allways(!) all Databases correctly, but the storage compress got an error: as i shut down the sql-server (for rebooting, or istalling updates or something else), he crushes some (none till 3) Databases, so i can't access them, and will slow down the server in this case down to unusable. So at last i tried to uninstall the complete SQL 2000, removed al Directorys, installed an fresh version, installed Servicepack 4, installed the last Hotfixpack (the sqlservr.exe has the version 2000.080.2249.00, Timestamp 2.5.2007).No Change!Does someone know, which File SQL could mean with this Description '???' ?PS:The first ndf-file has 55 Gb. 33 Databases (for every Day of the month + test + Pricelist) needs 1815 Gb. today i can only use 2Tb Discs in this server, so i have no lasting space to save the monthly archive. With compression (is there another way to compress the databases online?), i can hold 33 Daily Databases AND up to 50 Monthly Databases, so i can hold 4 Years online. I need some kind of onlinecompression, and i've worked 2 years without any problems. does someone has a tip for me?

Log backup

shilpa.shankar87 — Wed, 06 Jul 2011 03:44:50 GMT

Hi,Please let me know my log backup contains only committed transaction or both committed and uncommitted tran in it.

SQL Express Backup

kgrady — Tue, 02 Nov 2010 07:05:24 GMT

I'm new to SQL and we have an SQLExpress database that we need to backup on a nightly basis. Is there a backup process with SQLExpress or will the Windows Server Backup process include the database if we point it to SQL location..?? Thank you..!!

No Luck with Differential backup retaindays

Hawkeye_DBA — Tue, 14 Oct 2008 15:21:36 GMT

I have tried several ways to get this to run - it is a DIFFERENTIAL backup so I cannot use a canned maintenance plan for it. I cannot for the life of me get my old files to purge when older than 6 days...any help is greatly appreciated./*****************Script For Differential Back Up of Database****************/--##STEP 1 --> Declaration of Variablesdeclare @dirPath varchar(60)declare @fileName varchar(60)declare @destFilePath varchar(60)declare @timeStamp varchar(30)--##STEP 2--> Assigning values to variablesselect @dirPath = 'E:\MSSQL\Backup'select @timeStamp = convert(char(8),getdate(),112)select @fileName = 'CedarRapids_W_Diff_Backup' select @destFilePath = @dirPath + '\' + @filename + '.bak'--##STEP 3--> Creating the subdirectory if it doesn't exist--EXECUTE master.dbo.xp_create_subdir @dirPath--##STEP 4--> Differential BackUpBACKUP DATABASE [CedarRapids_W] TO DISK = @destFilePath WITH DIFFERENTIAL, INIT, RETAINDAYS = 6, NOFORMAT, NAME = @fileName , NOSKIP, NOUNLOAD, STATS = 10Thank you,SSkaar07

daily basis backup in express edition

shilpa.shankar87 — Tue, 28 Jun 2011 00:26:04 GMT

Hi Friends,I want to know how i can schedule my database backup to be happened daily in EXPRESS EDITION

SQL Litespeed backup

ishaan99 — Wed, 15 Mar 2006 10:26:00 GMT

I am having problems restoring a backup file created by sql litespeed. I am using

EXEC master.dbo.xp_restore_database @database='checktemp', @filename='d:\aaa.bkp', @with='MOVE "aaa_DATA1" TO "D:\mssql\CAPS\data\checktemp.mdf"', @with='MOVE "aaa_DATA2" TO "D:\mssql\CAPS\data\checktemp_1.ndf"', @with='MOVE "aaa_LOG" TO "D:\mssql\CAPS\log\checktemp_log.ldf"', @with='RECOVERY', @with='REPLACE'

its works for a bkp file which doesnt have a data but if i try to restore a backup which has soem data it fails with error as

The file 'd:\aaa.bkp' is not a SQL LiteSpeed backup.Enter the correct path and name of the backup file. Both the bkps that are tried is on same location only diff is one is empty the other is not. any help will be greatly appreciated.TIA

couldn't take backup to remote location server.

Joseph-465703 — Fri, 18 Jul 2008 14:48:49 GMT

Hi,We are facing a problem, which is, we cant take DB backup to our remote location server. eventhough we have local backup file, the remote backup file is used in our couple of reporting servers which is then later used by jobs in reporting server to burst the reports.. the backup is done as part of jobstep in one of our production servers. we are using Litespeed for Database backup. in the error, it says the error happened becuase of previous error. but i dont see any previous error...Below is the error we are getting:----------------BEGIN OF ERROR DESCRIPTION------------------------------------Error: 50000, Severity: 18, State: 1SQL LiteSpeed: There are currently no logon servers available to service the logon request. LiteSpeed could not open the Backup file: (\\WGYUSRSQL\l$\RemoteBackups\PAS_from_PS2\pas_restore.bak). The previous system message is the reason for the failure. ---------------END OF ERROR DESCRIPTION------------------------------------Any help would be really appreciated.ThanksJoseph

NO_TRUNCATE

Imke Cronje — Fri, 20 Jul 2007 07:24:00 GMT

Hi Guys,

Just need some advice. When is it appropriate to use the NO_TRUNCATE in a backup statement. Can I use it if my database is in simple recovery mode?

Please advise.

Daily backup - Full database backup for SQL 2000

ridzuan_first — Tue, 24 May 2011 21:08:07 GMT

Hi all,Anyone know,1. How to backup 2 database on the same script for example I have two database TESTA and TESTB on the same server.2. How to add delete old backup files that are older than 7 days.3. How to add copy backup files at 2 backup directory example drive C and Z.I have this script from the net but don't know how to do.Really appreciate your helpdeclare @backupFileName varchar(100), @backupDirectory varchar(100), @databaseDataFilename varchar(100), @databaseLogFilename varchar(100), @databaseDataFile varchar(100), @databaseLogFile varchar(100), @databaseName varchar(100), @execSql varchar(1000) Set the name of the database to backup set @databaseName = 'TESTA' Set the path fo the backup directory on the sql server pc set @backupDirectory = 'c:\temp\' Create the backup file name based on the backup directory, the database name and today's date set @backupFileName = @backupDirectory + @databaseName + '-' + replace(convert(varchar, getdate(), 110), '-', '.') + '.bak' select @databaseDataFile = rtrim([Name]), @databaseDataFilename = rtrim([Filename]) from master.dbo.sysaltfiles as files inner join master.dbo.sysfilegroups as groups on files.groupID = groups.groupID where DBID = ( select dbid from master.dbo.sysdatabases where [Name] = @databaseName ) select @databaseLogFile = rtrim([Name]), @databaseLogFilename = rtrim([Filename]) from master.dbo.sysaltfiles as files where DBID = ( select dbid from master.dbo.sysdatabases where [Name] = @databaseName ) and groupID = 0 print 'Backing up "' + @databaseName + '" database to "' + @backupFileName + '" with ' print ' data file "' + @databaseDataFile + '" located at "' + @databaseDataFilename + '"' print ' log file "' + @databaseLogFile + '" located at "' + @databaseLogFilename + '"' set @execSql = ' backup database [' + @databaseName + '] to disk = ''' + @backupFileName + ''' with noformat, noinit, name = ''' + @databaseName + ' backup'', norewind, nounload, skip' exec(@execSql)

msdb.dbo.backupset table

Henry_Lee — Thu, 26 May 2011 08:00:57 GMT

Good day,I know sp_spaceused is not guaranteed to be accurate in SS 2000 unless UPDATEUSAGE is specified. My question is does the backup_size column in the msdb.dbo.backupset table report the same inaccurate space? My experience this week tells me the answer is yes, however, I'm looking for confirmation as this is a tough scenario to re-create in a dev envirionment.Thanks.

Integrity check fails yet full & transactional job successful

SQL__Newbie — Tue, 10 May 2011 04:27:04 GMT

Hi Guys,The Integrity Check keeps failing yet the full & transactional backup job is successful.The error message I receive in the logs are:[i][128] Database <database name>: Check Data and Index Linkage...[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. The following errors were found:[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. ** Execution Time: 0 hrs, 0 mins, 1 secs **[/i]Any Ideas?

Strange Restore Performance

Gordon Pollokoff — Tue, 03 May 2011 06:46:39 GMT

Here is the situation. I have a SQL Server 2000 Production Database running on a Windows 2003 Cluster. Every night we backup the database to another server which has the identical configuration except that it is not in a cluster. We then restore the database to use as a reporting copy. The database is about 300GB and we use Litespeed as our backup/restore tool. Until recently the backup would take about 30 minutes and the restore was taking around 30 minutes. About a week ago the restore suddenly began taking over 2 hours to run. Since this reporting copy is a source of our Data Warehouse ETL processes, we have a very tight window for getting the restore done.More data:This increased restore time only occurs during its normally scheduled window which is a start time of the backup at midnight. If I run the entire process at another time, say 10PM, the restore again executes in around 30 minutes. The only process running at the postmidnight restore is the restore process. I have confirmed this by checking sysprocesses and the only connections are from the restore. There are no other server processes (at least none that I can detect) running during the slow restore. I even ran SQLioSIM during the slow restore, using test files in the same location as the target database and got excellent IO durations. Any thoughts, suggestions, ideas? Anything will help. I can't continue staying up until 3AM every night babysitting this process.

BACKUP LOG cannot be performed ...

Michael Gerholdt — Tue, 19 Apr 2011 21:06:05 GMT

I am using SQL Server 2008 Express on a web server. Since SSIS and maintenance plans aren't available, I wrote a sproc, an sqlcmd file, and a bat file ... end result I have only one set of files and can pass parameter in. So I execute batch file from Task Scheduler passing in "Log" or "Database" or "Differential."It works fine, quite nicely.12.30 AM Full 3:30 AM Log 6:30 AM Diff 9:30 AM Log12:30 PM Diff 3:30 PM Log 6:30 PM Diff 9:30 PM LogEverything goes fine until the 9:30 PM Log backup, when for all User databases it failes with this in the audit log:BACKUP LOG cannot be performed because there is no current database backup.All the previous log backups succeed, and I'm just doing another Diff backup in between this Log backup at 9:30 pm and the previous one at 3:30 pm. What could be severing the sense of belonging to a media set or being aware of the Full backup taken at 12.30 AM?What would I look at to find out?Thanks for any ideas!