Viewing 15 posts - 10,756 through 10,770 (of 49,566 total)
sree-226516 (12/3/2013)
Recompile is not creating new execution plan also its not solving the issues.Only after I run update stats,execution time comes back to normal.
Then you may need to schedule that...
December 3, 2013 at 2:41 pm
If you cancel it, the delete has to roll back. That might well take more than 6 hours.
December 3, 2013 at 2:38 pm
dan-572483 (12/3/2013)
What happens if you run this command while a database is actually in the process of restoring?
Nothing, because the running restore will have an exclusive lock on the database.
Is...
December 3, 2013 at 2:18 pm
Do you have transactional replication configured on that database? Don't assume, check the replication folder in SSMS. Is there a transactional replication publication there for this database?
December 3, 2013 at 2:34 am
PravB4u (12/3/2013)
select log_reuse_wait_desc from sys.databases Where database_id =YOURDBIDpass database id and you'll get single row output.
Far easier to filter by the database name.
December 3, 2013 at 2:31 am
amandac (12/3/2013)
If I runuse %databasename%
then the select command, will this give me the correct result?
Well, it'll give you correct results, but it won't give you want I asked for. It's...
December 3, 2013 at 2:30 am
Not for every database on the server, that's a pretty meaningless list without the DB names. What is the log_reuse_wait_desc for that database? For the specific database you're having problems...
December 3, 2013 at 2:20 am
GilaMonster (12/3/2013)
What is log_reuse_wait_desc for that database (from sys.databases)?
December 3, 2013 at 2:14 am
No, that wouldn't have caused a problem.
What is log_reuse_wait_desc for that database (from sys.databases)? Are you sure you're not making multiple backups to the same file (appended)?
December 3, 2013 at 2:00 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1519100-391-1.aspx
December 3, 2013 at 1:58 am
It has no effect on 64 bit because it's not needed. On 32 bit, a process only had a 2GB virtual address space (or 3GB with /3GB). the -g flag...
December 3, 2013 at 12:44 am
happycat59 (12/2/2013)
December 2, 2013 at 11:49 pm
Damaged backup. Get a fresh backup from the 2005 server.
December 2, 2013 at 11:36 pm
-g has no effect on a 64-bit SQL instance. It's for 32 bit only.
December 2, 2013 at 11:35 pm
That requires the View Server State permission. It has nothing to do with how you log in, you just need the login you use to have that permission.
December 2, 2013 at 9:52 pm
Viewing 15 posts - 10,756 through 10,770 (of 49,566 total)