I got a .bak file from my friend
I want to restore the data base in my system(presently I don’t have any database in my system).
But while I try to restore it
I am getting an error
“
System.Data.SqlClient.SqlError: Directory lookup for the file "D:Microsoft SQL Server 2005mydatabase.mdf" failed with the operating system error 2(The system cannot find the file specified.). (Microsoft.SqlServer.Smo)
�
I have installed Microsoft sql server in a different directory not in D:
where he is installed
I can successfully restore the back up files of data base on my own system
But not the backup files created from others systems
Hello!! searching information about how to migrate some date from an old data base (any tipe) from SQL I´v found this: LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char' ] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] [IGNORE number LINES] [(col_name_or_user_var,...)] [SET col_name = expr,...)] Does anybody know how does it works and how to use it????I´d like to know because I have to load data from a text file to a SQL Data Base and this seems to be te fastest an easiest way to do it...Thanks!!!!bye!
I am pretty mcuh new to sql and I read all your previous replies..I jsut have my questions answered.If you can help me that would be great!
I can acces the date base using Server manager then retireve the data using the query .But now I need to convert that obtained the data into csv file n then save it into csv file. IF you can help me out that would be great.
I am working on a application in which,at once i have to make a huge amount of data to insert and delete in my data base.At this time of some transaction my data base log file,shows data base error like the log file of this data base has been full.plese see the sys.databsesd view...like..
Please help me.If you need the exception then i will send you later.
Hi all,I have installed sql server express edition and using this with asp.net website application. It was working fine,I am using .mdf file as database in app_code folder of asp.net website application, but now there is one issue which is with a particular table records.In this table some of the columns has got the same value for all records in the table. so, now i want my previous(original) data as backup, but unable to do so. I am using third party tools for recovery. Can anyone please guide me to resolve this issue.Thanks in advance
I'm using SQL Server 2000 and need to restore a large database onto a different node. The problem is the original database has a 74 gb first datafile and the node where I need to restore it doesn't have a single drive that big. I'm trying to use a backup of the original database and restore it into an existing database on another node and am using the move options to put the files in the right places.
Is there a way I run the restore to split the 74 gb datafile across drives on my target node?
himy self avicurrently i am developing one application in vb 6 and back end assqlserver 7 which is used on lan.i have some problem. like in my database i have one table salesvoucherwhich has 'voucherno' field. when 2-3 user will work on salesform at atime [since the softwrae will run on lan] then the same voucherno willsave for all users data which is wrong i need to save different vouchernofor each no. is there any way in sqlserver to apply some condition ondatabase or to set some its property[tables] so that at a time only oneusers data will save depend on firstcome first serve base or is there anyway to make changes in programme.plz help me regarding this i need it very badly.since its my first lan based software plz give me some books nameregarding this software for vb6 and sqlserver7
I have an excel sheet that contain colummns as in a table in a sql database i want to transfer this data from the sheet to the table frombusiness logic code layer not from the enterprise manager by wizardwhat can i do?? ...please urgent
I am Crystal Reports Developer and I am new in SSIS environment. I have started to read Professional SQL Server 2005 IS book. I am really confused by many tasks to choose.
I need to develop reports from data warehouse. But before I have to send the data from operational database (SQL Server 2000) to warehouse (SQL Server 2005) monthly - I have a script for retrieving the data. For my package, I chose Data Flow Task, Execute SQL Task, and OLE DB Destination, and it does not work.
Please help me if I can look similar packages performing? Thank you!!
i am really in need of help. i have a text file consiting of some data.i want to update my database from that text file periodically say 12 hours.the text file is being updated by another server program in every 12 hours can any one help me in this case? i am lost for this scenario?? help me please.....
I am using ASPOSE License(3rd party licensing tool).
Getting Error when using encrypted License file (*.lic) in my Application .
Error is .
"Invalid character in a Base-64 string "
What does it means ?????
But Demo License file *.lic is working fine.
Please provide solutions.
Reply is highly appreciated.
Rishi
Error is Invalid character in a Base-64 string.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.FormatException: Invalid character in a Base-64 string.
Source Error:
Line 59: Line 60: //license = new Licensing("Ghezt4vbwif7r9cf7ra2ttbKzv76+v7GAA==", licenceFile); Line 61: license = new Licensing("Ghezt4vbwif7r9cf7ra2ttbKzv76+v==", licenceFile); Line 62: Line 63: Source File: c:Documents and SettingsAdministratorMy DocumentsVisual Studio 2005WebSitesTestLicenseApp_CodeDemo.cs Line: 61
Stack Trace:
[FormatException: Invalid character in a Base-64 string.] System.Convert.FromBase64String(String s) +0 Aspose.License.Licensing.M0(String key, String encryptedString) +627 Aspose.License.Licensing.A0() +753 Aspose.License.Licensing..ctor(String key, String licenseFile) +72 Demo.Initialize() in c:Documents and SettingsAdministratorMy DocumentsVisual Studio 2005WebSitesTestLicenseApp_CodeDemo.cs:61 Demo..ctor(String licenseFolder, Page page) in c:Documents and SettingsAdministratorMy DocumentsVisual Studio 2005WebSitesTestLicenseApp_CodeDemo.cs:37 _Default.Page_Load(Object sender, EventArgs e) in c:Documents and SettingsAdministratorMy DocumentsVisual Studio 2005WebSitesTestLicenseDefault.aspx.cs:18 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +31 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +68 System.Web.UI.Control.OnLoad(EventArgs e) +88 System.Web.UI.Control.LoadRecursive() +74 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3035
I am using MS visual web developer and i get a lot of things but one thing i do not get is why is it when i set up the web.config to a data base i made on my own and run the website and create an account it creates a new data base and creates that new account in that new database, i've never opened the web admin tools. <connectionString> <add name="LoginConnection" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename="C:Visual Studio 2005WebSitesWebSite1App_DataYourEstate.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings>
I need someone to give me a small briefieng on how a enterprise data warehouse (EDW)differs from a regular database? Currently we have an appplication that accesses a database with about 18 tables. We also have a Data Warehouse. For some reason I was thinking that it would be possibly to migrate thedatabase into the data warehouse. The reason is that in looking at the schematic design forthe data warehouse there are some data tables that could also be used by our application that uses the DB. I guess I am confused because I am not sure if a data warehouse is used in the same wayas a database?
I make my login account data base using the Web Site Administration Tool in the solution explorer i then debug it on my computer and it works fine i can login then i upload my site and sql data base to server and it no longer works i just get this message what do i do can i change the Web Site Administration Tool so that it uses a access data base by default for login instead of sql.Server Error in '/KRAZYJON' Application.
Failed to generate a user instance of SQL Server due to afailure in starting the process for the user instance. The connection will be closed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
SQLExpress database file auto-creation error:The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database: If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist. If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database. Sql Server Express must be installed on the machine. The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735043 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +68[HttpException (0x80004005): Unable to connect to SQL Server database.] System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +124 System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install) +86 System.Web.Management.SqlServices.Install(String database, String dbFileName, String connectionString) +25 System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString) +397
Hello friends, i would like to create an e-commerce website,for selling music,video,games and books, i also want to extend its functionality to electronic products also. the problem is ,music,books,videos and electronic goods will have different properties like author,music director,company,ISBN number,..etc,i am very confused about data base design,want to add sub categories also like light music,classical,history books,technical books etc...can anyone give suggestions?
I have a problem with my data base. when i run my project (ASP.NET) in Vs 2005 my data base work. but i run in localhost isn´t work. my data base as a .mdf(sql server) Can help-me ???
hello any one could tell me about database administrator. i want to connect oracle management server for import database of sql server 2000, i new the its user : sysman and also its password. it is connected first time and i change its password now i am trying to connect it but a msg is prompt
"VTK-1000 : Unable to connect to the management server (server name). please verify that you have entered the correct host name and the status of the oracle management server"
plz tell me as soon as possible...... i will be thanks for all....
We have a client with our data base, but this database is undergoing constant changes since the development has not been finished, for that reason whenever we made an update we must synchronize the data base. I wondering if exists a tool in which setup can be created and updates the data base in SQL.
I want to transfer (Export or Import) my Database TEST1 to TEST2. To do so I execute the following steps : - Create an empty Database TEST2 - Create A login TEST2USR which will be the owner of the objests in TEST2
But the owner of the User Objects in TEST1 is TEST1USR How can i transfer my objects using (Import/Export Utility) from TEST1 to TEST2 changing the owner (From TEST1USR to TEST2USR).
Sebastian Garibaldi writes "Hi I'm Sebastian from Argentina, and i have a problem with a SQL data base. I receive error from data base of broken index and consistency errors. I set the fill factor with the information from the books online, i put 70 in tables that have a lot of INSERT/UPDATE/DELETE but it works for two o tree days.
I now that i must make some maintain in the database but which tools i shuld use?
here i paste an error from dbcc checktable:
Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 981108969. The text, ntext, or image node at page (1:949979), slot 52, text ID 57535781339136 is not referenced. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 981108969. The text, ntext, or image node at page (1:949979), slot 53, text ID 57535782191104 is not referenced. DBCC results for 'FCRMVI'. There are 108460 rows in 17430 pages for object 'FCRMVI'. CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'FCRMVI' (object ID 981108969). repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (ArleiProd.dbo.FCRMVI ).
Hi,I am looking to check and set the encoding of the database using sqlcommands that work both for SQL-Server and JET.something equivalent to the postgreSQL commands:'SHOW server_encoding'Thanks in advance,Maarten
Once we create reports on one machine, can we move those reports to another machine and work or modify from there? Right Now I created bunch of reports based on the data base which is in my local machine. But now How can I connect those reports to data base in prodcution server? It is not accesible right now because of the security purpose. Is there any other alternatve way to do that? And other option is moving ReportserverDB and TemperoryDB to production server environment. How can we do that? My supervisors dont like juct backing up and resotring option.
We have 2 SQL Server 2k5 servers running the same build - 9.0.2047 . When I backup any database from one server and attempt to restore it to the other, the log file generally increases by 100 fold. It errors out after I try to restore a 100MB db and it tries to create a 9.8GB log file. This happens both when I use the GUI to restore and when I restore from a T-SQL script. What am I doing wrong?
we have Sql Server 2000 and Sql Server 2005 IN A SINGLE MACHINE. when connecting with data base Sql Server 2000 with asp.net 2.0 application ,an error occur "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." can anyone suggest any idea to solve this problem... thanking u.
hi, I am not sure whether this is the place for this post. I am developing a Vb.net search functionality which is accessing data from the SQL SERVER sharepoint portal database. I have troubles in connecting to the particular server and retrieving each table from the database.I have succes in importing tables into Access. I want to query the portal sql database itself and need to provide a connection string which will made the access easier. Any suggestion or help to do would be much apprecited. thanks in Advance. Barti
