If you backup the transaction log (today at Noon)
and then take a backup copy that's a month old of the same
database and restore it to your current database [which is possible],
Can you then apply the transaction log that you took at noon to that
same database which you restore with last month data?
I wouldn't think so because you have a month worth of
transaction log, your LSN wouldn't be matching.
Is that correct???
Hi,
How can I "confirm" that I am running sp3a ???
When I run @@version I get:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
But I should get:
Microsoft SQL Server 2000 - 8.00.760.09 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Can somebody confirm that the .09 does not show up on the 3a SP (or) was SP3 later released (as I think I recall reading) which incorporated 3a ???
I know we are at 3a I just can't confirm it via these queries :confused: .
Thanks in advance,
Nancy
I have taken over an existing SQL 7.0 server. It has current production systems running on it.
I need to *confirm* what the SQL Agent password is; what simple task or job can I setup that will require me to provide the SQL Agent password so that I can confirm that what I have been told it correct?
Or does someone have another technique.
Thanks,
Bobby
bobby@teamcomfluent.com
Server Error Message:
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1010818663, index ID 0: Page (1:305381) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1010818663, index ID 0, page (1:305381), row 34. Test (offsetNull >= BASEOFFSET) failed. Values are 0 and 4.
I've just finished installing the Developer Edition of SQL Server 2005 over the Eval Edition. I'm happy to say that, despite a few hiccups, I seem to have everything running smoothly now. However, I have read about a few cases where, although it appeared the installation was successful, various components of the Eval Edition were not properly upgraded, the time limit was reached and the eval expired.
How can I confirm a full and successful installation of the Developer Edition? (Help... About only gives me version numbers, not "editions.")
Thanks for any help,
Ken
How do we will come to know, whether file group is currupted or not
View 1 Replies View RelatedLooking for opinions here on what is the best way to programmatically test that a password change to a credential has occurred successfully.
The password change was made using Alter Credential, and I can see in sys.credentials that the credential was updated by the tool that handles these updates. I would just like to be able to confirm that all of the credential updates were successful (in other words, they authenticate correctly) before anything starts to fail.
Assume that the number of SQL Servers is too great to manually check them even if the whole team worked on it together.
Thanks in advance!!
How can i confirm that the data entered within the standard controls and after the click event for the particular sql query the data is been stored in the database tables (depending insert,update,delete).I want to display the different messages on the click event and that after the changes made into the tables.How can i do it ?? I m using ASP.Net with C#,VB and the sql server to store data.I also want to know where are the database tables exactly get stored which are made in the Microsoft SQL Server Management Studio Express.I want to use as the existing item in .Net but could not find.. Thanxs...
View 2 Replies View RelatedDuring startup one of my servers, containing a default and a named instance of 2005, receives the following error.
Message
Service Broker is disabled in MSDB or MSDB failed to start. Server level event notifications can not be delivered. Event notifications with FAN_IN in other databases could be affected as well.
The system databases for both instances were restored using backups from another instance. How do I confirm if Service Broker is enabled or disabled and why would I get this message? Is it due to restoring master or msdb?
Thanks, Dave