Viewing 15 posts - 17,926 through 17,940 (of 49,552 total)
Make sure only the DBA has the required rights to restore a DB.
Or do you mean you want to secure the backup file so it can't be restored elsewhere?
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 23, 2012 at 9:38 am
DBCC CheckDB is what you use to detect corruption.
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 23, 2012 at 7:32 am
Be patient.
MS doesn't email you with beta exam result. You get the paper results in the post from Prometric. As for the MCP site, it says that it takes time...
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 23, 2012 at 7:27 am
BSavoie (6/23/2012)
I want the rows back in the same order they were entered (the physical order).
Then you need a column that defines that order and you need to order...
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 23, 2012 at 5:49 am
SQL_Surfer (6/22/2012)
Yep. I had 'take tail log backup' option checked. Thanks.
That option means 'backup the log and switch the database into the restoring state'.
It's not an option that should...
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 23, 2012 at 5:47 am
ksrikanth77 (6/22/2012)
This happens when there is a permission issue with the ID which you are running the job or there is a Drive corruption where the backups are executing
It's not...
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 23, 2012 at 5:38 am
Welsh Corgi (6/22/2012)
I could exclude the sys.schemas table and use the Schama_Name Function on Schema_Id.
Yes, you could.
What existing Table & Column to a JOIN to from the sys.Tables Column?
GilaMonster (6/22/2012)
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 22, 2012 at 11:51 am
Join to sys.tables on object_id, then to sys.schemas on schema_id. Add sys.schemas.name to the list of columns
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 22, 2012 at 11:22 am
Join to sys.tables and then sys.schemas
p.s. Don't automatically create 'missing' indexes, they're guidelines not directives.
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 22, 2012 at 11:07 am
Welsh Corgi (6/22/2012)
How do you navigate to your private messages?:unsure:
Top left, right above Home > [Forum name], the link that reads "Messages"
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 22, 2012 at 11:06 am
And note that there's a space in the folder name because the database has a trailing space in its name
Backup\\Tax \\
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 22, 2012 at 10:31 am
Jai-SQL DBA (6/22/2012)
Another Way of fixing is as Follows:If you want to attach a MDF without LDF you can follow the steps below It is tested and working fine
Nope, that'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 22, 2012 at 5:32 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1319084-359-1.aspx
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 22, 2012 at 1:41 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1319084-359-1.aspx
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 22, 2012 at 1:41 am
Restore from backup is the safest and often fastest.
Your 'solution' contains deprecated functionality (sp_dboption) and may well result in data loss (CheckDB with REPAIR ALLOW DATA LOSS)
Any 'solution' that suggests...
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 22, 2012 at 1:41 am
Viewing 15 posts - 17,926 through 17,940 (of 49,552 total)