DataSource Controls :: Restore Database From Shared File?
Jun 17, 2010
I need to restore the database daily. I have a BAK file in shared folder. I have to restore it from my machine. I have used the below script to restore the database but I am unable to restore it. Its throwing error. I have shown the script and error what I got when I execute my Store procedure.
how can I achieve this using the SQLdatasource control? I'm using the VB language. What controls/commands should I use to have a backup and restore function on my website?
I have an SQL 2008 R2 database on an X86 machine that I have backed up a database from. Now I want to restore it to an SQL 2008 R2 instance on an X64 machine and keep gettting format errors (attributed to restoring a higher version of database to a lower database instance ie 2005 to 2008). On inspecting the databases I find the X86 is version 10 and the X64 is version 9 (which is supposed to be the 2005 database)...are there different versions of the same DB for different software platforms?
1. i have created aa database named "qraghul" which contains two tables. i want this database to backup from my system and restore it to the host server or any other system. how i can do it.
2. suppoose if i backup and restore it to any system or server. whether i have to change the connection string in my application eg Data Source=QUANO-462F6EB27;Initial Catalog=qraghul;Integrated Security=True bcoz my server name is QUANO-462F6EB27 whether i restore it to any system. i need to change the server name?
In our project we need to restore the analysis service database back up(.abf) files.Now i can connect to analysis service and can create new database.May i know how i can restore the abf file .i saw i can do this by using sql server SMO dll .check the below link
[URl]
how to get the samples are located in <system_drive>:Program FilesMicrosoft SQL Server100Samples folder,if you alrady installed the documentation
i am trying to restore database.bak in sql server 2005 (i know the database.bak was also generated in sql 2005 server)
i am trying to restore back up database .bak into the new database i just created in sql server 2005i have saved my database .bak into c drive and when i select database .bak "From Device", it doesn't get populated in the list below and i see nothing and it keeps on prompting a message"You must select a restore source"
Here's the screen shot: (i tried restoring database in sql server 2008 and it was sucessful but i am facing this problem in sql server 2005 only)
i m using these command for backup and restore sql database
BACKUP DATABASE [db_report] TO DISK =N'db_report.bak' WITH NOFORMAT, NOINIT, NAME = N'Report-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 RESTORE DATABASE [db_report] FROM DISK = N'db_report.bak' WITH FILE = 1, MOVE N'db_report' TO N'C:db_report.mdf', MOVE N'db_report' TO N'C:db_report.ldf', NOUNLOAD, STATS = 10
but i want to set backup drive name with today date and time yani my i will set drive D:db_report010320100910am if u will see theres is db_reportMonth(01) Day(03) Year(2010) Time(09:10am) and when i want to restore then ask me which one u want to get restore
my SEL Server name is changed. I have a backup file. Now I want to take the data in the older file. So how can I restore the old data in the new SQL server which name is changed?
I want to restore .bak files from a server directory into database. The problem is it should behave automatically. Whenever a .bak file will be uploaded in that specified directory of the server that file will be restored. It may happen by using sql procedure which will restore all the .bak file which it will find at a certain time in that specified directory. Or, it may happen by using asp.net program which will run exclusively on server and call a sql procedure to restore a backup file whenever a backup file will come in that specified directory. But I am not getting how to figure out this ideas programetically.
restore a master database from production to test server.
The reason to do this because I need to test and evaluate some login in master database.
I tried to restore master database to test server, but I got some errors regarding about user databases are not exists in test server. I don't want to restore user databases, I only need master database for evaluate user login.
Whenever we have an issue in production, we restore DB backup from our nightly sql backup files in our testing environment. This way we get all data from production.
New Requirement:
Instead of restoring the db which takes upto 2 days, they want to do only selective restore based on few parameters. Requirement is to a build a new ASP.NET page in our application with few inputs. On submit button click, I should select data from prod and insert into testing environment. This involves opening new sql connection.
My hosting company provider MS SQL Express as part of my hosting package, they have provided me with both the name and IP address of the server running MS SQL Express.
I have created a database on this server via management studio and when I create a connection string like this (connectionString="Data Source=ServerName/IP;Persist Security Info=True;User ID=xxx;Password=xxx") my application works fine.
But if I create a local database file and try to attach this with a connection string like this (connectionString="Data SourceServerName/IP; AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance = True ; Trusted_Connection=Yes) my application doesn't work.
Therefore my questions are:-
Is there something wrong with my connection string? Can you use a local database file within a production environment?
Is it better to store images directly in a database or to just store the name of the file in the db and display that file? I would think that just storing the filename of the image would keep the db size low...