Viewing 15 posts - 27,781 through 27,795 (of 49,552 total)
sp_change_users_login is only there for backward compat with SQL 2000, is deprecated and should not be used any longer. It likely can't handle the newer SQL 2005 stuff.
Try
ALTER USER...
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
February 14, 2011 at 8:47 am
Sys.indexes isn't even a table. It's a view. The real system tables are hidden, completely undocumented and changing them is the fastest way yo really mess up your database beyond...
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
February 14, 2011 at 8:42 am
Markus (2/14/2011)
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
February 14, 2011 at 8:40 am
mw112009 (2/14/2011)
When I started the "RESTORE.." I used the query window in SSMS.
Then 4 hours later when I logged back into the server I did 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
February 14, 2011 at 7:51 am
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.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
February 14, 2011 at 7:28 am
If you always use physical only, you WILL miss many corruptions. It is not an option that you should use onb every execution.
No_infomsgs, all_errormsgs are the normal ones to use.
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
February 14, 2011 at 7:26 am
mw112009 (2/14/2011)
There is quite a bit of unused space in this file ( many GBs )...
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
February 14, 2011 at 7:13 am
Shrink database IS the command to remove unused space. Sounds like it may have grown the log. Check recovery model and log backups.
If you ran that on you production 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
February 14, 2011 at 7:01 am
No and no. It requires space for the full size of the original database. Restore somewhere that does have space, shrink the DB (DO NOT shrink your production DB), then...
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
February 14, 2011 at 6:53 am
sql_butterfly (2/14/2011)
Gail, Isn't Conflict detection present in Snapshot isolation ?
Yes, which is why you will get an error is there is an update conflict. Detection, not handling. You have 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
February 14, 2011 at 4:51 am
GilaMonster (2/14/2011)
I suggest you do some checks (or get your sysadmin...
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
February 14, 2011 at 4:37 am
Dup
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
February 14, 2011 at 4:37 am
It's not a hard query (though not one I have offhand). There are 5 or 6 backup tables in msdb, all names starting with backup.
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
February 14, 2011 at 4:37 am
mw112009 (2/14/2011)
question 1)Does this mean when SQL server makes a backup it considers only used space ? ( That is good if the answer is "YES" )
Correct.
question 2)
The new 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
February 14, 2011 at 4:11 am
under snapshot isolation you won't get deadlocks. However you can get update conflicts which will, similar to a deadlock, result in a transaction getting rolled back.
If you want tuning help,...
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
February 14, 2011 at 4:08 am
Viewing 15 posts - 27,781 through 27,795 (of 49,552 total)