View Complete Post
I am getting very desparate at this point. I've been out of business for 5 days now, with no end in sight.
My Master database, in my Maximizer instance is missing. I have posted the issue under
http://social.technet.microsoft.com/Forums/en-US/sqldatabaseengine/thread/e60b7c6a-c6d0-47c9-9a36-c15a12366db1 and Amit Banerjee has been helping out. Unfortunately, I can't get the Master database in my SQL Server Express 2005 to be rebuilt.
I have a copy of the MSSQL.1 folder on the desktop, along with a backup of the database in my backup files.
I've tried to run the script from a command prompt:
start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>
Where <InstanceName> is MAXIMIZER, the name of the database I'm trying to rebuild. I also tried replacing the <CD or DVD Drive>\setup with E:\setup, and I get the error message that Windows cannot find 'E:\setup'
I've tried running the command prompt from User\>, C:\>, and E:\>. For some reason, the setup.exe command won't run. I've also tried running it at an E:\prompt, without the E:\ in the script, a
I am trying to restore a SQL Server 2005 database backup file.The size of the database backup is 5.51 GB.ÃÂ I specify theÃÂ ÃÂ source as a device and then provide the path of the .bak file and press OK i get the error as follows
TITLE: Microsoft SQL Server Management Studio------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The media family on device 'G:\ITWeb DB Bkup\DB Bkup\New Bkup\WSS_Content_ITWEB.bak' is incorrectly formed. SQL Server cannot process this media family.RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476
Hy guys. I try to connect my database for so long so i wrote two type of codes. Let's discuse first on.
I have database called PhoneDirectory.
It have only one table named Residents.
I have button wiht ID="Button1".
I want when i click this button to see all of my residents.
I want to see the result in DetailsView and to be able to edin, delete and add new resident.
First try with SqlDataSource so i wrote this:
I am using VS 2010 Professional with SQL Server 2008 Developer. I right click on the App_Data folder in solution explorer and add an existing item, then navigate to the correct database. However, I receive a pop up that Access is Denied. How do I fix this?
I am using visual studio 2005 and sql server 2005.
I am developing a small quiz application and i have stored the connection string in app.config file which is given below.:
<?xml version="1.0" encoding="utf-8" ?>
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Quiz Application.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
i have retrieved connection string property through configurationmanager class
and when i m connecting to database it gives me a runtime error:
Sql Exception was unhandled
System.Data.SqlClient.SqlException was unhandled Message="An attempt to attach an auto-named database for file F:\\Quiz\\Quiz\\bin\\Debug\\Quiz Application.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located