Viewing 15 posts - 256 through 270 (of 2,647 total)
Lowell (8/21/2012)
SQLKnowItAll (8/21/2012)
Lowell, why the WHILE 0=0?thanks for catching that!
it was a copy paste blunder form something i adapted; i edited my post to yank that out;
Darn, I was hoping...
August 21, 2012 at 1:54 pm
Lowell, why the WHILE 0=0?
August 21, 2012 at 1:48 pm
ashwinboinala (8/21/2012)
its recovery model is full and the problem is there are duplicate entries in db
Well there's your problem 🙂
August 21, 2012 at 1:39 pm
Welsh Corgi (8/21/2012)
SQLKnowItAll (8/21/2012)
Welsh Corgi (8/20/2012)
Grant Fritchey (8/20/2012)
Since it's backing up with NOINIT, it's likely putting one backup on top of another. You may not be seeing the right backup.
Thanks....
August 21, 2012 at 1:04 pm
GilaMonster (8/21/2012)
Note that sys.objects is database-specific and...
August 21, 2012 at 12:37 pm
SQLKnowItAll (8/21/2012)
GilaMonster (8/21/2012)
Cross apply to sys.dm_exec_sql_text (on the plan_handle). One of the resultant columns is Object_ID.
Ok, but if I run this:
SELECT ps.object_id, s.objectid
FROM sys.dm_exec_procedure_stats ps
CROSS APPLY sys.dm_exec_sql_text(sql_handle) s I see...
August 21, 2012 at 12:32 pm
GilaMonster (8/21/2012)
Cross apply to sys.dm_exec_sql_text (on the plan_handle). One of the resultant columns is Object_ID.
Ok, but if I run this:
SELECT ps.object_id, s.objectid
FROM sys.dm_exec_procedure_stats ps
CROSS APPLY sys.dm_exec_sql_text(sql_handle) s I see that...
August 21, 2012 at 12:24 pm
Hmm... My thought was that the OP wanted to know how to take information from sys.dm_exec_procedure_stats, and either cross apply it or join it to get the name of the...
August 21, 2012 at 12:17 pm
sql2k8 (8/21/2012)
I had turned of autoclose on the database and now things are working well.
Integrity checks and backups are running well now.
Thank You very much for the help.
As autoclose is...
August 21, 2012 at 10:59 am
BaldingLoopMan (8/21/2012)
August 21, 2012 at 10:53 am
BaldingLoopMan (8/21/2012)
August 21, 2012 at 10:46 am
Sqlism (8/21/2012)
Hi Experts,I see some logins in sql server, can you explain why they exist and there uses?
1.NT SERVICE\MSSQL$INSTANCENAME
2.NT SERVICE\SQLAgent$INSTANCENAME
3.##MS_PolicyEventProcessingLogin##
4.##MS_PolicyTsqlExecutionLogin##
Thanks
The first 2 are virtual accounts. Check the backup application log...
August 21, 2012 at 9:58 am
Hmm... The write failure may indicate a space issue? Do you have enough space on the backup media?
August 21, 2012 at 9:50 am
Welsh Corgi (8/20/2012)
Grant Fritchey (8/20/2012)
Since it's backing up with NOINIT, it's likely putting one backup on top of another. You may not be seeing the right backup.
Thanks. I guess I...
August 21, 2012 at 9:42 am
I would start here:
Check the backup application log for detailed messages.
August 21, 2012 at 9:37 am
Viewing 15 posts - 256 through 270 (of 2,647 total)