Viewing 15 posts - 436 through 450 (of 1,155 total)
You can just run the sql server setup wizard ( select all your configuration options ) till the last screen and instead on hitting install, just cancel it.
But note the...
February 26, 2014 at 10:14 am
Check this one by Richard Doering ..
SELECT
SCHEMA_NAME(o.schema_id) AS SchemaName ...
February 26, 2014 at 10:05 am
Yeah, it should not be an issue if you follow the steps correctly. Moreover, it's a dev server and you get good experience on restoring system databases which will be...
February 26, 2014 at 9:51 am
SQL Server Backups doesn't directly cause locking\blocking on user objects. But they do put a heavy overload on the I/O system so that it may appear as blocking. However...
February 26, 2014 at 9:30 am
May be you can schedule the backups using that Third Party tool at a convenient time so that they don't interfere with your business activity.
--
SQLBuddy
February 26, 2014 at 8:30 am
There is no specific role for Linked Servers. Just you need to manage security at the SQL Server level and you can use DB roles for granting granular permissions.
--
SQLBuddy
February 26, 2014 at 8:26 am
What is the build of your SQL Server ? Are you on SP3 ..
--
SQLBuddy
February 26, 2014 at 8:17 am
Logins will be in the AD group and you grant permissions to a role and add the group to that role. Then use " Be made using the login's security...
February 25, 2014 at 12:50 pm
Yeah, Backups need to be scheduled so that they don't interfere with the business processes. Schedule it during the night or early hours when you don't have users. That way...
February 25, 2014 at 12:43 pm
Yeah, though abt backups. But again felt that if it was backups then that should have been a recurring daily issue. Not a one time one ..
That's where SQL...
February 25, 2014 at 11:17 am
I don't see any DB related errors from the app log. Also the attachment doesn't show anything close to 1:13 AM.
Check with your network admin if there was any network...
February 25, 2014 at 11:06 am
Check if the DB server got restarted at that point of time .. Also good to check the SQL Server Error Logs for any specififc errors at that point ..
--
SQLBuddy
February 25, 2014 at 10:43 am
Did you check on the Application server or on the DB server ..
--
SQLBuddy
February 25, 2014 at 10:37 am
It could be a Network Glitch or a DB issue. Check the Windows Application Log and SQL Server Logs to see if it's a DB issue.
--
SQLBuddy
February 25, 2014 at 10:29 am
For the first time, it takes more time bcs of the compiling. For the subsequent runs, it uses the stored plan in the memory.
After 1 hr if the same thing...
February 25, 2014 at 10:23 am
Viewing 15 posts - 436 through 450 (of 1,155 total)