Hallo!
I would like to create a backup file in SQP-Server Express and restor this backup-file in SQL-Server 2000.
I am looking for the command that produces the .bak-file.
Thank you very much!
Regards,
Fabian
my favorit hoster is ASPnix : www.aspnix.com !
I have a community server running in a hiring host, and I also install it on localhost. I would like to know how to backup the database from hosting and restore it to the site running on my localhost so that two sites is the same and in case there is an error from the hosting I can recover my database.
I can connect to my hosting database easily using SQL server Studio 2005, but the hosting does not offer backup through control panel. Could you please instruct me how to backup and restore database by SQL Server Management Studio.
Thank you very much,
Hi everybody, I've a 2003 server which I've installed on SQL Server Express Edition. I've 2 partitions. My Problem when I want to restor a backup from d:/, an error indicating me that the SQL can't access to backup file and it access denied ???!!.
Does anyone have an idea about this problem.
Best Regards.
hi
i have a database file backup which is having no extension (eg saims) . Can i create a database using this backup in sql server expression edition.
Or else is there any way to get the .mdf file from sql server 2005 full edition??????????????
Thanx in advance
How I can run a SQL Server Transaction Log Backup using a Windows CMD File. It's that posible? Anyone know the command or how do this?
We already have a application monitoring our SQL databases. Everytime the transaction log get full, it sends us an alert. Would be better if our application repair the problem itself, executing a command (Windows CMD File).
I'm not a expert using SQL databases or MS DOS Prompt commands.
Any help will be appreciate.
Hi ;
I am trying to create several Excel sheets using SQL 2000 views like so:
Select * INTO [Excel 8.0;Database="C:spreadSheetsaNew.xls"] FROM [aView].
When I try and execute this in my app I get the following - Specified owner
name 'Excel 8.0;Database=c:spreadSheetsaNew.xls' either does not exist or
you do not have permission to use it.
If I use the above Select statement with an OLEDB connection it works.
I am using Imports System.Data.SqlClient, instantiating a new SQlConnection
object, opening the connection, etc..
Thanks,
Gordon
Hi Dear,
May Any one guide me?
I have a backup file of database which is in SQL Server 2000. it has no Extension.I want to restore this backupfile or this database in my SQL Server 2005.
I have tried to Attach Database or attach this backup file in Sql Server2005 but it also fails .
First I have created New database name as is on the backupfile and then I have also tried to rename this file with .bak extension and then try to restore again it fails.
Plese Guide me urgently........
:eek: :eek: :eek: :eek: :eek:
Can I create an excel file by stored procedure?
View 2 Replies View RelatedHi,
I am trying to create a script that will create a backup (or copy) of an sdf database.
I have a database already in my application working nicely and want the user to have the option to backup that file so if anything goes wrong they will be able to click a button and it will restore all the data to the database. I am not sure which options are best for me. there are 3 main ones i have considered, these are:
1) Create a text file with all the data in it.
2) Create a HTML file with the data in it.
3) Create an xml file with the data in it.
Help would be appreciated. Thanks =]
Hi,
I am looking for tutorials about how to create dts et dtsx files.
Thanks for your help.
Arioule.
Hi all,
I have a ploblem...
i have ful backup file, diffrential backup file, transaction log backup file.
i want to create a new database form backup file.
i do it follow :
Using Enterprise manager
1. Rrestore database from full backup file. it is ok.
2. affter that i restore different database differential backup file. it does not work, the error is :' Theproceding operationdid not specify WITH NORECOVERY or WITH STANDBY. Resatr the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step. RESTORE DATABASE is terminating abnormally'
please show me,
nest regard.
hi
is it possible to create a database using backup in sql server DE??????????
like we can do in full edition using restore option........
I know this is easy but I am having trouble creating a database from a backup file.
I created a database (Test).
Then I selected 'Test', went to Tasks and selected 'Restore Database'.
I selected 'Device' browsed to the backup file.
I choose the destination database to be 'Test'.
There is no backup sets listed to restore. The 'OK' button is disabled.
How do you get the backup list to display? This is a new database. I don't need a backup.
I need to create a new db from a backup file of an allready existing database (vehicledb) on this server.So i created a new database with name "vehicledb2" .But when i try this, the backup says that this file is used...The backup set holds a backup of a database other than the existing 'Vehicles2' database. Restore of database 'Vehicledb' failed.
View 9 Replies View RelatedThis script will read the contents of a DB backup file, and generate a restore command.
Set the value of parameter @backup_path to point to the backup file, run in Query Analyzer, cut/paste the output into another Query Analyzer window, modify as necessary, and run.
This is just a barebones script to demo how this can be done. Modify as necessary to meet your own needs.
Works in SQL 2000 and 7.0. May work in SQL 2005, but it is not tested.
-- Create Restore Database Command from DB Backup File
set nocount on
go
declare @backup_path nvarchar(500)
select @backup_path =
-- Path to Backup file
'\SERVERNAMESHARE_NAMEMY_DB_BACKUP_FILENAME.BAK'
create table #header (
BackupNamenvarchar(128)null,
BackupDescriptionnvarchar(128)null,
BackupTypeintnot null,
ExpirationDatedatetimenull,
Compressedintnot null,
Positionintnot null,
DeviceTypeintnot null,
UserNamenvarchar(128)not null,
ServerNamenvarchar(128)not null,
DatabaseNamenvarchar(128)not null,
DatabaseVersionintnot null,
DatabaseCreationDatedatetimenot null,
BackupSizedecimal(28,0)not null,
FirstLsndecimal(28,0)not null,
LastLsndecimal(28,0)not null,
CheckpointLsndecimal(28,0)not null,
DatabaseBackupLsndecimal(28,0)not null,
BackupStartDatedatetimenot null,
BackupFinishDatedatetimenot null,
SortOrderintnot null,
CodePageintnot null,
UnicodeLocaleIdintnot null,
UnicodeComparisonStyleintnot null,
CompatibilityLevelintnot null,
SoftwareVendorIdintnull,
SoftwareVersionMajorintnull,
SoftwareVersionMinorintnull,
SoftwareVersionBuildintnull,
MachineNamenvarchar(128)not null,
Flagsintnull,
BindingIDuniqueidentifier null,
RecoveryForkIDuniqueidentifier null,
Collationnvarchar(128)null,
Seqintnot null
identity(1,1),
)
create table #filelist (
LogicalNamenvarchar(128)not null,
PhysicalNamenvarchar(128)not null,
Typenvarchar(10)not null,
FileGroupNamenvarchar(128)null,
Sizedecimal(28,0)not null,
MaxSizedecimal(28,0)not null,
Seqintnot null
identity(1,1),
)
insert into #header
exec ('restore HeaderOnly from disk = '''+@backup_path+''' ')
insert into #filelist
exec ('restore FilelistOnly from disk = '''+@backup_path+'''')
declare @tab varchar(1), @cr varchar(2)
select @tab = char(9), @cr = char(13)+Char(10)
select
[--Restore--]=
case
when a.Seq = 1
then
@cr+
@cr+'restore database '+c.DatabaseName+
@cr+'from disk ='+@cr+@tab+''''+
@backup_path+''''+@cr+'with'+@cr
else ''
end+
@tab+'move '''+a.LogicalName+
'''to '''+a.PhysicalName+''' ,'+
case
when a.Seq = b.Seq
then
@cr+@tab+'replace, stats = 5 , recovery'
else ''
end
from
#filelist a
cross join
( select Seq = max(b1.Seq) from #filelist b1 ) b
cross join
( select DatabaseName = max(c1.DatabaseName)
from #header c1 ) c
order by
a.Seq
go
drop table #header
drop table #filelist
Results, modify as needed:
--Restore--
--------------------------------------------------------------------
restore database MY_DB
from disk =
'\SERVERNAMESHARE_NAMEMY_DB_BACKUP_FILENAME.BAK'
with
move 'PRIMARY'to 'D:MSSQLDATAMY_DB_PRIMARY.MDF' ,
move 'DATA1'to 'D:MSSQLDATAMY_DB_DATA1.NDF' ,
move 'DATA2'to 'D:MSSQLDATAMY_DB_DATA2.NDF' ,
move 'LOG'to 'D:MSSQLDATAMY_DB_LOG.LDF' ,
replace, stats = 5 , recovery
CODO ERGO SUM
Windows 2003 backup utility uses the shadow copy option that allows it to copy open files.
Therefore, can I use this utility to backup the .mdf and .ldf files for my SQL 2000 database?
I can then attach the .mdf files if I need to restore the database to another server.
Can anyone tell me if this is safe? I've tried it and it worked but I'm worried there maybe some lurking danger in using this approach.
I want to read certain data from the backup file of MS SQL 2000 without restoring the database backup file. Based on the data selected I will manage the further functionality such as restoration of the backup file.
Is it possible to read some data from MS SQL 2000 backup file without restoring? If yes then please let me know how?
I want to know how people are backup up their win2k system and SQL 2000 server. If you want a run backup once a night and first backup win2k file system and then run backup using sql agent will that work?
Thanks.
Hi,
I've restored my database from backup on another SQL 2005 server and can't login, could you tell me what is the best way to repair this on SQL 2005, please
--
Regards,
anxcomp
Thanks in advance. What is maximum SQL Server database (*.mdf) file size with SQL Server 2000 as part of Microsoft Small Business Server 2000? (Database files were limited to 10 GB in SBS 4.5 with SQLServer 7.0... has this changed?).
View 1 Replies View RelatedHi!
Is it possible to restore a backup made with sql server 7.0
on a SQL Server 2000 without any problems?
I`d need that because I tried to upgrade a 7.0 and got an errormessage
that says, that sp_vupgrade_replication culd't run successfully...
Any Hints?
Thanx in advance
I am trying to backup a database thro' enterprise manager and the msg I am getting is 'SQL Server Agent on target server (local) is stopped. Make sure it is running during the scheduled execution of this job.'
I tried logging into Query Analyzer and I am able to - so the server is up and running. I am not sure what I am missing.
Please help.
Thank you,
I am trying to set a backup of my database on every hour. I know I need to create a job first but I don't know how to create one! Can someone help me out, please ?
View 6 Replies View Related
Dear sir,
SQL SERVER 2000 €“ BACKUP PLAN
I have used scheduled backup plan in my SQL Server 2000.In case, suppose users are entering data during the backup time. What my doubt is, at the time of entering data by the users, all the opened data tables are to be took for backup or not.
Regards,
v.annadurai
Hi!!!
I don't know much about SQL Server....
In our office, about 30 clients are connected with SQL server. There are 4 to 5 database each of more than 2 gb.
There are two files of extension LDF and MDF of each database.
* Is it necessary to take back up of both files? LDF files are important???
* Which method / software is best for taking backup?
* Is it possible to take backup while files are used by clients????
* Is it possible to split database in smaller size. because each time I have backup to entire more than 2 gb file....
* Are newer version of SQL 2000 are better than 2000? Should I use it???
please help...
thanks...
Hi,Good morning to All,
I have SQL Server 2005 installed on my system. Recently I have formatted by computer. But I couldn't take backup of my data. Big loss.
For this, I've googled also. but I couldn't get clear information.
I want like the following:I could able to backup entire the Database either into my pen-drive, or some other media.And, latter I could able to put the Data back into my system.
Can anyone please tell how to take backup of my Data, and Restore also.
Thanks in advance,Ashok kumar.
Hai friends,
I am using sql server 2000 as a Backend. I have stored nearly 50 user tables.Now i need backup that(export) , and i need to put that in another pc where sql server 2000 installed(import).
i have a "master" database.
do u have any simple steps , pl reply to me....
THANK U in ADVANCE
Ambrose
5 March 2000
Hai friends.....
I am doing project in ASP.NET(vb) my backend is sql server 2000...in my PC..
I have another pc....where sql server 2000 is installed.....
i have nearly 50 tables...in sql server 2000. in my PC..
I want to backup these tables from my pc and another pc...
can u tell me the steps...
I will try immediately....
Ambrose......
Hi Gurus,
I am new to SQL server and I need your advise on the following .
1. We have two SQL 7.0 Databases at a distant location and we want to move those databases to our location.
2. we plan to take the SQL backup of the databases in tape ( 4Gb and 2 Gb in size) , bring them here, restore them to SQL 2000 server.
- Is this possible , DO SQL 7.0 backups are restored on SQL 2000 without any problems ?.
Also, we plan to take log backups of the DBs at the source after the initial full backups and apply them at the target SQL 2K databases till we cut over to the Target Databases.
Ehat would be the best method of doing this? All your suggestions , pointers to real life scenarios like this, solutions are welcome.
Please let me know if you need any more informations , before suggesting any solution.
Thanks in advance
-Jay
Hi I'm an experienced programmer, but just don't have much experience with ASP or MSSQL. I inherited a website and now need to set up an automated backup system for a fairly large (40MB) MSSQL database hosted by a 3rd party provider of reasonable quality with ASP and SQL Server 2000. Let's avoid ASP.NET solutions since the website I inherited is written in "straight up" ASP (old school).
I have access to the database, login etc. I'm thinking I should combine an ASP script with the database connectivity and write daily/weekly backups to a dir on the hosting server.
Where do I begin? Tools? Examples?
Thanks for any assistance.
Stoob
I am experiencing the following problem when running a backup. This process was working really fine for 3 months.
BACKUP DATABASE [DBLIVE] TO DISK = N'C:BACKUPSdblive' WITH INIT , NOUNLOAD , NAME = N'DBLIVE backup C', NOSKIP , STATS = 10, NOFORMAT
Database size 10G
Recovery Mode : Simple
Daily Backup
Error message:
Executed as user: ACC33Administrator. 10 percent backed up. [SQLSTATE 01000] (Message 3211) 20 percent backed up. [SQLSTATE 01000] (Message 3211) 30 percent backed up. [SQLSTATE 01000] (Message 3211) 40 percent backed up. [SQLSTATE 01000] (Message 3211) 50 percent backed up. [SQLSTATE 01000] (Message 3211) 60 percent backed up. [SQLSTATE 01000] (Message 3211) Nonrecoverable I/O error occurred on file 'D:sqldbDBLIVE_Data.MDF'. [SQLSTATE 42000] (Error 3271) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Thank You.
Hello!
I have a bug in SQL Server 2000 that I would like to discuss.
The bug is described briefly on http://support.microsoft.com/kb/821334.
"The potential for inconsistency in the backup history tables backupset and backupmediafamily is resolved. This issue may cause the restore process to point to the wrong backup files."
According to my experiences the bug is extremely serious. SQL Server backup and restore operations are not fully reliable. If you have a disaster situation there is a possibility that you can not perform a restore.
Technically a media_family_id is generated in a backup operation and inserted into msdb.dbo.backupmediafamily. What could happen is that a media_family_id, that already exists in backupmediafamily, is generated.
The bug is fixed from version 8.00.0859, but only if you have an special undocumented trace flag (3003) enabled.
Here is the information that I have got from Microsoft about this trace flag.
"Trace flag 3003 changes how SQL generates media_set_id for new backup files. It will guarantee that new media_set_id values in backupset table are unique when you create a new file with your backup. This is the only place in code where TF 3003 is used so it will not impact your SQL Server operations."
I have a SQL Server with 80 databases. I have a maintenance plan with full backup every 24 hours and log backup every 5 minutes.
The error happened on my server a few times every 24 hours. I believe it's a general problem.
Best regards
Ola Hallengren
Hi All
I am using Sql Server 2000.
The database is being used since 5 years and the transaction file (mdf) has increased upto 12Gb.
We are thinking of reducing the size of the database and keeping only the data of the past 1 year. So I would like to know if there is some way of backup or export so that I can get latest 1 year data.
Thanking You All:S :S :S