Recent update: 2008-3-21
1. I have an issue regarding backup in Microsoft SQL SERVER 2000. I have a database with 700GB size. What could be the best solution(s) for backup. 2. I have 72 GB tape storage device, if I start the same 700 GB backupon 72GB tape device, will it be ask for the next tape after completingone ...
2532 byte By
DerekL at 2008-3-6
Hi all,I am trying to restore and SQL 2000 database into a new SQL 2005 database. I performed by SQL 2000 backup and created a blank database FERS_Production in SQL 2005. FERS_Production was the original name of the database in the SQL 2000 instance.I have tried giving the new database the same ...
Hi all, I am working with SQL Server2000 and I have done a horrible thing here.We here have an script that delete all data from all user tables of a database, and I run it in the master DATABASE.As we don't made backups of this database, now somethings of the database aren't working.Here is ...
573 byte By
Belly at 2008-3-3
Due to a network time skew some time ago, all of the databases on an SQL system now have the following information stamped on them..Within Enterprise Manager (SQL 2000), The "Last Database Backup" timestamp for each database is showing the year 2025.Our backup system runs ...
Hi, my 'model' database corrupted and my SQL Server 2005 Express can't be started.I believe I have the SAME problem as his: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=455524&SiteID=1but when I try the command start sqlservr.exe -c -T3608, an error message appeared:"Your ...
483 byte By
yosonu at 2008-2-28
I have a 2 way cluster and I want to apply SP4 on it.Basically, I have 2 servers. Server A runs a default instance and another instance. While the default services is disabled and the other instance is running, Server B runs the default instance and has the other instance disabled. This ...
<h6> hi !!</h6> I want to attach database to SQL Server, but I'hv only .mdf file. I lost .ldf file, how should i attach this DB to server ? Thanks SP
Hi What is the best way to perform daily offline/remote/off-premise backups of our websistes Sql Server 2005 database?I've looked into using SSIS but for one reason or another am having serious problems with this. Ideally we'd like to be able connect over the internet and/or lan and pull the ...
SQL 2005I have a scheduled back up running at 1am everynight which after a few problems is running ok.Can I get it to overwrite the existing nights back up? no data has yet to be added to the database as we are still testing yet the back up is doubling in size each night. Not really a SQL ...
I have a SQL Server 2005 server with no maintenance plans configured and no SQL agent jobs. The SQL logs are indicating that every night around midnight the databases I have created are all taken offline and backed up. How do I determine what is triggering these backups?
hi to all, I'm newbie with Sql Server,I've a serious problem. After a crash of one of my disk I loose all the data about the SQL Server db but I've the mdf and ldf files because were placed on another hard disk different from the SQL Serve Installation disk. I reinstalled the Sql Server (in ...
Trying to set up replication between two machines (Developer Edition) and receiving an unitialized pull subscription. Error message states the publisher cannot be accessed with an agent message of 20084. Any ideas? Thanks!
476 byte By
solnt at 2008-2-22
Hi all. First, sorry about my poor english. I have a database which above 6 gb data and i have droped all table in my database. I try to restore from log file but my database is set to simple backup and auto shrink so log file doesn't help anymore. I have used some software to recovery from ...
Up to now we have gotten by without having any local DR copies of servers (if a sql server goes down we are usually able to get it back in less than 3 hours). But I want more now. I want to trim the "down" window to no more than 5 or 10 minutes. (Immedate failover would be nice but is ...
802 byte By
joe_it at 2008-2-20
Afternoon All,We have a SQL Server 2005 instance that I am running a few databases on, nothing too big though.CRM-3.0GFI-Network Monitor DatabaseFuture UseSolomon, and SharepointThe goal is to have all of our databases running on one server for backup and maintenace. Currently we are using ...
968 byte By
RensV at 2008-2-20
Hello!Hopefully someone can help me with the following (potentially huge) problem:We've got a simple database application running on microsoft sql desktop engine. This database contains two tables. Up until now all worked fine, but probably due to a programma that crashed part of the database ...
Hello, I am new to the forum and hopefully someone can help me with theproblem I have. Lately, I noticed that my sql statements are timing outduring the time SQL server is running backup job. The errors I amseeing in the log are:Process 59:0 (724) UMS Context 0x06403BC0 appears to be ...
<font size=2><span style="font-family:Geneva,Arial,Sans-serif">is it possible to add an SQL 2005 database into SQL 2000 server?</span></font>
I've tried starting SQL from the command line in single user mode (-m). When I try to open Management Studio I receive an error that it can't connect. Can you only restore master from a command line in SQL 2005? Or can I do it from a GUI? Thanks, Mark
Hi!I have a customer that wishes to run a rather big web-based system, hosted by my company. The main criteria for this project is that is should always be available, rather than optimized for speed. The project requires Windows Server 2003 along with SQL Server 2005. I have thought about two ...
270 byte By
Gigi69 at 2008-2-16
Hi, i need to attach my db, but i receive this error: an error occurred while processing the log for database 'xyj'. Could not open database 'xyj' . Create database is aborted. (Microsoft Sql Server, error 9004). Can you help me?
I was able to successfully create a database maintenance plan for SQL Server 2000 Transaction Log Shipping for a few databases a few weeks ago. Yesterday, I created a few more but to my surprise, I can no longer do it. I can create a maintenance plan but the job it creates does not start even ...
576 byte By
EngHim at 2008-2-15
I have schedule backup job from SQL Server 2000 to Tape. Each Jobs consist of 4 steps which backup different database.Sometimes I encounter problem. The Message is Executed as user:dbo. The file on device '\\.\Tape0' is not a valid Microsoft Tape Format backup set. [SQLSTATE 42000] (Error ...
2532 byte By
DerekL at 2008-2-15
Hi all,I am trying to restore and SQL 2000 database into a new SQL 2005 database. I performed by SQL 2000 backup and created a blank database FERS_Production in SQL 2005. FERS_Production was the original name of the database in the SQL 2000 instance.I have tried giving the new database the same ...
Dear all, I am a newbies in SQL server. One of my client what to using Clustering and SAN Feature to make his SQL server have high avaliabilty. However, since they want to utilize the SQL server, they would like to active/active cluster with network load balancing. However, questions comes:1. ...
hello all,I am using SQL Server 2000.I am facing a problem since yesterday that my sql server does not start.It gives me the error that 'Could not start sql server. sql server does not exists or access denied....Instance already running' when I try to start or connect to the server.I changed ...
3913 byte By
ddoo at 2008-2-14
SQL 2005 Express - Database Restore size problem Was this post helpful ? Hi,I'm trying to restore a SQL Server DB Backup from a SQL Server DB Server on to my Laptop (SQL 2005 Express)When I execute a restore filelistonly command on the backup file, It seems that the Database included is ...
I need to ensure users can submit SQL queries (readonly) to a database whilst transaction logs are restored (at 15 minutes intervals.) Is this possible?
270 byte By
Gigi69 at 2008-2-13
Hi, i need to attach my db, but i receive this error: an error occurred while processing the log for database 'xyj'. Could not open database 'xyj' . Create database is aborted. (Microsoft Sql Server, error 9004). Can you help me?
Hi, I am testing with Log shipping, I have it setup and it is working just fine. The secondary database was restored with Standby mode and is readonly. I have no problem accessing and querying data from the secondary database but I noticed if changes are made to the primary and I am accessing ...
4013 byte By
ddoo at 2008-2-12
SQL 2005 Express - Database Restore size problem Was this post helpful ? Hi,I'm trying to restore a SQL Server DB Backup from a SQL Server DB Server on to my Laptop (SQL 2005 Express)When I execute a restore filelistonly command on the backup file, It seems that the Database included is ...
2532 byte By
DerekL at 2008-2-11
Hi all,I am trying to restore and SQL 2000 database into a new SQL 2005 database. I performed by SQL 2000 backup and created a blank database FERS_Production in SQL 2005. FERS_Production was the original name of the database in the SQL 2000 instance.I have tried giving the new database the same ...
2532 byte By
DerekL at 2008-2-10
Hi all,I am trying to restore and SQL 2000 database into a new SQL 2005 database. I performed by SQL 2000 backup and created a blank database FERS_Production in SQL 2005. FERS_Production was the original name of the database in the SQL 2000 instance.I have tried giving the new database the same ...
321 byte By
ezhil at 2008-2-10
When I tried to restore backup of publication database, time taken for restoration is too long [ 4 hours]. The actual database restore takes only 20 minutes but the stored procedures used for cleanup replication takes the remaining time. Is the issue related to my environment or the cleanup ...
467 byte By
ezhil at 2008-2-8
In SQL 2000, When I restore a database backup called "A" as "B" the datafile name and log file will change automatically with the new restored database name , whereas in SQL 2005 the datafile name and log file name remains with backup database name. Will this issue be ...
Hi, Where can I post issues with SQL 2005 clustering. Is there any prereq that needs to be followed before installing SQL 2005 on a windows cluster? Thanks
Hello,I am experiencing an issue with SQL Server 2000 Maintenance Plan.DB Backup job fails to delete old backup files from the file server (I am backing up to the network share - actually, a DFS). Backup part of the maintenance plan/job succeeds, but then cleanup part fails. I made sure that ...
Having moved over to SQL 2k5, from SQL 7.0 we have now realised that the database's need to be set to comp level 9.0 before they are found in the maintence plan wizard, we currently still access the database using an Access 2000 front end, by changing the comp level will this cause us issues ...
I need to ensure users can submit SQL queries (readonly) to a database whilst transaction logs are restored (at 15 minutes intervals.) Is this possible?
242 byte By
Ches00 at 2008-2-7
receiving error during backup. Microsoft SQL-DMO (ODBC SQLState: 42000) The media set for database '%' has 2 family members but only 3 are provided. All members must be provided. BACKUP DATABASE is terminating abnormally.
QuestionWhat is the best way to transfer Stored Procedures to another db without having to script it? WHYWe need to transfer stored procedures from one development database to another on different machines not on the same network.PlatformStudio 2005SQL Server Management Studio Express ...
576 byte By
EngHim at 2008-2-6
I have schedule backup job from SQL Server 2000 to Tape. Each Jobs consist of 4 steps which backup different database.Sometimes I encounter problem. The Message is Executed as user:dbo. The file on device '\\.\Tape0' is not a valid Microsoft Tape Format backup set. [SQLSTATE 42000] (Error ...
Hi,I have a SAN and configuring a cluster on SQL 2005. I initially created a Quorum drive when setting up the cluster and now added 4 more drives to the physical node but when I try to install SQL that drive cannot be located.Do we need to create all the drives when installing the cluster or ...
hi all how i can read all the querys that send to the server exmple insert , update statement need all this statement at the end of the day how can i do that by sqlserver thanks alot
I have one sql server 2000 that the log file grew to 118 over weekendI have since shrinked it....I am monitoring it and now the MDF is at to 16 gig....It seems the MDF and LDF are grewing at increasing rates.If i look in current activity i see locks/objects I always see tempdb.dbo.##lockinfo65 ...
Hi, Where can I post issues with SQL 2005 clustering. Is there any prereq that needs to be followed before installing SQL 2005 on a windows cluster? Thanks
Hey guys Just a question. If I use NtBackup with Sql server 2005 & sql writer started, the NtBackup use the Volume shadow Copy Service and the Sql Server Writer ? That is if do I do the backup of the log and data files, is these correctly and with consistence? Very Tanks
Any idea to copy a standby/readonly database. We a have a standby/readonly DB from logshipping for hot standby and we would like to make a copy of this standby/readonly DB into a read/write DB in the same server for daily testing. Thanks in advance!
In sql2005 the database backup retention has been added in sql server properties in database setting.In 2000 we had a comfortable option to set retention based on maintenance plan,files and also our space availabilty.It has helped the dba's a lot.But it has been removed in sql 2005.Is that sql ...
Running SQL Server 2005 Standard Edition.Database is in Full Recovery mode.I have full backups scheduled weekly, differentails scheduled daily and tran log ackups scheduled for every 15 minutes.The tran log backups only work for the first 40 minutes or so after the daily backup. Once the daily ...