DataSource Controls :: LDF File Increasing When Move From SQL Server 2000 To SQL Server 2008

Apr 2, 2010

I have 5 GB data, when I move from SQL server 2000 to 2008 with Import and Export wizard, my LDF size is increased to 30 GB, Can I reduce my LDF file or move. In my one of the table contain around 20 Lakh data which i have normalized in 2008 and create 4 tables, so my data is entering in normalized form in 2008. But due to size by hard disk is full. I have used shrnik command but it reduce to only 1 GB.

View 5 Replies


Similar Messages:

DataSource Controls :: Move MS SQL Server 2000 To 2008?

Mar 11, 2010

What is the best way to move SQL 2000 to 2008 completely? Please let me know if real life problem generally occurs.

View 4 Replies

DataSource Controls :: SQL Server - What Is Difference Between SQL Server 2000 - 2005 And 2008

Mar 24, 2010

Does anyone know, what is difference between SQL Server 2000, 2005 and 2008?

View 3 Replies

SQL Server :: Reading Text File Using Sql Server 2000 - 2008

Sep 22, 2010

how to read the data's in the text file using sql server 2000 and 2008. i have a text file in a server and it contains one column name with the multiple column values i need to read that informations and i need to update in a table in the database.

View 2 Replies

DataSource Controls :: Import A Table From Sql Server 2000 To Another Server Qsl Server 2005?

Feb 9, 2010

I have to programmatically import a table from a database "A" in Sql Server 2000 to a database "B" in another server 2005.

View 1 Replies

DataSource Controls :: How To Convert The Sql Server 2005 File To Sql Server 2008 File

May 24, 2010

I have a problem, I have created a website that is run on local host database is make in 2005 sql server

now i am using sql 2008 and visual studio 2010 , I attach the sql 2005 mdf file in sql 2008 server and run it working correctly when we host it then it is not working

problem gives "NT NETWORK SERVICE FAILED "

how we can convert the sql 2005 mdf file to sql 2008 file.

View 2 Replies

DataSource Controls :: Convert DTS Package From SQL Server 2000 To SQL Server 2005?

Jul 1, 2010

How can convert DTS package from SQL Server 2000 to SQL Server 2005

View 2 Replies

DataSource Controls :: Difference Between Sql Server 2000 Sql Server 2005?

May 27, 2010

wt is the difference b/w sql server 2000 sql server 2005

View 4 Replies

SQL Server :: What Are Features Included / Comparision Between Sql Server 2000 - 2005 And 2008

Oct 18, 2010

Could anyone tell me the features comparision between sql server 2000, 2005 and 2008 in the table format like below. sql server 2000 features | Extra features added/supported in 2005 | Extra features supported in 2008

View 2 Replies

How To Move Stored Procedure From SQL Server 2000 To 2005, Multiple Table Insert

Jul 21, 2010

moving some tables & stored procedures from SQL Server 2000, to SQL Server 2005.So far so good, but I've come across a problem with this stored procedure:

CREATE PROCEDURE [dbo].[user_insert]
@user_service_unit int,
@user_champion_1 varchar(50),
@user_champion_1_nt varchar(10),
@user_champion_2 varchar(50),
@user_champion_2_nt varchar(10),
@user_champion_3 varchar(50),
@user_champion_3_nt varchar(10),
@user_date_received datetime,
@user_requestor varchar(255),
@user_info_requested text,
@user_expiry_date datetime,
@user_10_days datetime,
@user_5_days datetime,
@user_2_days datetime
[code]...

View 3 Replies

DataSource Controls :: Best Way To Move ASPNETDB.MDF From SQLExpress 2000 To 2005?

Mar 28, 2011

What is the best way to move my ASPNETDB.MDF from SQLExpress 2000 to SQLExpress 20005 on anothere server

View 2 Replies

SQL Server :: Data Migrations From Sql Server 2000 To 2008?

Sep 1, 2010

some good links / tutorials for migrating data from sql server 2000 to 2008 using SSIS

View 3 Replies

DataSource Controls :: Sql Server 2000 Using Packages?

May 6, 2010

Using sql server 2000,How to create the dts packages that runs the stored procedure to output the results in excel sheet?

View 3 Replies

DataSource Controls :: SQL Query Optimation For SQL Server 2000?

Jun 28, 2010

SQL query optimation for SQL Server 2000?

[Code]....

View 3 Replies

DataSource Controls :: SQL Server 2000 - Event Log Error Id - 318

Jan 7, 2010

Unable to read local eventlog (reason: The data area passed to a system call is too small). This error is recorded in the event log every minute in the production server, and because of this the SQL Server 2000 performance is very slow and the box is also working slow. This indirectly affects my application and productivity.

View 2 Replies

DataSource Controls :: Database Synchronisation Between MS Sql Server 2000 And Mysql?

Mar 27, 2010

I want to synchronise two databases from two different platforms i.e. MS Sql Server 2000 and MySql. I have two applications one is desktop application which uses Mysql and other is Web application which uses MSSql. When any changes made to MySql from Desktop application, then that changes should get reflected to MS Sql database and vice versa. I am novice for this kind of situation.

View 4 Replies

DataSource Controls :: Find And Replace Within Field, Sql Server 2000?

Jun 30, 2010

I have a table called 'products'. In each table there is a column named 'description' of type ntext (sql server 2000). The description conains a ton of text and within that text there is an ip address many times. I need to replace every instance of the ip address with the actual domain name, 123.45.678.990 with http://domain.com.

View 5 Replies

DataSource Controls :: Uploading .doc / Docx File To Microsoft SQL Server 2008?

Feb 18, 2010

For my web application I need to allow the user to upload a word document to the database. I've searched the forums and I've only been able to find with uploading to a server. Can anyone one give me a link to a tutorial or step by step guide on how to do it? I'm not even sure what data type to set the attribute to in the database.

View 4 Replies

DataSource Controls :: Enable - Disable Indexes On Table In Sql Server 2000?

Mar 25, 2010

I want to know whether an index is disabled in SQL Server 2000. In SQL Server 2005 we can do this by querying sys.indexes. Is there a way to find disabled indexes in SQL Server 2000?

View 1 Replies

DataSource Controls :: Transfer Database From Sql Server 2008 To Sql Server 2008

Jun 29, 2010

how can i transfer complete database from sql server 2008 to sql server 2008 without loosing relationship intigrity.

View 9 Replies

SQL Server :: 2000 To 2008 R2 Express For DNN Update

Jan 8, 2011

I an trying to update DNN fron 4.7 to 5.6 and am running into unresolved issues. Here is what I am trying to do in an isolated development environment: (original instalation is runing on 2000) Restore sql 2000 backup to latest sql express. Try a fresh complete install of 5.6

I am getting an error while attempting to restore the backup made on 2000 -to- 2008: TITLE: Microsoft SQL Server Management Studio
------------------------------
Specified cast is not valid. (SqlManagerUI)
------------------------------
BUTTONS:
OK
------------------------------

View 2 Replies

Migrate Application Running In Windows 2000 Server To Windows Server 2008?

Mar 10, 2010

Currently we are running an application build in VB6,ASP,Commerce Server2000 and Sql Server 2000. This application is running in Windows 2000 server.Now we are planning to migrate Windows server 2000 to Windows 2008.Will this application run in Windows 2008 or do we need to upgrade this application to dotnet and Sql 2008?

View 1 Replies

DataSource Controls :: Algorithm For Simple Encryption And Decryption Of Field In Sql Server 2000?

Jan 2, 2010

I have to Encrypt and Decrypt Back the Password field in sql server i have used the pwdencrypt and pwdCompare() but i dont have to compare but i have to display the password back using the Decrypt technique Is there any algorithm which i can use only for encryption and decryption of password field?

View 4 Replies

SQL Reporting :: Error Upgrading From Server 2000 - 2008 R2 Services

Oct 6, 2010

I am having some trouble upgrading an existing SQL Server 2000 Reporting Services installation from an old server to a new one commissioned for this purpose, which is running SQL Server 2008 Reporting Services. I have been following the instructions here: [URL] but after trying to connect with reporting services 2008, i get this error: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.6.54'. The expected version is '147'. (rsInvalidReportServerDatabase) before starting the process, I ran upgrade advisor and got back the following results:

Description Setup can upgrade a SQL Server 2000 Reporting Services instance that uses a SQL Server 2000 Database Engine in the same instance. However, upgrade is blocked if the report server database is in a different instance, on a remote instance, or runs on a remote SQL Server 2005 instance in SQL Server 2000 compatibility mode.

*****
*note, our reporting services IS in the same instance as the SQL Server 2000 database engine. However, upgrade advisor still reported that this instance can not be automatically upgraded.
*****

Corrective Action Choose either approach to continue with the upgrade: Upgrade the Database Engine instance on the remote computer before upgrading Reporting Services. The server cannot be in SQL Server 2000 compatibility mode after upgrade. Move the reportserver and reportservertempdb to a SQL Server 2005 or SQL Server 2008 Database Engine instance, and then use the Reporting Services Configuration tool to connect the report server to the database.

so, I went with option 2, move the database then connect. I have: -backed up the ReportServer and ReportServerTempDB databases from the old server, transferred them to the new and restored them to the 2008 Server as ReportServerOld. -I then renamed the old database to ReportServer and ReportServerTempDB, as this is required to use the database as a source apparently. I had to of course change the existing database names to ReportServerNew to perform the rename. I backed up the symetric key for this installation using the rskeymgmt utility...............

View 2 Replies

DataSource Controls :: Implementing A BLL / Contacts Table, The Select Method Is A Sql Query Against A Sql Server 2000 Database?

Feb 17, 2010

I'm implementing a BLL layer and have a few questions. First, in my DAL, there is a contacts table, the select method is a sql query against a sql server 2000 database. The preview data returns everyting as expected. The query is

[Code]....

The BLL method is built like so

[Code]....

When using the BLL method to a gridview, the results of the subquery are not displayed. There are also other methods, each having a different where clause for ContactRole_ID and each is having the same issue of not displaying the subquery reult in the gridview. No error, but no data is displayed for the subquery either. Here is the templatefield of the gridview

[Code]....

Another item that is causing an error is in trying to update a record. Here is the DAL update method

[Code]....

And the BLL update method

[Code]....

The error says i have extra parameters, but have no clue where the extra parameters are being picked up. The error isObjectDataSource 'odsContacts' could not find a non-generic method 'UpdateContact' that has parameters: _ContactID, _Active, _ContactName, _Office, _VirtualOffice, _Pager, _Fax, _Home, _Cellular, _Email, _ContactRole_ID, Active, ContactRole_ID, ContactName, Office, Email, VirtualOffice, Pager, FAX, Home, Cellular.And the objectdatasource

[Code]....

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved