Viewing 15 posts - 91 through 105 (of 279 total)
Bouke Bruinsma (2/22/2015)
First of all, make sure you create full backups asap. Big tranlogs are usually a sign of absence of full backups altogether. After this, design a backup strategy/BCP.
Big...
February 22, 2015 at 4:55 am
Looks like this table is heavily fragmented before reindex. The index size before is almost thrice as after. Fill Factor is applied only during rebuild, not when insert/delete occur. You...
February 22, 2015 at 4:48 am
So you must start making logs backup, or switch databases in simple recovery mode, all this depend on yours backup strategy.
February 21, 2015 at 1:11 am
No
SELECT name,
[Currently allocated space] = size/1024.0,
[Available free space] = (Size-UsedSpace)/1024.0
FROM
(
SELECT s.name,
CAST(FILEPROPERTY(s.name, 'SpaceUsed') AS float)*CONVERT(float,8) AS [UsedSpace],
s.size * CONVERT(float,8) AS [Size]
FROM sys.database_files AS s
WHERE (s.type IN (0,1))
) AS x;
is not a...
February 20, 2015 at 2:36 pm
A developer license in only for develop purpose. If this is a production system then you must use standard (enterprise is probably outside a budget) or if limits is not...
February 20, 2015 at 2:24 pm
Start doing log backups, in any recovery mode different than simple this is a must. However if you are doing log backups then post result from this command:
select name,log_reuse_wait_desc from...
February 20, 2015 at 2:20 pm
Use proxy account for step 2, you could use local account (need the same name and password on both servers) or domain account if applicable.
February 5, 2015 at 1:49 am
You missed file name for cert and path for PK
BACKUP CERTIFICATE MyServerCert
TO FILE = 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\CertName.cert'
WITH PRIVATE KEY
(
FILE = 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\CertNamePK.key',
ENCRYPTION BY PASSWORD = '1234'
);
January 8, 2015 at 2:00 am
Error is clear "Operating system error 5: "5(Access is denied.)"." So you should again check permissions on db files, folders where files reside and give sql server account read/write. Maybe...
December 13, 2014 at 3:20 am
And what about option SET XACT_ABORT ON did you set this on for the transaction?
"XACT_ABORT must be set ON for data modification statements in an implicit or explicit transaction against...
December 13, 2014 at 3:11 am
November 6, 2014 at 12:27 pm
No. http://www.sqlskills.com/blogs/paul/search-engine-qa-26-myths-around-causing-corruption[/url]
You should ask why/when shrink.
June 29, 2014 at 6:19 am
This is windows logins or SQL? DBs that are default for them are copied to a new instance? What mean "But none of them seem to work." can't login, any...
November 21, 2013 at 2:31 am
Why SSIS, try a replication? Check this:
November 17, 2013 at 5:33 am
October 27, 2013 at 4:35 am
Viewing 15 posts - 91 through 105 (of 279 total)