Viewing 15 posts - 391 through 405 (of 966 total)
I could be wrong, but I believe a clustered index is for how the data is stored, not retrieved. From what I've read the optimizer can take various ways of...
July 8, 2013 at 8:17 pm
TempDb is used for several things in SQL Server. DBCC CHECKDBs, temp tables, row versioning, etc. If TempDb keeps getting to 2GB in size I would say that is a...
July 8, 2013 at 2:14 am
Copy-only full backups are the same concept as copy-only log backups. It does not write an archive bit so the log chain is not interrupted with the backup. It is...
July 8, 2013 at 2:00 am
It is not so much that the agent is not supported, the functionality is not actually present in the express editions.
Features Supported by the Editions of SQL Server 2008 R2
If...
July 8, 2013 at 1:53 am
Just came across this:
SQL Server Management Studio 2012 errors when doing restore to SQL 2008
Take a look at the workaround and see if that works for you.
July 3, 2013 at 3:48 am
Did you actually read any of the articles that talk about remoivng log shipping? All stored procedures for log shipping rely on database NAME, not ID. DB ID would not...
July 3, 2013 at 3:38 am
There is something else you can try. Can you go to the directory that the SQL binaries are installed (normally something like c:\program files\microsoft sql server\MSSQL10_50.<instancename>\MSSQL), go to the log...
July 3, 2013 at 2:59 am
Correct. There are many pieces to log shipping. You need to specify the log shipping server and database in log shipping that you are removing. There are links to the...
July 3, 2013 at 2:53 am
Do you have jobs/maintenance plans that run on a scheduled basis? Is it possible that another full backup kicked off between the time that you performed your full backup and...
July 3, 2013 at 2:52 am
Run sp_who2, look in the blkby column and find the process that is at the start of a block chain. Identify its SPID. Then you can run "kill <SPID>" to...
July 3, 2013 at 2:50 am
How are you planning on enforcing the encryption for the connection? I ask because if you are using FIPS I would test it out because you can break application functionality...
July 3, 2013 at 2:47 am
Interesting. When you restore the full backup are you leaving the db in recovery?
I would restore using T-SQL. You only have 3 backups to restore (2 if you don't want...
July 3, 2013 at 2:27 am
Then go through the full and differential restores again in SSMS and before executing the restores script out the actions and post the scripts here so we can see what...
July 3, 2013 at 2:04 am
Viewing 15 posts - 391 through 405 (of 966 total)