Viewing 15 posts - 12,706 through 12,720 (of 49,552 total)
tinausa (6/18/2013)
The database is in use.
You cannot be connected to the database you're restoring into.
USE MASTER
GO
RESTORE DATABASE ....
and make sure that you don't have another window connecting to 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
June 18, 2013 at 10:44 am
If you're absolutely certain that you can restore from backups, stop the instance, delete the files, start SQL Server, restore from backup.
Make sure you can restore first!
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
June 18, 2013 at 10:13 am
ryan.mcatee (6/18/2013)
In simple recovery mode, when you take a full backup, I believe the log file is backed up and truncated.
No.
In simple recovery model a checkpoint will truncate the log....
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
June 18, 2013 at 10:10 am
Then drop it and restore, if you're certain it'll be faster and you have all the necessary backups to restore with no data loss.
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
June 18, 2013 at 10:00 am
Sai Viswanath (6/18/2013)
Hi Gail,Simple he wants to improve performance (as told by the development team).
Then suggest to him that tuning the queries is the appropriate path as partitioning is...
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
June 18, 2013 at 9:58 am
HildaJ (6/18/2013)
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
June 18, 2013 at 9:32 am
The database state (from sys.databases) is RECOVERING?
If so, wait. There's nothing that you can do to magically bring it out of recovering, the recovery process must complete.
The progress of the...
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
June 18, 2013 at 9:20 am
Not possible. A restore recreates the DB as it was at the time of backup. If the database that was backed up had one data file then the restored database...
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
June 18, 2013 at 9:17 am
Sai Viswanath (6/18/2013)
My client is hell bent to have the partitioning concept implemented, reason he got his db's migrated from SQL 2K to 2K8 and wanted to implement the features.
Why?...
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
June 18, 2013 at 9:12 am
T.Ashish (6/18/2013)
Do we have any way to clean cache of a particular query without affecting cache of other queries?
Why do you want 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
June 18, 2013 at 6:37 am
If you have two log files, SQL will fill the first then fill the second, then go back to the first (if there's free space in it)
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
June 18, 2013 at 6:35 am
Jason-299789 (6/18/2013)
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
June 18, 2013 at 6:33 am
SQLSACT (6/18/2013)
As for restoring backwards (restoring a database from a newer version to an older one) is not supported. I think it is possible but not pretty.
It's not that it's...
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
June 18, 2013 at 5:26 am
Backup, copy, restore. Nothing different.
2008 and 2008 R2 have the same compatibility level - 100.
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
June 18, 2013 at 5:19 am
Ananth@Sql (6/18/2013)
If it is Materialised then i thought it will defenetly increase the performance.
I wouldn't say 'definitely'. Depends on what the query does, what the view is and what's making...
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
June 18, 2013 at 4:18 am
Viewing 15 posts - 12,706 through 12,720 (of 49,552 total)