Viewing 15 posts - 7,276 through 7,290 (of 9,253 total)
in synchronous mode if the transaction does not commit on the mirror it is not committed on the principal. This is the idea of synchronous mode, the principal waits until...
February 13, 2011 at 12:20 pm
Another Reason: sql 2005 has a new system db MSSQLSystemresource db which has system info,where as in sql 2000 master has all system info.
is this also a reason.
😉 answered your...
February 13, 2011 at 11:48 am
are you deleting all the data in the table or just image columns, truncate gets around this issue but does remove all data. This article may also explain a little...
February 13, 2011 at 10:59 am
Derrick Smith (1/31/2011)
February 4, 2011 at 9:53 am
probably be something along the lines of
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log
the setup failure will display the log file name and path!
January 31, 2011 at 2:37 pm
iamsam.sandeep (1/31/2011)
January 31, 2011 at 2:12 pm
has someone taken a full backup of this database by any chance?
January 31, 2011 at 2:10 pm
copy the job from another server and don't forget to change the computer name in the job step 😉
January 31, 2011 at 2:07 pm
pipe the output of this into a table
sqlcmd -Lc
January 31, 2011 at 2:05 pm
also what operating system are you using on the machine you are installing sql server on to
January 31, 2011 at 1:00 pm
nadabadan (1/31/2011)
If the data is constantly changing as the OP stated, using snapshots on mirrored dbs would not be a good idea.
the OP doesn't actually state that anywhere, but, it...
January 31, 2011 at 12:57 pm
Details will be provided in the setup log, it gives you the path and filename to this log on the failure screen
January 31, 2011 at 7:11 am
vadon97
This time, I took note of my settings on the Server Configuration->Service Accounts tab, I had NT AUTHORITY\SYSTEM designated for the Server Agent, Server Database Engine, and SSIS.
This is...
January 31, 2011 at 1:06 am
you could mirror the database and then take regular snapshots of the mirror to allow users to read data
January 30, 2011 at 2:03 pm
regardless of the utility, once you restore the database 'WITH RECOVERY' no further backups may be applied!
January 30, 2011 at 1:25 pm
Viewing 15 posts - 7,276 through 7,290 (of 9,253 total)