Viewing 15 posts - 4,981 through 4,995 (of 6,676 total)
Steve Jones - Editor (6/19/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 19, 2009 at 9:46 am
SQL Server has to roll back/forward all transactions that are hardened in the transaction log. Those transactions will be hardened after a transaction log backup is performed.
Since you are...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 18, 2009 at 1:30 pm
How often do you backup your transaction logs? Why is the transaction log file 70GB and the database 30GB?
My guess is that you have a lot of transactions that...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 18, 2009 at 11:37 am
That option really has nothing to do with file based backups. It is a legacy option for backups that went directly to tape where you would have to mark...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 18, 2009 at 10:50 am
In synchronous mode, the commits must occur on the mirror before they can occur in the primary. So, if you do not have a very fast and stable network...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 18, 2009 at 10:39 am
No, you cannot install a new instance as a default instance if you already have one installed. Disabling the services does not affect the installation - just does not...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 18, 2009 at 10:35 am
If you have restored (or detached/attached) this database multiple times and it is fine at first, then gets corrupted a few days later I would be talking to the server...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 18, 2009 at 10:33 am
No - there is no way to do this and I wouldn't even want to be able to. You are just going to have to suffer the rollback if...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 18, 2009 at 10:20 am
Well, what that shows is that you either have a problem with the destination I/O system, or the copy corrupted the mdf file.
I would recommend trying a restore from known...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 18, 2009 at 10:15 am
jvs (6/18/2009)
Both are identical versions. When we did backup and restore I think it didnt move the views and stored proc.Thanks for your help
Not sure why you would think this...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 18, 2009 at 10:03 am
As soon as the stop request was made - no new user connections can be made because SQL Server is being stopped.
Why would you be worried about seeing these messages...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 18, 2009 at 9:42 am
Are you, by chance - copying from a SQL Server 2000 system to a SQL Server 2005 system? Have you tried a backup/restore instead of copying the files?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 18, 2009 at 9:39 am
I use Redgate SQL Compare to build full schema copies of databases. Here is the process:
1) Create a brand new empty database
2) Run SQL Compare and select the existing...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 18, 2009 at 9:17 am
Was the database recently restored from another system?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 17, 2009 at 4:54 pm
What happens when you try to access the maintenance plans from SSMS on the cluster? Why do you say it is not working - and therefore, the upgrade did...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 17, 2009 at 3:03 pm
Viewing 15 posts - 4,981 through 4,995 (of 6,676 total)