Viewing 15 posts - 166 through 180 (of 260 total)
The Screenshot which you've attached is basically an Informational Message. It's not an error.... All it is saying is, you should manually drop respective Database users later, because dropping a...
June 12, 2014 at 7:10 am
You should be able to install 2005 as a named Instance just fine without any issues in your scenario.
Well...I never was in this situation but I don't see a reason...
June 11, 2014 at 7:28 am
Why 2 log files??...
Coming to the desired size for your LDF file, it really depends on your environment. There is no fixed number as a best practice which fits for...
June 10, 2014 at 9:03 am
At this point, I would just delete those existing 3 Maintenance plans and recreate them from scratch. 🙂 😎
June 4, 2014 at 2:32 pm
Have you tried changing the associated Jobs owner to 'sa'?
June 4, 2014 at 9:18 am
Yes, DB Users peice of security will be good. But keep in mind, you still have to deal with Logins at the Instance level in secondary replicas.
May 21, 2014 at 8:14 am
This might help as well...
Note: Read comments as well in the post.
April 1, 2014 at 9:10 am
Looks like you've got 1204 and/or 1222 trace flags turned ON.
By default, SQL server won't log deadlock details in the SQL Server Error log. SQL Server basically sends "Msg 1205,...
March 26, 2014 at 8:01 am
Agree...Start with SSMA. I've used it in the past without any issues.
March 14, 2014 at 12:24 pm
Rod at work (3/12/2014)
Sqlcmd: 'GÇôE': Unexpected argument. Enter '-?' for help.
The contents of the...
March 12, 2014 at 7:57 am
Rod at work (3/11/2014)
sreekanth bandarla (3/11/2014)
syntax:
sqlcmd -S .\SQLEXPRESS -E -Q "EXEC master..sp_BackupDatabases...
March 11, 2014 at 1:32 pm
I think, That's where you are having issues with. Type it manually and let me know how it goes...
syntax:
sqlcmd -S .\SQLEXPRESS -E -Q "EXEC master..sp_BackupDatabases @backupLocation='C:\SQLBackups\', @backupType='F'" -o "C:\SQLBackups\Backupjob_Log.txt"
Also, double...
March 11, 2014 at 9:24 am
Also, you don't need to specify -E if you are using -U and -p switches and they are case sensitive.
March 11, 2014 at 8:12 am
Rod at work (3/11/2014)
sreekanth bandarla (3/10/2014)
Rod at work (3/10/2014)
sreekanth bandarla (3/7/2014)
BTW, here is the KB article on how you can do that...
sreekanth, I went to the link you provided. I've...
March 11, 2014 at 8:09 am
Rod at work (3/10/2014)
sreekanth bandarla (3/7/2014)
BTW, here is the KB article on how you can do that...
sreekanth, I went to the link you provided. I've gotten the SQL script that's...
March 10, 2014 at 1:29 pm
Viewing 15 posts - 166 through 180 (of 260 total)