Upgrade Database From Beta To SQL2005??
Jan 4, 2006Ok is this possible??
I tried to import data thinking it should just work - ha ha! Threw lots of errors about table and column mapping instead.
Hodgehegs
ADVERTISEMENT
SQL 2000 Beta Upgrade
Jul 6, 2000Do I have to upgrade to 7.0 before installing the beta SQL 2000 or can I go straight from 6.5?
View 1 Replies View RelatedSQL Server Express Upgrade From Beta 2 To RTM
Nov 10, 2005I plan to upgrade from SQL Server Express Beta 2 to RTM. Since this requires and uninstall and re-install process (not just upgrade), what are the steps I need to take to backup my database in Express Beta 2 and then import it into the new RTM version? I have scripts to recreate the tables and stored procedures, but how do I get the data migrated?Thanks in advance. Cheers, Kris.
View 1 Replies View RelatedUpgrade From Beta-3 To The Release Version
Feb 16, 1999Hi All,
I am doing an upgrade of SQL Server from Beta 3 release to the release version. I will appreciate if I get some information , some tips that I should follow which will make my task simpler. The database is very critical and big. It has huge amounts of stored procedures.
If you can tell me any site which gives information regarding this that will be also helpful..
Thanks
Ajay
Upgrade SQL Server Beta 2 To Release
Nov 9, 2005Hello,
View 1 Replies View RelatedUpgrade SQl 2005 Beta {9.00.0852} To {9.00.1399.06}
Jun 13, 2006Hi,
What are the step to upgrade
SQl 2005 Beta version {9.00.0852} to SQl 2005 ver {9.00.1399.06}
also let me know where I can download .it
Thanks in advance
MS Sql 2005 Beta 3 Installation Errors..Can This Version Coexist With VS2005 Beta 2
Apr 27, 2005When i tried to install the beta 3 above I encounter the following problems ;-
TITLE: Microsoft SQL Server 2005 Beta 3 Setup----------------------------------------
Setup configuration check cannot be executed due to WMI configuration on the computer D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnetwcls.mof. For details, see the Sqlrunxx.log file or call Microsoft Product Support.
A seach in the net has the followings help link
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&ProdVer=9.00.852&EvtSrc=setup.rll&EvtID=29535&EvtType=sqlca%5Csqlmofca.cpp@Do_sqlMofcomp@Do_sqlMofcomp@x8007735f
Can this version coexist with VS2005 beta 2 because before i can install visual studio 2005 beta 2 I need to uninstall the dot net framework 2.0 beta which come together with the beta 3 sql 2005 installation.
Hey I link this editor, Where can I get this beautiful forum message editor ?.
Where To Keep Dts(s) If I Don't To Upgrade Them Packages In Sql2005
Nov 30, 2005Hi,
reading BOL of 2005 and have few questions about dts and SSIS
question #1
if I don't want to upgrade my DTS to SSIS ,no way I can save it in
msdb of 2005 ,so I have to do following
1. DTS package have to be saved as a COM-structured storage file
2. execute dts as dtsrun /Ffilename /Npackage_name /Mpackage_password
Am I right or missing some options ?
question #2
If I want to modify package in 2005 I have to do following
1. Export package to file from msdb
2. Use Studio to modify and test it
3. Drop package from msdb
4. Import package to msdb from file
Thanks
Alex
Sql2005 Upgrade Queston
Nov 30, 2006Hi guys,
I have done an in-place upgrade of a SQL2000 server to SQL2005 Ent. The upgrade was very smooth for the most part but when I check the versions of my databases they still say 8.0 and not 9.0. I'm able to change them to be 9.0 but I'm wondering why they were not changed automatically during the upgrade process? Any ides or is this something I have to be aware of for future upgrades?
Thanks for your time.
Msg 2715 After Upgrade To SQL2005
Mar 12, 2008After upgrading to MSSQL 2005 we have stored procedures which get this error
Msg 2715, Level 16, State 7, Procedure prc_sel_accruals, Line 37
Column, parameter, or variable #15: Cannot find data type umoney.
The user data type is defined in the database. I tried recompiling the SP, which suucceeds but then fails on execution.
The SP works under SQL2000. Is there anything we need to do after the conversion?
Upgrade From SQL2000 To SQL2005
Mar 10, 2008Hi,
I'm running a VB6 app with MDAC 2.8 on Windows Server 2003 SP1.
I create an ADO recordset with a SELECT statement which returns an empty recordset.
I then add 2 new records to it with AddNew and later perform an UpdateBatch.
Before the SQL upgrade it worked fine but now errors with:
'Cannot convert a char value to money. The char value has incorrect syntax.'
I did a SQL Trace to find out what the Updatebatch was actualling sending to SQL (listed below).
This works fine when I run it on Query Analyser using SQL 2000 but fails on SQL 2005.
I worked out the problem is linked to the columns NewValue and OldValue both are varchar 70.
The first insert has them defined varchar(7) and varchar(1). This insert succeeds, but the second insert has the columns defined as varchar(18) and varchar(12). This one fails (unless they only contains numbers!).
I'm confused.
I've read that sp_executesql has changed for SQL2005.
Any ideas anyone?
Thanks
Howard
Code Snippet
exec sp_executesql N'INSERT INTO "pit1_lamda".."Planalt"
("ElNo","Item","MvmtDate","NewValue","OldValue","PlanAltId","PlanNo","Timestamp","User_Id","RBNo","CreatorId","CreatorTypeCode","CreatedDate","ExitNo","PBTxnTriggerId","PremHistNo","RegContractPremium","WaiverPrem","SinglePremTot","PlanMvtId","SingMvtID","PLFAID","TrancheId")
VALUES (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13,@P14,@P15,@P16,@P17,@P18,@P19,@P20,@P21,@P22,@P23); INSERT INTO
"pit1_lamda".."Planalt"
("ElNo","Item","MvmtDate","NewValue","OldValue","PlanAltId","PlanNo","Timestamp","User_Id","RBNo","CreatorId","CreatorTypeCode","CreatedDate","ExitNo","PBTxnTriggerId","PremHistNo","RegContractPremium","WaiverPrem","SinglePremTot","PlanMvtId","SingMvtID","PLFAID","TrancheId")
VALUES (@P24,@P25,@P26,@P27,@P28,@P29,@P30,@P31,@P32,@P33,@P34,@P35,@P36,@P37,@P38,@P39,@P40,@P41,@P42,@P43,@P44,@P45,@P46)',N'
@P1 varchar(6),@P2 int,@P3 datetime,@P4 varchar(7),@P5 varchar(1),@P6 int,@P7 varchar(12),@P8 int,@P9 varchar(8),@P10 varchar(4),@P11
varchar(12),@P12 tinyint,@P13 datetime,@P14 int,@P15 int,@P16 int,@P17 money,@P18 money,@P19 money,@P20 int,@P21 int,@P22 int,@P23 int,
@P24 varchar(6),@P25 int,@P26 datetime,@P27 varchar(18),@P28 varchar(12),@P29 int,@P30 varchar(12),@P31 int,@P32 varchar(8),@P33 varchar(4),@P34
varchar(12),@P35 tinyint,@P36 datetime,@P37 int,@P38 int,@P39 int,@P40 money,@P41 money,@P42 money,@P43 int,@P44 int,@P45 int,@P46 int',
'000000',80,'01-01-2008','1463286','0',27425002,'043902305X2 ',57153,'mtstdat4','0000',
'mtstdat4 ',1,'03-05-2008',0,0,0,$0.0000,$0.0000,$0.0000,4250207,0,0,3001752,
'000000',11,'03-02-2008','10 In Force (V011)','3 AwaitIssue',27425003,'043902305X2 ',57155,'mtstdat4','0000',
'mtstdat4 ',1,'03-05-2008',0,0,0,$0.0000,$0.0000,$0.0000,4250207,0,0,3001752
Upgrade To SQL2005 - Installed Instances
Nov 5, 2006
My SQL2000 databases did not upgrade to SQL2005. When I look at the Properties>>Options>>Compatibility Level the only options I have is version 7 and version 8... version 9 - which is SQL2005, is not there.
So what did I do? During the upgrade process - the installation wizard - I made a couple of choices that I believe might have lead to my current condition. The first thing is that I chose to select a installed instance. The second choice I made was to use a domain user account for the Authentication. The second selection I believe had nothing to do with the condition, but I did notice that my Systems Admin user account for SQL is no longer availble... which is a problem because now when I log into the SQL Management Console... it's using the domain name to authenticate rather than using the SA name like it was in SQL2000.
So here is what I think the solution is... I need to create a new Server Registration and create the databases in the new instance and then restore the data from SQL2000 to SQL2005 new instance, and then I can change the Compatibility Level to version 9.
The only issue I still don't have an answer for is the authentication into SQL. I want to not use the domain user account... how can I change this or can I? This also creates an issue when creating the ODBC connection as it wants to use the domain user account to verify.
So if someone can let me know if this is the right direction? Also any suggestions... i would greatly appreciate it!
John
SQL2005 Upgrade Advisor's Warning
Nov 6, 2006hi there
I have remote SQL2000 server and have client of it on my system.
As I try to check upgrade issues with SQL2005 Upgrade advisor by writing server name and pressing DETECT button,it gives me error--"Requested registry access is not allowed.(mscorlib)".
Could you tell me what are the access i will need to run Sql 2005 upgrade on remote server.
Sql2005 Database Restore From Another Sql2005 Backup File Error.
Dec 15, 2005hi
i try to restore a bak file from another sql2005 server to my sql2005 server, but it show the error message as below :
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupackup.bak'. Operating system error 5(error not found).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3201&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
pls some one can help me ???
thanks
chaus
SQL2005 Sp2 Upgrade Failed Due To Task Scheduler
Jul 5, 2007 When I install the sp2 in a cluster,the database engine upgrade failed.I found the error log for the install at C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixHotFix.log.
Here's the part that mattered:
07/05/2007 15:34:18.319 Patching available passive node: NODEA
07/05/2007 15:34:18.319 Patching passive node: NODEA
07/05/2007 15:34:18.335 Waiting for first completed passive node
07/05/2007 15:34:18.491 Task Scheduler: Created remote folder for product instance target \NODEA
07/05/2007 15:35:00.194 Task Scheduler: Transferred payload to remote product instance target \NODEA
07/05/2007 15:35:00.194 Task Scheduler: Transferred payload to remote product instance target \NODEA
07/05/2007 15:35:00.241 Task Scheduler: Created new scheduled task for product instance target \NODEA
07/05/2007 15:35:00.663 Task Scheduler: Saved new scheduled task for product instance target \NODEA
07/05/2007 15:35:00.663 Task Scheduler: Created scheduled task for product instance target \NODEA
07/05/2007 15:35:00.663 Task Scheduler: Started scheduled task for product instance target \NODEA
07/05/2007 15:35:00.663 Task Scheduler: Started scheduled task for product instance target \NODEA
07/05/2007 15:40:06.817 Task Scheduler: Scheduled task for product instance target has completed
07/05/2007 15:40:06.817 Task Scheduler: Waiting for exit code from scheduled task for product instance target \NODEA
07/05/2007 15:40:11.817 Task Scheduler: Received exit code 29512 from scheduled task for product instance target \NODEA
07/05/2007 15:40:11.817 Task Scheduler: Result code for scheduled task for product instance target has been received
07/05/2007 15:40:11.817 Task Scheduler: Removed scheduled task for product instance target \NODEA
07/05/2007 15:40:12.333 Task Scheduler: Removed remote folder for product instance target \NODEA
07/05/2007 15:40:12.333 Remote process completed for product instance target
07/05/2007 15:40:12.333 Exit code for passive node: NODEA = 29512
07/05/2007 15:40:13.333 The following exception occurred: No passive nodes were successfully patched Date: 07/05/2007 15:40:13.333 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllinstance.cpp Line: 3422
07/05/2007 15:40:13.676 Watson: Param1 = Unknown
07/05/2007 15:40:13.676 Watson: Param2 = 0x2b01
07/05/2007 15:40:13.676 Watson: Param3 = Unknown
07/05/2007 15:40:13.676 Watson: Param4 = 0x0
07/05/2007 15:40:13.676 Watson: Param5 = instance.cpp@3422
07/05/2007 15:40:13.676 Watson: Param6 = Unknown
07/05/2007 15:40:13.676 Watson: Param7 = SQL9
07/05/2007 15:40:13.676 Watson: Param8 = Hotfix@
07/05/2007 15:40:13.676 Watson: Param9 = x86
07/05/2007 15:40:13.676 Watson: Param10 = 3042
07/05/2007 15:40:13.676 Installed product: SQL9
07/05/2007 15:40:13.708 Hotfix package completed
07/05/2007 15:40:13.708 Attempting to continue the 32 bit ngen queue
Any advise?Thanks in advance.
SQL2005 SP1 Upgrade Failed : The Specified Driver Is Invalid
Jan 9, 2007We are getting a failure when upgrading to SP1 for SQL2005. We're running Windows 2003 Enterprise Edition SP1. We're running 4 SQL 2005 instances and 6 SQL 2000 instances on this machine. One of the four 2005 instances did upgrade successfully - don't know how or why.
Looking at other postings, it seems that the 10 lines or so preceding "value 3" in the upgrade log file (under C:WINDOWSHotfixSQL9Logs) are helpful in diagnosing the problem.
Here are the lines preceding the value 3:
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Mon Jan 08 13:38:23 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='2001' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Mon Jan 08 13:38:23 2007
Gathering darwin properties for failure handling.
MSI (s) (50!8C) [13:38:25:219]: Transforming table Error.
MSI (s) (50!8C) [13:38:25:219]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (50!8C) [13:38:25:219]: Transforming table Error.
MSI (s) (50!8C) [13:38:25:219]: Transforming table Error.
MSI (s) (50!8C) [13:38:25:219]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (50!8C) [13:38:25:219]: Transforming table Error.
MSI (s) (50!8C) [13:38:25:219]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (50!8C) [13:38:25:219]: Transforming table Error.
MSI (s) (50!8C) [13:38:25:219]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 2001
MSI (s) (50!8C) [13:38:25:219]: Transforming table Error.
MSI (s) (50!8C) [13:38:25:219]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (50!8C) [13:38:25:219]: Transforming table Error.
MSI (s) (50!8C) [13:38:25:219]: Transforming table Error.
MSI (s) (50!8C) [13:38:25:219]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (50!8C) [13:38:25:219]: Transforming table Error.
MSI (s) (50!8C) [13:38:25:219]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (50!8C) [13:38:25:219]: Transforming table Error.
MSI (s) (50!8C) [13:38:25:219]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (50!8C) [13:38:25:219]: Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The specified driver is invalid.
<Failure Type='Fatal' Error='2001'>
<EndFunc Name='LaunchFunction' Return='2001' GetLastError='0'>
MSI (s) (50:F0) [13:38:25:251]: User policy value 'DisableRollback' is 0
MSI (s) (50:F0) [13:38:25:251]: Machine policy value 'DisableRollback' is 0
Action ended 13:38:25: InstallFinalize. Return value 3.
Thanks,
Bruce
Can You Open A Database Created In SQL2005 In SQL2005 Express?
Oct 12, 2007
Can you open/use a database created in SQL2005 in SQL2005 Express?
Thanks for the help!
Max
Error Creating Database On Windows CE 5.0, CF 3.5 Beta
Oct 5, 2007Hi,
I'm using VS2005, .NET Framework Version 2.0.50727 on Windows Vista Business.
I wish to implement a database in my mobile device which is using Windows CE 5.0, .NET Compact Framework 3.5 Beta, which version of SQL server should I install into the device?
I've tried using SQL mobile 2005 and SQL Server 2005 Compact Edition but it won't work. I'm having a Can't find PInvoke DLL 'sqlceme30.dll' error when I try to run the following block of code:
Code Block
private void button1_Click(object sender, EventArgs e)
{
SqlCeConnection sqlCeConnection = null;
MessageBox.Show("Entering try block");
try
{
if (!File.Exists(@"My DocumentsTest.sdf"))
{
SqlCeEngine sqlCeEngine = new SqlCeEngine(@"Data Source = My DocumentsTest.sdf");
sqlCeEngine.CreateDatabase();
MessageBox.Show("Create successful");
}
sqlCeConnection = new SqlCeConnection(@"Data Source = My DocumentsTest.sdf");
sqlCeConnection.Open();
MessageBox.Show("Open successful");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (sqlCeConnection != null)
sqlCeConnection.Close();
}
}
Can anyone please tell me how to solve this problem? Thanks in advance
Beta Testing A Cross Database Integrity Tool
Nov 21, 2006Hi,
We are in search of beta testers for our new software tool for SQL Server : Remote Keys allows you to define and enforce cross databases integrity constraint. With Remote Keys, you can create a foreign key between to SQL tables located in distinct databases.
Beta version can be downloaded here : www.remote-keys.com.
Thank you,
Tom
Beta Testing A Cross Database Integrity Tool
Jan 5, 2007Hi,
We are in search of beta testers for our new software tool for SQL Server :
Remote Keys allows you to define and enforce cross databases integrity
constraint. With Remote Keys, you can create a foreign key between to SQL
tables located in distinct databases.
New version (beta 2) can be downloaded here : http://www.remote-keys.com
Thank you,
Tom
Step By Step SQL2000 Failover Cluster Upgrade To SQL2005
Oct 13, 2006is there such a paper? if so, can you pls point me to it? thx in advance
View 4 Replies View RelatedSQL2005 Cannot Backup A Restored SQL2000 Database With Unknow Database Full-text Catalog Database
Nov 15, 2007
We replicate a SQL2000 database (DataBaseA) to a SQL2000 database (DataBaseB) by using the Restore function and hasn't change its logical name but only the physical data path and file name. It is running fine for a year. We use the same way to migrate the DataBaseB to a new SQL2005 server with the Restore function and the daily operation is running perfect. However, when we do the Backup of DatabaseB in the SQL2005, it just prompt the error message
System.Data.SqlClient.SqlError: The backup of full-text catalog 'DataBaseA' is not permitted because it is not online. Check errorlog file for the reason that full-text catalog became offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)
Please note we left the DataBaseA in the old SQL2000 server.
Please help on how we can delete the Full-text catalog from DatabaseB so we can do a backup
Many Thanks
Migrating From Sql2000 MSDE Database To Sql2005 Express - Attach Database Errors
Apr 23, 2006I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which I have heard works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.
Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get the following error:
Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
Of course, some of the entries will be read only, since doctors have to sign off the charts and are not allowed to subsequently change them. But I should still be able to switch over to sql 2005?!?!?!?
Or... is there a way to attach the databases to SQLExpress manually?
Help pls?
Attach Database To SQL2005 From Old MSDE Database
Apr 22, 2006I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which the company says works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.
Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get an error:
Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
Or... is there a way to attach the databases to SQLExpress manually?
Help pls?
SQL2005 - Don't See My Database When I Use VPN-connection
Oct 28, 2006Situation: at work we have a windows 2003 server with MS sql server2005 express. With my pc at work, I can see my own database I created.At home. I can connect with VPN to the network. With extern desktop Ican see the database and do everything. Now I want to create a loginwith visual web developer 2005 express. But when I try to login withsql server authentication I don't see any database. When I try windowsauthentication, I have connection with the master, model, msdb andtempdb but not my own database. I am very sure at work I could createthe login and the permissions were OK.Thanks
View 3 Replies View RelatedUpgrade SQL Express Database To SQL Server Standard Database
Dec 6, 2006Can I upgrade SQL express database to SQL server Standard database? Please give information to me! Thank you!
View 4 Replies View RelatedSQL2005--how To Prohibit Database Restore...
Sep 24, 2007We currently built a new SQL2005 server and have serveral sentitive Payroll database hosted in it. I managed to seperate some roles to various users to prohibit them to direct access the data but can access it via front-end application.
The problem is I setup a backup operator with the following rights
Server Roles -- Public
User Mapping
User Mapped to this login / Database membership for
PayrollDataBase_1 BackupOperatorName
db_backupoperator / db_denydatareader / db_denydatawriter / public
However, I try to login using the 'BackupOperatorName' in my workstation and Backup the PayllrollDataBase_1 to a server shared path says E:SqlDataBacupPayrollDataBase_1.BAK. Afterward, I copy it over the network back to my workstation and RESTORE in back to my local SQL2005 instant using the local SQL2005 SA user. All data CAN BE browse
Anyone please help to post how to restrict the Backup operator can only Backup the database but cannot restore to its local SQL2005 instant
Many Thanks in advance
Sql2005 And Possible Database Auditing/monitoring...
Jul 13, 2007Does 2005 have some kind of new feature that audits/monitors changes to a database kind of like an antivirus or something.
Reason for question:
1) inserting records into database, 1000 records takes about 2 minutes.
2) reading those 1000 records takes about 45 seconds
3) updating those 1000 records takes about 15 minutes
4) yes we are using ntwdblib.dll and a 4gl language
i was running a test program to add, read, update, delete 1000 records and that is when i noticed that insert, update, delete took a performance hit whereas reading didnt. i ran my test program on a control server (in house) and then at the clients side(matching OS, MSSQL 2005 SP2). Results from test program: The UPDATE process on client side took about 4x longer, INSERT about 2x longer, DELETE about 1.5x longer, READ was actually faster on the clients system.
so this made me wonder if their was some kind of database monitoring/auditing going on.
Error In Database Mail In Sql2005
May 2, 2008hi
i have use database mail in sql server2005 to send mail.
i have complete all step to configure databasemail.but test the mail
the error is "database mail stoped.Use sysmail_start_up to start database mail .
Shrink Log File Database In Sql2005
Jun 23, 2008hi
i have shrink log file of database use dbcc command
Message
Executed as user: sa. Cannot shrink log file 2 (abc.ldf) because all logical log files are in use. [SQLSTATE 01000] (Message 9008) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528). The step succeeded.
Intermittent Slow SQL2005 Database
Aug 2, 2007I'm querying a small SQL2005 database and finding that the query can sometimes complete in under a second and then 5 minutes later the same query can take 15 minutes to complete.
The query I'm running is very simple as follows:
select TOP 26 * from vSearchListOpportunityItem WHERE OpIt_OpportunityId=2495 ORDER BY Prod_Name, OpIt_OpportunityItemId
The view it is pulling data from only contains only 1890 lines, which in turn pulls data from 3 tables with 821, 2560, and 1957 lines of data. In other words it's small. I have noticed that if I try and open the smallest of these tables while on a 'go slow' period it also takes around 15 minutes to return the data.
The database was originally on SQL 2000. It is the only database on this powerful quad core server.
The SQL Server CPU usage never goes above 40%, and always has free memory.
No sign of locks.
I can't figure out why such a small database is going so slow with such a simple query. Any ideas?
Moving Database From Sql2000 To Sql2005
Mar 28, 2008I am planning to move the sql server 2000 database to the sql server 2005 database. I have to restore that by using the back up copy. Do I need to follow any special instructions or just like moving from one server to another. Could some body help with this. Thanks!
SQL2005 Database Mailer Problem
Jul 26, 2006Hi there,
Got a 2005 SP1 SQL box, with database mailer giving problems. In the sysmail_event_log is has
1) Exception Information =================== Exception Type: System.NullReferenceException Message: Object reference not set to an instance of an object. Data: System.Collections.ListDictionaryInternal TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32) HelpLink: NULL Source: DatabaseMailEngine StackTrace Information =================== at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID) at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.SessionManager.GetAccount(Int32 accountID) at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession) at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession) at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db) at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)
Error: 14667, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
whenever it is trying to send an email. The only way to get this to start sending mail is to run the databasemail90.exe file, so the profiles security etc seem ok. It's just that after the SQL box gets restarted
that it gives all these problems and then it needs some tinkering before it starts to work again.
So anybody got any ideas or tops on what can be done to help sort this out?
Thanks!