Viewing 15 posts - 1 through 15 (of 388 total)
This is because the user is already exist in the database, go ahead and drop the user from the database and create login it shouldn't cause any problem. Is this...
March 26, 2010 at 4:04 pm
dsandhyarao (3/26/2010)
hi,The business rule is to run all the steps,so i canot stop the job.
this is for monitoring purpose for us to know which steps failed and react.
I don't think...
March 26, 2010 at 3:58 pm
What is the recovery model of the database? Check this article it explains reasons for growing log.
March 26, 2010 at 3:45 pm
Tom West (3/25/2010)
Apologies now, but I'm not a DBA, I'm a developer and we don't have any of the former here (budgetary constraints :ermm: )
Basically the question is...
March 26, 2010 at 3:36 pm
Check this, it should answer your question
http://msdn.microsoft.com/en-us/library/ms189336(SQL.90).aspx
March 26, 2010 at 3:24 pm
Is it using same windows account as back up job maintenance task?
March 26, 2010 at 3:11 pm
User doesn't have permission to create database, what role did you assign to this user?
March 18, 2010 at 4:19 pm
Perry is correct, ACID property holds good here.
March 18, 2010 at 4:12 pm
Perry Whittle (3/18/2010)
Scott Wise (3/4/2010)
March 18, 2010 at 4:08 pm
GilaMonster (3/18/2010)
dean gross (3/18/2010)
Thanks, the backup/restore worked.Could you explain more what you did? A backup of a 2008 database cannot be restored on a 2005 server.
Ditto.
March 18, 2010 at 2:51 pm
There are ton of them, here is one.
http://www.sqlservercentral.com/Forums/Topic715469-359-1.aspx
March 18, 2010 at 2:49 pm
May be you discovered another bug in SQL 2008 SSMS.
March 18, 2010 at 1:26 pm
I would remove that node from cluster before i uninstall, I am not sure if that is allowed in SQL 2005, it is allowed in SQL 2008.
March 18, 2010 at 1:22 pm
Lynn Pettis (3/18/2010)
Snapshot at 5:00 PM.
Developer fat fingers code dropping a table at 5:05 PM.
No restore, but recreate the table in original database using the data...
March 18, 2010 at 1:16 pm
Viewing 15 posts - 1 through 15 (of 388 total)