SQL 2000 - Restore From Log Shipped Database After Disaster.
Jul 21, 2007
Is there any need to re-apply SP4 to sql server 2000 if a user database has been restored to it from a non-service packed sql 2000 server.
We inadvertantly did this after a flood and later realised that the log shipped server at the other site was not not service packed.
Does service pack 4 update user databases in any way?
We have not had any major issues with this but I need to rule this out when considering performance issues and so on that have been raised since the recovery.
Any help would be appreciated.
View 3 Replies
ADVERTISEMENT
Sep 15, 2006
Hello,
I would like to restore SQL Server Express and its databases from a tape backup to the same server. This is a disaster recovery senario.
I backed up the Master, Model, MSDB and my own test database using SQLCMD scripts. I have no problem restoring these using task manager on the server before the disaster recovery.
However, in my real disaster recovery testing, When the server is restored by tape drive (HP one button disaster recovery), I try to run my SQLCMD restore scripts in task manager and I cannot connect to the sql server. Also I cannot connect with Management studio. I have recieved the following error in event viewer.
----------------------------------------------------------------
Event Type: Error
Event Source: MSSQL$SQLEXPRESS
Event Category: (2)
Event ID: 3411
Date: 9/15/2006
Time: 8:16:36 AM
User: N/A
Computer: COPLEYNEWS
Description:
Configuration block version 0 is not a valid version number. SQL Server is exiting. Restore the master database or reinstall.
Data:
0000: 53 0d 00 00 15 00 00 00 S.......
0008: 16 00 00 00 43 00 4f 00 ....C.O.
0010: 50 00 4c 00 45 00 59 00 P.L.E.Y.
0018: 4e 00 45 00 57 00 53 00 N.E.W.S.
0020: 5c 00 53 00 51 00 4c 00 .S.Q.L.
0028: 45 00 58 00 50 00 52 00 E.X.P.R.
0030: 45 00 53 00 53 00 00 00 E.S.S...
0038: 00 00 00 00 ....
Event Type: Warning
Event Source: SQLBrowser
Event Category: None
Event ID: 3
Date: 9/15/2006
Time: 8:16:36 AM
User: N/A
Computer: COPLEYNEWS
Description:
The configuration of the AdminConnectionTCP protocol in the SQL instance SQLEXPRESS is not valid.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 9/15/2006
Time: 8:16:36 AM
User: N/A
Computer: COPLEYNEWS
Description:
The SQL Server (SQLEXPRESS) service terminated with service-specific error 3411.
C:Program FilesMicrosoft SQL Server90ToolsBinn>sqlcmd -S.SQLExpr
COPLEYNEWSDATABASEscriptsMASTERFULLRESTORE.sql"
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred whi
shing a connection to the server. When connecting to SQL Server 2005,
re may be caused by the fact that under the default settings SQL Serve
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
----------------------------------------------------------------------
My question is, what is the correct procedure to follow when I want to do a disaster recovery and restore SQL Server Express from tape backup using the Simple Backup method and scripts.
Is it always required to reinstall sql server express from the original program file or is it possible to reinstall from back up tape.
I know my backup and restore scripts work because I tested them on the server before I do the disaster recovery and rebuild that server from tape.
This is some kind of issue with SQL Server Express being restored by tape backup.
Any suggestions, thanks.
View 8 Replies
View Related
Dec 20, 2007
I have 2 sql server 2000 database that participate in log shipping.Server A is the source database, which log ships to a database onServer B. The database on Server B is in a warm stand by/read onlymode. Is there a way that I can add users to the database on ServerB, without having to add the users to the database in server A? I amtrying to use the database on Server B as a reporting only databaseand add more users to have permissions to run reports.Please let me know if anyone has any suggestions. Thank you.
View 2 Replies
View Related
Mar 20, 2015
We have log shipping for databases from production to back office (BO) environments for users to run reports. In preparation for moving a back office environment to a different server, we want to setup an addition log shipping environment, let’s call it BO2, same as the BO. One of the challenges we had was the amount of time it would take to get the full backup from production to BO2 due to the size of the database. It would take days just to transfer the full backup.
Solution:Let’s just say the database being logged shipped is DB123. Instead of using the full backup of DB123 from production, we use the mdf and ldf of DB123 from current log shipped database on the BO to setup the additional log shipping on BO2.
Steps:1.Setup the directory structure for the undo file (tuf) on the BO2 server same as the BO server.
Note: The undo can be moved to different drive after the log shipping is setup.
2.Stop SQL services on the BO server.
3.Copy the undo file (tuf), mdf, and ldf files of the log shipped database, DB123, from server BO to server BO2.
Note: Keep these files as main copies because they will be used multiple times. Do NOT copy files to where you’ll put the new database files.
4.After the files are copied, start SQL services on BO.
5.On the BO2 server, create an empty database DB123 with database name, file_id, logical names, physical names exactly the same as the ones on the BO server.
Note: Make the size of mdf and ldf small so it doesn’t take long to create the database.
6.Stop SQL Services on the BO2 server.
7.Overwrite the new mdf and ldf files of the empty database DB123 with the mdf and ldf files that were copied over from BO.
8.Start SQL services on BO2.
Note: If the file_id, logical names and physical names are not matching up, the database will be in suspect mode.
9.Do a backup of DB123 with COPY_ONLY.
10.Drop DB123 on BO2 after backup is complete.
11.Use the full backup from previous step to setup log shipping of DB123 on BO2.
Note: Below was the LiteSpeed syntax that was used
exec master.dbo.xp_restore_database @database = N'DB123' ,
@filename = N'F:SQL BackupsDB123_FULL.slsfull',
@filenumber = 1,@with = N'STATS = 10',
@with = N'STANDBY = N''C: MSSQLDataROLLBACK_UNDO_DB123.trn''',
@affinity = 0,@logging = 0
12.Stop SQL services on BO2.
13.Again, overwrite the mdf, ldf and undo file (tuf) of DB123 on server BO2 with mdf, ldf, and undo file (tuf) from BO.
14.Start SQL services on BO2.
15.Replay transaction log from PRD
Note: You can change the location of the undo file by copy the current undo file to the new location and point to new location in “STANDBY” parameter. DO NOT do cut and paste of undo file but do copy and paste.
It works on Microsoft SQL Server 2008 R2 (SP2) - 10.50.4033.0 (X64) . I have not tried it on SQL Server 2012 yet.
In steps that stop/start SQL services, you can bring the database offline/online.
In a way, this is doing detach/attach a log shipped database.
View 0 Replies
View Related
Jun 11, 2015
We have a production server "prod" which has a user say 'test' that lets the users connect to the application and a logon trigger which stops them from connecting to the server through SSMS. I log ship 'prod' to the 'rep' database and the user 'test' is obviously created in the logshipped database 'rep' during the logshipping.
Now the login 'test' does not have any login from server 'rep', But people can still login to the 'rep' server and query the 'rep' db . I checked with SUSER_SNAME and found the SID of the user in rep server which I never created and which is not even present in the login names, Even If I create a new username in the 'prod' db, after logshipping the new user is replicated in the 'rep' server.
View 9 Replies
View Related
Oct 11, 2000
Hi everyone,
Can you let me know, how to restore a database backup of sql 2000 into sql 7.0. If it is explain me the process of it.
Thanks
Jagannath
View 1 Replies
View Related
Sep 27, 2006
I currently work for a company that has had a "family business" mentality for many years. The only trouble is, it has grown into a fairly large company over the years and that mentality just doesn't cut it anymore (We have around 200 employees in 2 offices, and 25-50 remote users).
I have recently taken over the role of System Administrator, and I'm having a lot of trouble trying to get everything under wraps. There are a LOT of un-documented things happening with our database/web server, and in order to keep things safe & secure, I need to try & flesh out what those mystery settings would be. I feel that NOW is the time to get some solid documentation down, to protect my ass before some critical failure happens.
I'm wading into unknown waters here, and I'm hoping that somebody who's "been there" might have some tips to make my life a little easier.
I have an IBM Bladecenter, and a spare blade with which I can use to re-produce as close to a mirror copy of our system as possible. I have installed windows 2003 /w SQL2000 and restored a full backup of our databases and imported all database user accounts, and logins. What about Maintenance Jobs? Error Logs? Patches/Hotfixes? Service accounts? Membership roles? System databases? ODBC Sources? Services? Startup Scripts? I'm sure the list could go on & on... What are some of the crucial details I should look into?
Has anybody been in this boat before having little knowledge of what was built before you arrived, and have any insight on how to get through this without too much headache?
View 5 Replies
View Related
Nov 29, 2001
Hi,
Any one know how to restore a SQL 2000 backup on to a server which has SQL 7.0??
Thanks,
Naveen
View 1 Replies
View Related
Aug 4, 2007
My customer has SQL Server 2005. I have SQL Server 2000 on my laptop (on XP Pro). I believe I have an empty database the same as theirs, but I need to restore their data. They sent me a normal SQL Backup, but my laptop threw a fit and cannot work with it.
They are now trying to export the database to Microsoft Access and send me that, but I won't get that until next week now. However is there a better and easier solution for those of us with insufficient experience of this, please?
Many thanks,
Caspar
View 3 Replies
View Related
Aug 13, 2006
Hello,
If I have a SQL 2005 database set to SQL 2000 Compatiblity can I create a backup on SQL 2005 that can be restore on SQL 2000.
Michael
View 1 Replies
View Related
Aug 9, 2007
Sorry for basic question, But i dont know more about SQL Server,
During Last weak , i have bought a new server with Plesk 7.6 that SQL Server 2000 Express is installed on it, I want to know how can i restore databases that comes from other servers, for example restore a SQL Server 2000 Express backup file on this server? is there any special software?
Another question is about changing Collation of a database how can i change collation of databases that i make with SQL Server 2000 Express?
View 1 Replies
View Related
Sep 9, 2006
Hi,
Sorry for the wide distribution.
I'm trying to find any useful whitepapers about how to effectively build and operate a disaster recovery site at a remote location for SQL Server 2000. Does anyone know where to find such information?
I also know that one good option for my customer is using the Mirroring feature of SQL Server 2005. What are the other options? Is Replication an effective one for a mission-critical database (online banking)?
Thanks in advance
View 3 Replies
View Related
Oct 22, 2007
I am maintaining a .net 1.0 asp.net web application that accesses a SQL server 2000 database. I need to backup the database and then restore it on a laptop. Currently it resides on a server. The problem is that on the server they are using sql server 2005. If I backup using 2005 and then try and restore this database using SQL server 2000 or 2005 on the laptop, I get an error message. "Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE DATABASE is terminating abnormally.
What can I do to restore the database? Must it be backed up with SQL server 2000 and then restored with SQL Server 2005?
Please help!
View 1 Replies
View Related
Jul 20, 2005
Help,I have a database that has a data file of 2GB and a log file of 31GB.In enterprise manager, when I choose shrink it says there is 30GB ofunused space. When I shrink the database, it does not shrink,(however it says it has completed).I've done a complete backup, tried shrink again, no dice. I thenbacked up the database (which the backup was 1.9GB), deleted thedatabase and made a new database with 2,048MB for the data and samefor the log file.When I restore, the log file jumps up to 31GB again. When I check thespace when I use the shrink, it again says I have 30GB of unusedspace.How on earth do I get this file to shrink?I've been able to shrink other databases, but not this one.TIARob
View 1 Replies
View Related
Jul 15, 2006
I'm trying to see the differences between Backup/Restore and Attach/Detach. I backup and detach a database from SQL Server 2000 SP3 and then attach and restore it to SQL Server 2005 SP1.
The differences I noticed are:
1. The restored database has a much larger initial size (database size is same) for data and log.
2. The attached database has a last backup date
3. If the backup is restored over a database, the restored database is showing owned by the database owner of the database restored over but syslogins and sysusers do not match.
I don't understand why #1 happens.
Are there any other differences between Backup/Restore and Attach/Detach?
Thanks,
Peter
View 2 Replies
View Related
Sep 11, 2007
Hello,
I am attempting to restore the database from within VB.NET application I am making the following 3 calls:
RESTORE FileListOnly FROM DISK = 'C:MyDatabase.dat'
USE Master RESTORE DATABASE MyDatabase FROM DISK = 'C:MyDatabase.dat' WITH NORECOVERY, MOVE 'MyDatabase' TO 'C:Program FilesMicrosoft SQL ServerMSSQLDataMyDatabase.mdf', MOVE 'MyDatabase_log' TO 'C:Program FilesMicrosoft SQL ServerMSSQLDataLDFMyDatabase.ldf', REPLACE
RESTORE DATABASE MyDatabase FROM DISK = 'C:MyDatabase.dat'
using SMO. This logic works fine with small *.dat files, however when using *.dat file of about 4Gb I get an error on the 3d restore database call:
ExecuteNonQuery failed for Database 'master'.
An exception occurred while executing a Transact-SQL statement or batch.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Operator aborted backup or restore. See the error messages returned to the console for more details.
ExecuteNonQuery failed for Database 'master'.
An exception occurred while executing a Transact-SQL statement or batch.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Operator aborted backup or restore. See the error messages returned to the console for more details.
The same program/logic also works fine when I use MS SQL 2005 and it runs fine from MS SQL 2005 Query Analyzer for both 2005 and 2000 databases. There seem to be only problem with MS SQL 2000 from within VB.NET. Anybody has any idea? I'd appreciate any response. Thanks
Eugene
View 6 Replies
View Related
Jul 20, 2005
Yesterday I received a response to my CI/CS Collation problem and therecommendation was to try and restore a CI Collation database to a CSCollation database. After creating a blank CS database a full restore(Force restore over existing database) does change the Collation toCI. I'm unsure as to how I can restore without changing theCollation. Any suggestions?
View 2 Replies
View Related
Sep 13, 2007
This past Monday, our Raid 5 array failed on our SQL 2000 server (standard edition). Long story short, we were able to get the data back, mostly. In SQL server Ent. Mgr., I had to restore 4 databases that were 'Suspect' and "greyed out". No problems there... I was able to restore them.
What was interesting was that the SQL Server Agent would not start. As it turned out, a few files were either corrupt or missing after we got the machine back up. We had to restore a few files from tape backup and now the SQL Server Agent starts... but now I have a new problem.
For some reason, my default SQL Server Agent "Job" that is scheduled to run once per day fails. It appears that all of the databases get backed up, but for some reason, the msdbdata.mdf database is NOT being backed up.
I have a few questions. Could my msdbdata.mdf be corrupt? I have a successful backup of the msdbdata.mdf table from 9/10/2007. Can I just restore from that? Will there be any repercussions to any of the other database tables if I do?
Furthermore, should I just restore the msdbdata.mdf, master.mdf and the model.mdf? I really have no idea what these tables do and the repercussions of modifying them. I am not a DBA (obviously) and I just don't want to make an mistakes.
Thanks, CFDev.
View 5 Replies
View Related
Feb 19, 2007
SQL Server 2005 SP2 has now been Released To Web and is available for download:
http://www.microsoft.com/sql/sp2.mspx
February Books Online update is not included in SP2, get it separately:
http://www.microsoft.com/downloads/details.aspx?familyid=BE6A2C5D-00DF-4220-B133-29C1E0B6585F
View 1 Replies
View Related
Dec 27, 2007
Hi All
I have Computer is setuped SQL Server 2000 and SQL server 2005 when I restore SQL Server 2005 it's OK but when it's not OK when I restore in SQL Server 2000. The Error as follows:
Please help me to solve this problem. Thanks
View 1 Replies
View Related
Oct 17, 2006
Hi All
This is a very urgent requirement of my client having 200 stores and one Head office. the HO has just installed SQL-Server 2005, The HO sends small backups of the data related to stock transfer which needs to be restored at stores. It was working find when both the HO and stores were SQL-Server 2000. but the process has come to a dead halt as the HO has SQL-Server 2005. It is not possible to convert the stores immediately. please help me out.
Thanks
Raoshan
View 3 Replies
View Related
Nov 11, 2006
1. The title of this post says it all. My app will have a very small footprint to down load. I don't want to user to have to download 50 + MB just to try my little $15 app:-) So
QUESTION 1 - Will SQL Express be in the Vista bits? If so which versions?
2. Once SQLExpress is installed by whatever means, are there rules about how the instance is used? I have no problems playing well with others so I would be more than happy to create my DB in .SQLExpress.
QUESTION 2 - Are there any rules governing who can play in the Express instance? How should dtabases should be named to avoid collisions with the other kids?
3. I'd love to be able to work in in ClickOnce / user never has to have admin password environment.
QUESTION 3 - Besides UAC are there any constraints on writing to a properly installed Express instance that would get in the way of a pure user application from using the basic instance.
4. Right now - because I can't read directions and still don't understand the smoke and mirrors in VS 2005 when it comes to dealing with databases - I have DDL in my program that allows me to create my database from scratch. Not sure that this is the right way to go.
QUESTION 4. What is the best way for an user software to create its database in an instance of SQL Express.
5. SQL Express is yet another thingie that will run in the background that the typical user won't understand and wont' give a hoot about.
QUESTION 5. Can I / should I programmatically worry about whether the service is up and running? If so how do I launch it.
I know this is a lot for a single post, but it all sort of hangs together.
Regard,
Al Christoph
View 2 Replies
View Related
Jul 15, 2007
I have a file backup database SQL Server 2000
I want to restore it to SQL Server 2005.
But it failed.
I try :
Database ( right-click) - Restore Database - From Device - Specify Backup Add
Locate Backup File. I must choose File of Type is All File so that i can find file backup from SQL 2000, if i choose File of Type is *.bak,*.trn so i cannot find that file.
And then i choose OK all. But it failed. The error is below :
Restore failed for Server 'DHBK-734D0C3663'. (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Directory lookup for the file "C:Program FilesMicrosoft SQL ServerMSSQLdataqlsach_Data.MDF" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.Smo)
Program Location:
at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseOptions.RunRestore()
===================================
System.Data.SqlClient.SqlError: Directory lookup for the file "C:Program FilesMicrosoft SQL ServerMSSQLdataqlsach_Data.MDF" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft.SqlServer.Smo)
Program Location:
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages)
at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
View 11 Replies
View Related
Sep 23, 2014
Disaster Recovery Options based on the following criteria.
--Currently running SQL 2012 standard edition
--We have 18000 databases (same schema across databases)- majority of databases are less than 2gb-- across 64 instances approximately
--Recovery needs to happen within 1 hour (Not sure that this is realistic
-- We are building a new data center and building dr from the ground up.
What I have looked into is:
1. Transactional Replication: Too Much Data Not viable
2. AlwaysOn Availability Groups (Need enterprise) Again too many databases and would have to upgrade all instances
3. Log Shipping is a viable option and the only one I can come up with that would work right now. Might be a management nightmare but with this many databases probably all options with be a nightmare.
View 1 Replies
View Related
Apr 27, 2007
I have seen this before. A 2000 restore fails, leaving the database thinking it is being restored but the restore job failed and errors when it is restarted. EM is clueless. I believe there is a proc to reset some flag. Can you share it with me???
Thanks!
View 4 Replies
View Related
Nov 19, 1999
11/19
Trying to keep out sysadmins & sa during/between database RESTORE
Configuration:
WINNT Server Enterprise 4.0 w/SP5
SQL Server 7 Enterprise & SP1
2 SQL Servers:
Production Server
Standby server
I Backup (full backup) databases to disk on primary server (logical backup devices are physicaly located on a Standby server (dedicated gigabit NIC in each server for this process). Transaction logs are applied to the Standby server throughout the day.
Problem:
How to keep out "sa" and sysadmins from a database while I'm restoring (or between restores) to a standby server?
The database being restored cannot be in use during a restore.
If a DBA forgets that this process is happening, the statement fails (RESTORE)for the database they happen to be in at the time of the restore.
Example restore statement:
Standby Server -
RESTORE DATABASE databasename FROM database_dd WITH DBO_ONLY, REPLACE, STANDBY = 'g:Mssql7FromPrimaryDatabaseName_undo.ldf'
I could restrict Domain sysadmin access and change sa password. I could also put the database in "Single user" mode, however this could become problem if my process disconnects and then someone else connects - then my process is locked out. What I'm really looking for is to lock out all activity for a database that is in "standby mode" except for RESTORE processes.
Any ideas??
Wade
wadej@vailresorts.com
View 1 Replies
View Related
Feb 16, 2001
I am trying to restore a database that was backed up in SQL 2000 to our server which is running SQL 7.0 and I'm getting an error message. Is there a compatibility issue and if it is how can I resolve it?
Thanks
View 2 Replies
View Related
Jul 1, 2004
I have encountered a slight problem restoring a SQL Server 7 database to Server 2000.
In some of the tables, all records are duplicated.
When I try to delete them naturally I get an error "Too many rows were affected by update". What are my options here?
View 2 Replies
View Related
May 8, 2015
I need sql query to select max date shipment where sum of quantity required > sum of quantity shipped from sales line table but i dont know how to make my sales line table as following
shipment date quantity required quantity shipped
07/05/2015 200 100
07/05/2015 300 300
07/05/2015 100 50
06/05/2015 200 100
06/05/2015 200 200
Here the result of query i need is max shipment date is 07/05/2015 and quantity required is 600 and quantity shipped is 450 so tat i must select this date because quantity Required is big from quantity shippedmy question How i write the query get result above in sql server 2005.
View 9 Replies
View Related
Mar 8, 2002
Hi all,
Can someone tell me if I could get db dumps from sql server 6.5 and restored them into SQL Server 2000 Enterprise Edition Server.
If yes, could you please tell me the trick to achive this.
Regards
Uday
View 2 Replies
View Related
Jul 1, 2002
Junior Member
Posts: 2
Joined: Jun 2002
Monday July 01, 2002 11:00 AM (NEW!)
I am installing SQL 2000 on a brand new server. Once installed I will need to restore my db's from our current SQL 7.0 server. I know I can restore the user db's. I've read that you can not restore the MSDB and master db's. So What steps would I take to make sure I get all the info in these db's? I found an article on how to transfer logins and passwords, so that should get me my logins. I'm guessing I'll have to script up my packages /jobs somehow. How do I go about doing this? And what else am I missing that I will need to do in order for my master/msdb to contain everything that it contained on the SQl 7.0 server?
Also should I make the server name the same as the server name on the current box or do I have to make it another name? I'm talking about under the SQL server group.
Also I would like to keep the 7.0 version up for a bit and just make sure the 2000 side is working the way I want to . Our db are datawarehouse db that we use with another software package. So I will need to make changes there before I can totally turn it over to use the SQL 2000 db's One I've done this then I'll be ready for the switch. I will then restore the SQL 7.0 db again on the sql 2000 server and should be ready to go at that time.
What else am I missing. Any tips/precautions?
View 1 Replies
View Related
Feb 10, 2004
Hi...
I am trying to restore a week-old backup from a file of one database to a different (new) database for development. This is something that I do on a regular basis and have never had issues before. Now it is failing using both QE and Enterprise Mangler and am getting this error message:
Server: Msg 3135, Level 16, State 2, Line 1
The backup set in file 'D:BACKUPS......bak' was created by BACKUP DATABASE...FILE=<name> and cannot be used for this restore operation.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I have tried this....
RESTORE DATABASE temp_new_db
FROM DISK = 'D:BACKUPS..mybackupfile.bak'
WITH REPLACE
And this....
RESTORE FILELISTONLY
FROM DISK = 'D:BACKUPS..mybackupfile.bak'
RESTORE DATABASE temp_bio_remote
FROM DISK = 'D:BACKUPS..mybackupfile.bak'
WITH MOVE 'Original_DB' TO 'D: emp_new_db.mdf',
MOVE 'Original_DB_log' TO 'D: emp_new_db..ldf'
What am I doing wrong? Any ideas?
Thanks in advance...
Justin
View 13 Replies
View Related
May 28, 2007
Dear experts, I've a backup in sql server 2005. how can i restore that in 2000? and is it possible to do the same from 2000 to 2005?
Vinod
Even you learn 1%, Learn it with 100% confidence.
View 2 Replies
View Related
