Viewing 15 posts - 436 through 450 (of 612 total)
Thanks for that Erland but I do have a question.
Rebuilding an index will of course remove fragmentation and allow a database to be shrunk. That much is clear.
But if...
August 19, 2013 at 2:42 am
You are of course right and I should have worded my response better. Using the TRUNCATEONLY clause only frees up space at the end of the datafile and does...
August 19, 2013 at 12:31 am
1. Check to make sure the Initial size of the database is not set to a value higher than the amount you want to shrink the database to.
2. ...
August 18, 2013 at 9:29 am
curious_sqldba (8/16/2013)
August 18, 2013 at 9:24 am
Erland Sommarskog (8/18/2013)
August 18, 2013 at 9:16 am
Firstly I would suggest deinstalling anything SQL Server and anything Visual Studio. It is clear from your post that you have somehow failures in both Software packages. Delete...
August 18, 2013 at 9:13 am
Have you mapped a drive from the source server to the location on the remote server? You could use this drive letter then to access the remote backup folder.
August 17, 2013 at 2:27 am
You could try installing the software to another, customised location outside of that which you already have.
Without a more detailed description of your setup it is difficult to offer mre...
August 17, 2013 at 2:23 am
Hi all and thanks for the answers!
It was a system database (not master) that had the problem. I have just recreated the problem and realised that.
Still, it...
August 15, 2013 at 5:10 am
Hadrian (3/2/2009)
rhe witness must be on a separate computer not the two involved in mirror direct
That is not strictly true, the witness MUST NOT be on a separate machine...
July 27, 2013 at 9:24 am
Steve-3_5_7_9 (7/10/2013)
kevaburg (7/9/2013)
July 19, 2013 at 10:15 am
mohan.bndr (7/17/2013)
Hi All,Have one situation...
If we take full backup .. will it be affect the LSN Chain. Please reply me
No. Only a transaction log backup will break the chain.
July 19, 2013 at 9:54 am
schleep (7/9/2013)
http://www.sqlservercentral.com/Forums/Topic1328455-1550-3.aspx#bm1352733
After banging our heads against the proverbial wall for a week, we stumbled upon the solution: re-boot the...
July 9, 2013 at 5:51 am
Mac1986 (7/8/2013)
yes i do have xp_cmdshell enabled. All i see in the job log is Access denied. Its does not say anything else.
--Turn on extended configuration options
exec sp_configure 'show advanced...
July 9, 2013 at 2:52 am
PHYData DBA (7/8/2013)
When you create an Account the SID gets imported from AD, could be something in AD or the SQL instance...
July 9, 2013 at 2:47 am
Viewing 15 posts - 436 through 450 (of 612 total)