I need to make a back up file(.bak) from my database (.mdf)
I learned that i need to use Ms SQL Server management studio express. I can't figure out how to connect to the database. looks like I need to select a server type, but nothing comes up for me to select. The databse was made using visual developer 2008 ms sql server, so i thought something like "SQl Server 2005 or 2008" comes up, but it didn't.
I need to make a backup file(.bak) of a database(.mdf)
I learned I need to use MS SQL Server management studio Express to do so, but I can't figure it out how.
I don't know how to connect to the database using this program. In the "Connect to Server" dialogue window, I am supposed to choose a server name from the dropdown list, but nothing comes up. What am i doing wrong?
I have a major problem. I have windows 2003 serverm in it I have installed sqlserver and on it several databases that was published for months. Now, the windows 2003 server crashed and I cannot login ti windows anymore. What I have done is to create a new installation of windows and installed again the sqlserver...
Now, how do I get back the latest database from the previous corupted installation? I still have access to the files in the previous installation.
I'm a little frustrated here. I have turned the default database offline then used windows explorer to copy the database to another location but when I tried to take the database online again this error came out:
Cannot open user default database. Login failed. Login failed for user 'Zephere-pcephere(JuLian Yong)'. (Microsoft SQL Server, Error: 4064) The cause is that the default database is set offline, How do I bring it back online agian?
how to change DB type of int back to value 1 after deleting.
I mean if you got some data in sql database and table looks like
SomethingID DB type int
Something DB type nvarchar(150)
If youve got 10 records then youve got 10 IDs when you delete those 10 records and then make new one SomethingID is ID 11 not 1
I have a web application which a group of people have been using for some time and it relies on a DAL
in which there a numerous relationships and links to a SQK2K8 database SPROCS.
The SQL db has a group of unrelated tables adn only primary keys.
A DBA wants to add the relations at the database level and create several secondary keys on some of the tables.
I am trying to think how this will affect my current app ?
Will I still be able to use my DAL as is ?
Or will this call for a rewrite of all the methods for each data table ?
This was not a consideration when the application was created because we didn't think that we would be using it long term.
I have a cascading dropdown. After the dropdown is populated(it is in another file) i would like to return back to the original form where the control is placed. is there anyway of doing it
View 4 RepliesI m trying to save files like pdf, word, excel etc... into sql express, but m getting this error in my web page:An attempt to attach an auto-named database for file C:Usersmalek.safaDocuments est vbSavingFileInDBSavingFileInDBApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
m not getting errors inside my code, just this one appearing on the web page.
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 am trying to import the SQL file provided by Elmah into my application, and I don't want to import it into the development machine I use. I want to make it a .mdf file so it can be easily transported to my host. I was wondering if there is a way to do this?
View 7 RepliesHow do I upload a file on the web server and save the link of the file in a database?
View 3 Repliesam importing a text file database in my sql server database in asp.net c#.but i cannot fetch the column name from .txt file which contains a numeric data now what to do?
View 1 Replies[Code]....
i want to get data from database of field Name and Gender, and then display it in Label name and gender. when i click save it move to next record and display name and gender that next record.
I have created database .sql file for create schema with export database. (its .sql file size is 48.2 MB)
View 1 RepliesI want to make spider charts like this one: [URL] I want to know can I prepare it using reporting service 2008? I am using sql server 2008 as the database and working with Visual studio 2008.
View 4 RepliesI need to incorporate some basic database functionality with no real need for speed.
View 3 RepliesI want to make a textbox with a specific style, within this style a set of images as background parts, how can i attach these images to the custom control as whenever i take the .dll file and add it to the toolbar the images do not appear. So i tried to make them as resource files and their property as embedded in .resx file, so how to make the css style background image url to be linked to any of those image.
View 1 RepliesMy client gave me .DAT database file. But I am not know how to use it or how to attach it to the sql server.
View 3 RepliesI'd like to know how to allow user to upload file to the server in mvc 2 application. I haven't seen a very clear tutorial for this, at least not on this website. There is a movie database tutorial but that is simply a list of movies not actual files. What is the simplest method for uploading files, be they images or movies?
View 13 Repliesi saved files into database. when i'm displaying i wrote code like this
Dim mySqlDataReader As System.Data.SqlClient.SqlDataReader
Dim mySqlCommand As New System.Data.SqlClient.SqlCommand("pl_Resumes", mySqlConnection)
mySqlCommand.CommandType = CommandType.StoredProcedure
[code]...
i have an csv file, using Logparser im reading the data and add into the table, now if the csv file has 100 records then im hitting the DB 100 times, how can i push all the records to the DB at one time so, that i can improve the performance.
View 9 RepliesI have a .bak database file and i want to restore it to a new database so that i can get the data inside the .bak file
I am using SSMS 2008 Express
what i did :
I created a database with the same name as of my .bak file (in my case "RM")
now after creating a new database > righclick on database > tasks > restore
Selected FROM : RM ( empty database that i just created)
Selected TO : RM.bak (my backup file)
when i press "Ok"
i get this error:
I am newbie in SQL Server 2008 R2. I able to created table within it but how do I get the database file. Can I specify the path where the database is create?
View 1 RepliesBeing new to ASP.NET I have run into trouble building my own Whack-a-mole program. I think my problem comes from using Buttons, which by themselves send post backs to the server, making the software unusable. The looks are in place, making new buttons show up in the grid, in different places by random. However, when a button is pushed - the score doesn't change (which I feel is strange).
Not so strange is that the Button doesn't work since it sends post back to the server - reloading the UpdatePanel. I think I should use a different controller like the CheckBox and style it hard using CSS (which isn't a problem). Is this the correct way to go, or should I make use of JavaScript AJAX instead?
Note to self: This technique shouldn't be used in a public application since it put too much unwanted pressure on the web server.
[code]...
I urgently need to find a way of reading data from a .CSV or .xls(Excel) file into an sql database so that I can use it in my asp.net 2.0 application.
View 4 Replies