MS SQL Server :: Problems Importing Backup DB Into Express

Importing DB Backup File To SQL Server 2005

Mar 14, 2007

Hi all,

I'm using shared sql space on a new provider and am trying to import a database backup file - of the format filename.db.

I cannot figure out how to import this file type using the 2005 express tools - I can connect to the database and create and drop tables alright, but I cannot just import the existing database.

I really haven't got the time on my connection to download the fully blown SQL server trial to be able to do this, so can anyone help me out with any easier solutions?

Cheers, Mike

View 2 Replies View Related

Importing DB Backup File To SQL Server 2005

Mar 14, 2007

Hi all,

I'm using shared sql space on a new provider and am trying to import a database backup file - of the format filename.db.

I cannot figure out how to import this file type using the 2005 express tools - I can connect to the database and create and drop tables alright, but I cannot just import the existing database.

I really haven't got the time on my connection to download the fully blown SQL server trail to be able to do this, so can anyone help me out with any easier solutions?

Cheers, Mike

View 1 Replies View Related

Error Importing Sql Server 2000 Backup To Slq 2005

Sep 5, 2007

Hello

i have a backup of sql server 2000 pro sp4 database and i want to import it to a sql server 2005 developer edition sp2. i tried to import the database using RESTORE DATABASE IntEx
FROM DISK = 'C:projectsackupBDIntEx.bak' and got the following error

quote:
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:Program FilesMicrosoft SQL ServerMSSQLdataIntEX_Data.MDF" failed with the operating system error 3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'IntEX_Data' cannot be restored to 'C:Program FilesMicrosoft SQL ServerMSSQLdataIntEX_Data.MDF'. Use WITH MOVE to identify a valid location for the file.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:Program FilesMicrosoft SQL ServerMSSQLdataIntEX_Log.LDF" failed with the operating system error 3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'IntEX_Log' cannot be restored to 'C:Program FilesMicrosoft SQL ServerMSSQLdataIntEX_Log.LDF'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

i tried then importing it with the restore function from sql manager and got the error:

quote:
TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'AMDINSIDETESTBED'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLIntEx.MDF'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476

as i said i'm using a sql server 2005 sp2. i tried the scripted method when i did not have sp2 in sql server and it worked without a problem. after installing sp2 it seems it does not want to work anymore. i also tied making a backup of a sql server 2005 database, deleting the database and restoring it and it worked again.

can somebody give me any advice on this problem?

View 3 Replies View Related

Importing To SQL Express Using SSMSE

Apr 10, 2007

When I used Enterprise Manager it was very easy to import required tables from another server into my local MSDE server.

Now I am using SQL Express and SSMSE I cannot seem to find any other way of importing data other than creating the insert scripts manually which is a very painful and tediuos operation!

Can anyone advise if I have missed something and there is a way to import easily using SSMSE?

Thanks.......in hope

View 6 Replies View Related

Importing Data Into SQL 2005 Express

Mar 28, 2006

I am getting a dump of information from SAP into an Excel file. I would like to take this excel file and import the data into a SQL 2005 Express database.
Is this possible? Or will I need the full version of SQL to do this?

Thanks

View 2 Replies View Related

Importing A Script Into SQL Server Express

Apr 1, 2006

I am having trouble importing a database script into SQL Server Express. The script is from the Web Applications book from the Microsoft MCSD exams. My installation of SQL Server Express appears to be fine as I can login and create/delete databases through it. When I attempt to import the database script I get a variety of errors as follows:Msg 911, Level 16, State 1, Server ORTHANCSQLEXPRESS, Line 1Could not locate entry in sysdatabases for database 'Contacts'. No entry found with that name. Make sure that the name is entered correctly.Msg 15401, Level 16, State 1, Server ORTHANCSQLEXPRESS, Line 1Windows NT user or group 'ORTHANCSQLEXPRESSASPNET' not found. Check the name again.Msg 15410, Level 11, State 1, Server ORTHANCSQLEXPRESS, Procedure sp_addrolemember, Line 80User or role 'aspnet' does not exist in this database.Msg 15410, Level 11, State 1, Server ORTHANCSQLEXPRESS, Procedure sp_addrolemember, Line 80User or role 'aspnet' does not exist in this database.I have added access permissions for the ASPNET user account on the SQL Server Express folder but that doesn't appear to have helped. I'm not sure if the error about contacts.mdf means that I should have a contacts.mdf created as a result of the script or whether it should be there to begin with. I found this thread http://forums.asp.net/thread/433540.aspx but it didn't solve my problem.Apologies for the length of the post. Any help at all is greatly appreciated!

View 4 Replies View Related

Importing Data To Sqlserver Express

Jul 25, 2007

I would like to import data to a sqlserver express database. The database I am interested in importing was created in MSDE. I tried backing it up and using the restore function in sqlserver express but with no success. I have not been able to find an import function in the Management Studio Express interface. Is it possible to import this information, or should I get busy with my data entry?

View 4 Replies View Related

Importing Csv Files To SQL Server Express

Nov 22, 2007

Hello,

I receive 4 .csv file downloads periodically (3 times per day) via email from our corporate database. I open each file in Excel, save as excel files, import to Access, replace the previous tables...run action queries, generate reports combined with production data from CSRs and supervisors. ALL DONE MANUALLY!!!

Here's where I am now:
-I've recently switched over to SQL Server Express.
-Used SSMA to bring tables over from previous Access database.
-Exercised the option to LINK these tables to the original Access database.(I'll explain why in a moment)
-Created ADPs for front end data entry use.
-Imported old Access database forms into the new ADPs previously used in Access.
-Connected to the new Server Express.
-I've eliminated my concurrent user problems by doing this.
HOWEVER, I am still bound to using old Access/Jet database to generate reports based on periodic downloads from corporate .csv files.

Here's the question:
What is the best way to import the csv files being sent to me via email into SQL Server Express? I've tried DTS. Seems to me you can't save AND actually use the packages later since it's the Express edition..... Importing manually 4 files, 3 times per day is a very tedious option I'd like to avoid. Any ideas?
Oh, by the way. Corporate has told me they would be willing to post the files to an FTP site instead of emailing the files. That's about as much help as I'm going to get from them. Can SQL Server Express be set up to run stored procedures (triggers) on a hot folder?
Thanks for your help.

David

View 3 Replies View Related

Importing Data Into SQLServer Express

Feb 25, 2008

I am currently Using SQL Server Express for testing purposes while waiting for SQL 2008 to be issued. (Our project will take some 2-3 years to complete so concerns about using a 'new' version of SQL Server are not pertinent). We have ordered this week Visual Studio 2008 as the shrink wrap version is due out the end of this week.

I have been able to migrate all our data from the old database (Superbase) but only field names and field types.

Indexes and validation stuff is lost.

The problem I have is that:

I can only import to an empty database, therefore if I start to create Indexes and otherwise modify the structure of this database in SQL Server then I will lose all this work on the next occasion I need to import (as Superbase will still continue to be our firm's current daily data handling tool for another year or two)

My thoughts where to create a copy of the original import, develop the constraints, indexes etc. on this secondary copy. then (on the day we are ready to migrate) empty the copy of data and import the data only

Does SQL Server Express have the tools to do this?

If not then are my best options to use SQL Server Beta until the new software is realeased (but notice that Visual Studio 2008 does not like SQL2008 - is there a fix for this?)

I hope this is the right forum for these questions

Thanks in advance

View 4 Replies View Related

Importing Access Tables To Sql Server Express

Oct 29, 2006

hi. this is a beginner question as i am new to databases :)so, I have an access database and I want to take 2 tables from it and copy it to sql server in my ASP.NET application (.MDF file)I have visual studio 2005 installed on my computer and got no sql server 2005 installed on it. what is the way copy 2 tables to the ASP.NET database application?thanks alot guys.

View 2 Replies View Related

Importing A Flat File Into SQL 2005 Express?

Jan 26, 2008

I'm a little stuck here. How can I import a flat tab delimited file into a SQL 2005 Express table? The standard DTS and import features are not there :-(Thanks,Casey

View 1 Replies View Related

Importing Access Database Into Sql Server Express

Feb 15, 2006

[Note: originally posted this on microsoft.public.sqlserver.programmingbut had no luck there...sorry if you're seeing this twice]Some facts:1) I have an Access database (.mdb file) sitting on my harddrive.2) I have Visual Studio 2005, Sql Server Express, and Sql ServerManagement Studio Express.3) I do *not* have Microsoft Access.What I'm trying to do:I simply want to import the Access database into Sql Server Express. Inother words, I want to end up with a Sql Server Express database thathas all the same tables, keys, and relationships as the Access databaseas well as all the data from it. I can live without the queries storedin the Access database, but those would be nice too.What I've tried so far:I'm able to connect to the Access database using the "Linked Servers"features in Management Studio Express. From there, I was able to writesome simple Transact-SQL queries to find out what tables are in theAccess database and copy them, one at a time, into a Sql Server Expressdatabase.This is definitely a good start, but it doesn't take care of theprimary keys or foreign keys. There appear to be procedures for thoseas well (sp_primarykeys, sp_foreignkeys), but I keep thinking theremust be an easier way.Which brings me to...Questions:Without having to buy additional software/tools, can I import thisAccess database without a lot of programming? If so, how?Thanks in advance,-Dan

View 1 Replies View Related

Importing From Excel To SQL Server 2005 Express

Jan 18, 2006

I'm trying to import a database. It seems my most likely route is via Excel, so I've moved my tables in there.

Then I tried setting up Excel as a linked server as described in http://support.microsoft.com/default.aspx?scid=kb;en-us;Q321686

My linked server gets created apparently with no errors, but I can't see any contents when I click on it in the object explorer.

Anyone with more clues than me?

thanks

View 6 Replies View Related

Sql Server 2005 Express And Importing && Exporting

May 8, 2007

also i was wondering, that i have been reading that with this sp2 for sql server 2005 express you are able to use the dts wizard, is this true? i have a few databases in access that i would like to import into sql, would i have to create the tables first in sql then import or will the import also bring the tables & structure in?

thank you to all

View 1 Replies View Related

Importing XML/ASCII Files To SQl Database Using VB Express

Jul 19, 2006

Hi everyone,

I have to write a program in VB to receive the read data from a RFID reader for my graduation project.The problem is I am not a computer science student so I have only general info on programming.

I created my DB in VB express but I couldn't find out how to send the read data (that will be either in XML or ASCII format) to my database...The read data will be transferred to my computer by the RFID reader's software but after that I don'T know how to transfer it to my DB.As I know I have to use commands like read.xml etc,but no idea how write the complete program.

I checked the forum and couldn't find the answer,sorry if someone already answered my question and I missed it.

Thanks...

Can

View 2 Replies View Related

Is There Limitations To Importing Data To SQL Server Express

Apr 7, 2007

I have software that uses SQL Server Express as it's database. I am only able to import so many records until it stops and fails to allow me to import anymore.

I'm very new at this but, is there some type of limitation on Table size that's preventing me from importing anymore data?

I'd really appreciate it if someone could help me,

Thanks... Bill

View 10 Replies View Related

Importing Oracle Data In SqlServer Using Express

Nov 8, 2007

OK so there is some data in an Oracle DB that I have to summarize based on grouping info stored in a SqlServer DB. How can I import the Oracle data into a SqlServer temp table using SqlServer Express? Thanks.

View 2 Replies View Related

Importing Data From Access 2002 In SQL Express

Jan 18, 2007

Hi All,

At the moment i have a piece of software that uses Access to store the data into a number of tables.

I am developing a new piece of software that has been built around SQL express and need to upgrade users that are using access. I have managed to write the installation to install etc and also the start of a script to insert all of the tables. I cant work out how to get the data into SQL express using a script.

Basically the access db (CentralDb) will be stored a a given location C:Program FilesCentralDB.mdb

The tables within the SQL version are indentical to access but i need a way of pulling out the information stored and putting it into SQL, and as there is no DTS i am becoming stuck on how to automate the process.

Any ideas?

Thanks in advance

Martin

View 1 Replies View Related

Importing Access Database/tables To SQL 2005 Express???

Feb 1, 2006

Is it possible to import an MS-Access database (or table) into a new SQL Server 2005 Express database? If so, how is it done?

View 1 Replies View Related

Importing Data From Flat File Into 2005 Express

Nov 16, 2006

Hello everyone,

I have exported data from few tables from my old sql server 7.0 database. Now, I need to import those data into new database which is on SQL Server 2005 Express. How do I do that in 2005 express server? Any idea?

Or, is there any better way to import data for selected tables into new database?

Thanks,
Ujjaval

View 2 Replies View Related

Importing An Excel Spreadsheet Into A Sql Database Using Sql Server 2005 Express

Nov 29, 2006

hi, i have an excel spreadsheet with data that i want to place into a sql database.is there any easy way of doing this with sql server 2005 express?

View 3 Replies View Related

Importing Images To SQL Server 2005 Express Edition Database

Sep 5, 2007

Hi,Could someone give a pointer how to import couple of hundred imagesinto Sql Server 2005 Express Edition database?Is there a tool for it? Can it be done with Sql Management Studio oris it just a matter of writing own piece of software (a little helperapp) to do it?-timonardo

View 1 Replies View Related

Importing Tables To Microsoft SQL Server Management Studio Express

Jan 11, 2006

Hello,

I'm trying to import some tables from another sql server to my laptop. I just downloaded Microsoft SQL Server Management Studio Express and i'm not sure how to import things. Could anyone help me with that?

Thanks a bunch

j

View 9 Replies View Related

Importing Access Table Into SQL Server 2005 Express Table And Adding One Field

Feb 16, 2007

Hi all,

Hopefully I am posting this question in the correct forum. I am still learning about SQL 2005. Here is my issue. I have an access db that I archive weekly into and SQL server table. I have used the dst wizard to create an import job and initally that worked fine. field I have as the primary key in the access db cannot be the primary key in the sql table since I archive weekly and that primary key field will be imported several time over. I overcame this initally by not having a primary key in the sql table. This table is strictly for reference. However, now I need to setup a unique field for each of the records in the sql table. What I have done so far is create a recordID field in the sql table that is an int and set as yes to Identify (auotnumber). That worked great and created unique id for all existing records. The problem now is on the import. When I try to import the access table i am getting an error because of the extra field in the sql table, and the error is saying cannot import null value into this field. So... my final question is how can I import the access table into the sql table with one extra field which is the autonumber unique field? Thanks a bunch for any asistance.

Bill

View 7 Replies View Related

ASP.NET 2.0 And SQL Server Express Backup

Jul 28, 2006

I´m developing an application that uses SQL Server Express as the Back-End, i want to provide to the user an inteface where he can make backup of the database or restore a backup file, i really don´t know where i can begin with this task or what´s the best approach for doing stuff like this, i need some guidance here because we finish with the application and we are just adding some usefull features to the user.If somebody has any idea, i am willing to learn and listen carefully. thnaks to everybody.Thanks to everybody, Cesar

View 2 Replies View Related

Can't Login To Db After I Do A Db Backup In SQL Express

Dec 5, 2006

I have a working dnn site. I've created several modules and corresponding tables in the database and everything works great. Then, I open SQL Server Management Studio Express, attach to the database, backup the database, detach from the database and I can no longer run my site (error shown below which says I cannot login to db). I can open the database from Visual Studio and see my tables, but I cannot run the application. Rebooting doesn't help. I've even tried copying over the database with a prior copy. It still doesn't work. The only way I have found to reconnect to the database is to copy over the entire dotnetnuke install directory with a copy I made prior to the backup. Then it works again.
Anyone else had this behavior? How do I fix it?
Thanks

----------------- DB ERROR BELOW --------------------------------------
DotNetNuke Upgrade Error
The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] ) ERROR: Could not connect to database.Cannot open user default database. Login failed. Login failed for user 'PARAPRO1ASPNET'.

View 1 Replies View Related

SP To Backup SQL Express Databases

Mar 2, 2007

Hi - I use the windows scheduler to execute an SP for my SQL Express instance on a server.
The SP loops through the SQL Express databases, and makes a backup - however, it will only backup the attached databases.
Is there anyway I can modify it, to make it backup the databases in my various web sites, within the app_data folder? These aren't attached, but I think get attached when the web application needs them, then detached afterwards - so they are never permanently attached!
Thanks for any help,
Mark
The SP I use us:/**
File Name: BackupExpress.sql
Description: Backs up all databases. This script is mainly meant for SQL Express instances
The script requires a C:ackups directory by default to backup to but can be changed with the @OutputPath variable.
Accompanying file is BackupExpress.cmd, which is used to schedule the script.
Author: Brian Knight

DateChange DescriptionAuthor
8/15/2006Initial releaseBrian Knight

**/

SET QUOTED_IDENTIFIER OFF

USE master
GO
SET NOCOUNT ON

DECLARE @dayofweek varchar(20)

SELECT
@dayofweek = CASE datepart(dw, getdate())
WHEN 1 THEN 'Sunday'
WHEN 2 THEN 'Monday'
WHEN 3 THEN 'Tuesday'
WHEN 4 THEN 'Wednesday'
WHEN 5 THEN 'Thursday'
WHEN 6 THEN 'Friday'
WHEN 7 THEN 'Saturday'
END

DECLARE @OutputPath varchar(500)
DECLARE @DatabaseBackupFile varchar(500)
DECLARE @FolderName varchar(25)
DECLARE @DatabaseName varchar(25)
DECLARE @strSQL varchar(2000)
DECLARE @hostname varchar(255)

SET @hostname = (select replace(convert(varchar(255),serverproperty('SERVERNAME')), '','_'))
SET @OutputPath = 'C:Backups'

DECLARE cur_Backup CURSOR FOR
select name from sysdatabases where name !='tempdb'

OPEN cur_Backup

-- Fetch the db names from Cursor
FETCH NEXT FROM cur_Backup INTO @DatabaseName

WHILE @@FETCH_STATUS = 0
BEGIN

SET @DatabaseBackupFile = @OutputPath + '' + @hostname + '-' + @DatabaseName + '-' + @dayofweek + '.bak'
PRINT ''
PRINT ''
print @DatabaseBackupFile

SET @strSQL = 'BACKUP DATABASE '+@DatabaseName+' TO DISK = "'+ @DatabaseBackupFile+ '" WITH RETAINDAYS = 7, NOFORMAT, INIT, NAME = N''Full Database Backup'', SKIP, NOREWIND, NOUNLOAD, STATS = 10'

PRINT @strSQL
PRINT ''

EXEC (@strSQL)

FETCH NEXT FROM cur_Backup INTO @DatabaseName
END

-- Distroy Cursor
CLOSE cur_Backup
DEALLOCATE cur_Backup

SET NOCOUNT OFF

View 2 Replies View Related

MSDE Db Backup To SQL Express

Oct 1, 2007

Hi everyone!

We are trying to restore a database backup created o MSDE 2000 server to SQL Express 2005.
The collation settings of both SQL Express and MSDE are the same: Turkish_CI_AS

The problem is that the log of restore operation has some warnings like:

Processed 344 pages for database 'MYDB', file 'MYDB_Data' on file 1.
Processed 1 pages for database 'MYDB', file 'MYDB_Log' on file 1.
Converting database 'MYDB' from version 539 to the current version 611.
Database 'MYDB' running the upgrade step from version 539 to version 551.

Warning: The index "myt_idx01" on "dbo"."myt" may be impacted by the
collation upgrade. Run DBCC CHECKTABLE.
Warning: The index "PK_BankLDef" on
"dbo"."BankLDef" may be impacted by the collation
upgrade. Run DBCC CHECKTABLE.
Warning: The index "AgreeHist_idx1" on
"dbo"."AgreeHist" may be impacted by the collation upgrade.
Run DBCC CHECKTABLE.
....
....
Database 'MYDB' running the upgrade step from version 551 to version 552.
Database 'MYDB' running the upgrade step from version 552 to version 553.
Database 'MYDB' running the upgrade step from version 553 to version 554.
Database 'MYDB' running the upgrade step from version 554 to version 589.
Database 'MYDB' running the upgrade step from version 589 to version 590.
Database 'MYDB' running the upgrade step from version 590 to version 593.
Database 'MYDB' running the upgrade step from version 593 to version 597.
Database 'MYDB' running the upgrade step from version 597 to version 604.
Database 'MYDB' running the upgrade step from version 604 to version 605.
Database 'MYDB' running the upgrade step from version 605 to version 606.
Database 'MYDB' running the upgrade step from version 606 to version 607.
Database 'MYDB' running the upgrade step from version 607 to version 608.
Database 'MYDB' running the upgrade step from version 608 to version 609.
Database 'MYDB' running the upgrade step from version 609 to version 610.
Database 'MYDB' running the upgrade step from version 610 to version 611.

RESTORE DATABASE successfully processed 345 pages in 0.420 seconds
(6.712 MB/sec).

What is the severity of this warnings? Is there a way to make them disappear?
Thanks in Advance.

Adnan

View 1 Replies View Related

Backup Script FOR SQL Express

Jan 5, 2008

I need to write a backup script to backup a database. I used the following one for MSDE.

osql -E -S asuskwmsde2 -i c:hw.sql

I wrote it so long ago I have no idea what it means.

Thanks.

View 9 Replies View Related

Restoring A Sql Express Backup To Sql 2005

Jun 2, 2008

i'm trying to set up one of the asp.net website starter kits and part of the process is to backup the sql express db and then import it into the sql 2005 at the web hosting account. it's not working and i'm wondering if there's any difference between the backups they make. the sql express makes a file with a .bak extension and the sql 2005 at the host makes a file with a .sqlbak extension. i was assuming that was just a naming thing and not a structural thing but the host's tech support has said:
"This sort of thing happens when the database being imported is not properly formatted. You can try downloading and using sql express from microsoft to see if you can do it manually, but most likely you will need to save your database again properly set for import to an mssql server rather than however you did."
all i had done was rename the .bak file from express to .sqlbak as that was the choice for backup files.
i will note that it also failed importing the .mdf, which works fine locally with the site but i did make some changes to it from the original that came with the starter kit.
should a backup file made with sql express (using sql management studio express, by right clicking on the file and choosing tasks > backup) normally be importable by sql 2005?
or, i suppose, does it make sense that a db that works fine locally with sql express (within a visual web developer express project anyway) would actually be "formatted" in a way that would cause it to fail to import into sql 2005?
thanks much for any assistance.

View 3 Replies View Related

How To Automate A Backup On SQL2005 Express

Nov 8, 2005

I am currently using MSDE as the Db for a website and using (cheating?)
enterprise manager i have created and scheduled a backup job that the
agent runs.

Now I am wanting to upgrade the Database to SQL2005 Express but I want
to have a similar scheduled backup job. From the reading of the
OLBs it appears I have to manually create a script but I don't know how
to schedule the running of the script.

So my questions are:
1. How do you schedule the running of a back up script in SQL Express? and,

2. Is there a tool that automates the creation of a script similar to how you do it in the old Enterprise manager?

TIA
Antony

View 5 Replies View Related

Server Express - Automatic Backup

Feb 21, 2013

I have SQL Server 2008 R2 Express Edition on a server.I need to backup my database (small db) on a daily basis.Since Express Edition does not allow automatic backups what can I use to do this backup?

View 9 Replies View Related