Viewing 15 posts - 28,786 through 28,800 (of 49,552 total)
Databases are not 32 bit or 64 bit. There is no difference in the file structure or backup structure between the two. You can move databases from 32 bit to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 21, 2010 at 7:40 am
Without seeing the exec plan and the table/index definitions, it's really hard to answer these kind of questions. You're just not posting enough information for us to be able to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 21, 2010 at 6:41 am
-
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 21, 2010 at 5:48 am
If the database is in simple recovery, log records are truncated on checkpoint (which a backup runs).
If the database is in full recovery, log records are truncated on checkpoint...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 21, 2010 at 5:45 am
Should do.
Once the initial screen comes up, you can check. It's the options menu (right at the bottom)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 21, 2010 at 4:14 am
With a 64-bit OS you can run either 32-bit or 64-bit SQL. Unless you have a really good reason to run the 32-bit version, don't run that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 21, 2010 at 3:04 am
Hardy21 (12/21/2010)
jimmy.liew - you can use ALTER DATABASE set ... command as a try to back the database Online again.
Not if the database is In Recovery (Recovering in sys.databases) or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 21, 2010 at 2:44 am
Should? No. I'm saying that for the DB to have gone into recovery that's what would have been necessary. Can't offhand think of any other ways (short of someone running...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 21, 2010 at 12:36 am
bitbucket-25253 (12/20/2010)
SELECT so.Name AS 'Table',sc.Name AS 'Column'
FROM sys.sysobjects...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 21, 2010 at 12:08 am
Pei Zhu-415513 (12/20/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2010 at 11:48 pm
Shouldn't do. For a db to go into recovery the db needs to be restarted (eg offline/online) or the instance or the server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2010 at 11:47 pm
Pei Zhu-415513 (12/20/2010)
Interesting and hard to believe.
So you're right and 4 of us (and the SQL documentation) are wrong?
TLog bloated due to the pending replication.
Yes. To be expected. There are...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2010 at 2:12 pm
No, but you will not have auto-failover capabilities until the witness comes back.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2010 at 2:08 pm
Pei Zhu-415513 (12/20/2010)
Are you sure? rebuild index(such as alter index .. rebuild) is fully logged if db is full recovery db. As a result, log reader should scan log and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2010 at 2:04 pm
Post the exact errors please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 20, 2010 at 1:40 pm
Viewing 15 posts - 28,786 through 28,800 (of 49,552 total)