Viewing 15 posts - 4,981 through 4,995 (of 6,679 total)
I would use Powershell and SMO - in fact, that is exactly what I use. I run a script every morning that hits all 160 SQL Servers and returns...
June 19, 2009 at 7:51 pm
Steve Jones - Editor (6/19/2009)
June 19, 2009 at 1:53 pm
With your setup - I would never set up mirroring in synchronous mode. With a geographically separated system you would need a dedicated network to make sure you could...
June 19, 2009 at 9:55 am
Steve Jones - Editor (6/19/2009)
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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?
June 18, 2009 at 9:39 am
Viewing 15 posts - 4,981 through 4,995 (of 6,679 total)