Tagged Questions
0
votes
1answer
31 views
How to allow a SQL Login to see only ONE database
i have a SQL Server server 2008 r2. I wish to create a two new Login for a client who wishes to have access to their one database. But I don't want to give them access to the other my databases.
...
0
votes
0answers
46 views
SQL failover cluster on single ESXi host
I'm setting up a virtual environment consisting of 10 VM's with 2 primary SQL databases required. The infrastructure allocates two pairs of SQL 2008 R2 Enterprise edition (VM's). The pairs are ...
0
votes
0answers
56 views
MS SQL 2008 - Can I use Windows Authentication to connect from a Mac
I have been using Navicat SQL on Mac (Snow Leopard) to connect to MS 2005 via "Basic Auth" and all is good.
However the DB is now being migrated to MS 2008 and try as I might I cant get on via Windows ...
0
votes
0answers
61 views
Merge Replication fails on some tables (multiple publishers, single subscriber)
We had set up merge replication with multiple publishers and a single subscriber. The articles are four tables (similar across all four publications).
The problem is that 1 of the tables has been ...
2
votes
1answer
63 views
Missing MSSQL10.SQLEXPRESS folder
I seem to be missing my
C:\Program Files\Microsoft Sql SERVER\MSSQL10.SQLEXPRESS
folder. I have reinstalled SQL Server 2008 and Visual Studio 2010 but still do not have it.
Any ideas?
0
votes
1answer
195 views
Can't enable 'sa' account in SQL Server 2008
I'm trying to enable 'sa' account in SQL Server 2008 through the MS SQL Server Management Studio Express. When I set the properties through the 'Properties' section of the login and click Ok, there ...
1
vote
0answers
87 views
SQL 2008 fail-over cluster---specified credentials for the SQL Server service are not valid
We had Two Node SQL 2008 fail-over cluster.
Last week one node was crashed, so we decided to re-build the passive Node(crashed Node), we reinstalled the OS and added to windows cluster successfully, ...
0
votes
0answers
78 views
How to rectify FDQN error in mirroring?
While establishing mirroring without witness at last step i am getting an error:
One or more of the server network addresses lacks a fully qualified domain name (FDQN). To start mirroring without ...
0
votes
1answer
18 views
Error when creating Publications
Here`s a screenshot of error I get when I try to create publication ....
Here's a link!
What should I do?
edit
So now I have problem that I cant delete distributor I created, any tips?
0
votes
1answer
36 views
Microsoft SQL Server 2008 Replications [closed]
I`m trying to setup two servers in my company to be synced, I know that SQL Replication is the best way, but I have a lot of problems with that, I saw some video clips about that but still there are ...
0
votes
1answer
119 views
What to do instead of shrinking your databases and how to fix issues caused by previously shrunk databases?
I'm a fairly new SQL Server DBA but come from a software engineering background. I've been reading on several blogs that shrinking a database on a regular basis is bad and I understand why. The issue ...
0
votes
1answer
73 views
Sql Server 2008 Create Foreign Key Manually
I have inherited an old database which wasn't designed very well. It is a Sql Server 2008 database which is missing quite a lot of Foreign Key relationships. Below shows two of the tables, and I am ...
1
vote
1answer
33 views
Altering a table via SQL Server Management Studio - get SQL
Is there a way to get the ALTER statement run by the management studio when altering a table in the design view?
1
vote
1answer
238 views
What's the importance of restoring SQL Server system databases (model, master, etc.)?
I had to restore some production databases to a different drive on the same Microsoft SQL Server 2005 machine. That worked fine and the application using the databases is back online.
However, i have ...
0
votes
1answer
177 views
SQL Server 2008 R2: starting SQL browser failed
During troubleshooting of the failed connection to sqldb in my testsystem I've tried to start sqlbrowser via command line. This results the following error message "failed starting SSRP redirection ...
0
votes
1answer
113 views
Alias a linked Server in SQL server management studio?
Hoping someone can help - is there a way in SQL server management studio 2008 R2 that I can alias a linked SQL server?
I have a server, added by IP address, to which I do not have the login ...
0
votes
1answer
46 views
SQL Server 2005 connection to SQL Server 2008 R2
I having trouble with SQL Server 2008 R2 Express. I installed it and the service is running but SQLexpress, but without success. I even tired to uninstall SQL Server 2008 R2 and I could it said that I ...
1
vote
2answers
176 views
automatically restart sql server after job completes
I'm looking for a way to automatically restart the SQL service after an agent job has completed or as the last step of an agent job. It occurs to me that the agent service is dependent on the server ...
0
votes
0answers
203 views
Mirroring Vs Logshipping?
We are currently using a homegrown log shipping solution on SQL Server 2008 R2 for failover.
We are planing to switch to Mirroring, and I would like to know what items I should be considering as part ...
0
votes
0answers
67 views
SQL Server connection takes long time on amazon EC2 machines
We have two servers on Amazon EC2. Both the machines are part of the same domain which we have created EC2. One of them has SQL Server 2012 installed. When we connect to SQL server from the other ...
3
votes
1answer
555 views
On Amazon Web Services what is the difference between SQL Server Standard and SQL Server Web?
I noticed that SQL Server Web is vastly cheaper than SQL Server Standard on Amazon Web Services. Why is that? What am I missing if I use SQL Server Web instead of Standard?
3
votes
1answer
863 views
SQL Server: How to shrink FileStream files?
For a project, I'm using a SQL Server 2008 R2. One table has a filestream column.
I've made some load tests, and now the database has ~20GB used.
I've empty tables, except several(configuration ...
2
votes
1answer
56 views
Copy a database from Denali CPT3 to SQL 2008 R2
Ok, officially this one is messing with my head. I had the worst idea to try out the SQL server Denali CPT3 when it came out on our development environment. And it seemed ok so we used and gathered a ...
0
votes
1answer
101 views
Can a network failure cause a user to be removed from SQL as an authorized user?
We are trying to get to the bottom of our issue. We have a service that connects as MyDomain\ServiceAdmin to a SQL 2008 database.
I believe we have just setup database mirroring too in case the ...
0
votes
2answers
33 views
using multiple schemes in a clustered sql server 2008 Database
I have a SQL server 2008 R2 database with 2 schemas, i need to enhance the performance of the server so we plan to cluster the DB, we will have 2 nodes . is it possible to separate each scheme so each ...
1
vote
1answer
66 views
replace set of integers with respective string values
I have a query which return the output like -- 5,4,6
Where 1 = apple, 2 = mango, 3 = banana, 4 = plum, 5 = cherry, 6 = kiwi etc.
I would like to update my output as cherry,plum,kiwi instead of 5,4,6 ...
2
votes
1answer
180 views
Electricity gone off while shrinking database, how can I recover my database?
While executing a shrink on a 25GB database, the electricity has gone down, and I can't access my database. It shows as "In Recovery".
How can I recover it?
1
vote
2answers
505 views
Ridiculously slow queries on Microsoft SQL Server 2008 R2
I'm getting really slow queries in MS SQL Server 2008 R2 on my dev machine. This problem has been plaguing me for about a month. Other developers don't have the same problem, but we all run the same ...
0
votes
0answers
178 views
SQL Server Management Studio 2008 won't open
I'm trying to open SQL Management Studio 2008 to attempt to work with a server I have just set up, and to import an .sql file, but for some reason when I attempt to install and run the software it ...
1
vote
1answer
59 views
SQL Server Log Databases Starting Up Every Hour
I have been doing an audit of my SQL Server log, as I 'thought' it was locked down but appeared to be open and we were getting a lot of password attempts on the SA account.
After sorting that, I have ...
0
votes
1answer
55 views
Database server migration and SQL Server 2008 licensing [duplicate]
Possible Duplicate:
Can you help me with my software licensing issue?
We currently have a dedicated server that hosts a number of websites and also has SQL Server 2008 Enterprise running on ...
2
votes
3answers
135 views
How do I secure Sql Server 2008 R2
I have both a dedicated and a VPS (from Fasthosts) virtual server - the web sites/applications I run on these, access Sql Server stored on the same web server.
Until now, I have logged onto Sql ...
1
vote
1answer
55 views
check which SQL server jobs run between 5AM - 11PM [duplicate]
Possible Duplicate:
Get a list of SQL Server Agent Jobs
is there a way to query the job schedule DB, and list out the jobs names, their schedules, frequency, and filter them, such that if I ...
1
vote
2answers
99 views
Many huge files in Sharepoint… Any “stubbing” or “shortcutting” software exist?
I'm in an industry that uses a lot of scanned documents and large attachments (100MB), and I see our Sharepoint database growing quickly.
What options do I have for managing this rapid growth?
Can ...
2
votes
2answers
145 views
vCenter database selection
I am in the planning process of building a new vCenter 5 server. Currently, as a SMB, my host requirements are within range of using the SQL Express install, but my VM count has grown into the lower ...
1
vote
3answers
554 views
Can we restart a SQL Server instance remotely?
I am connecting to SQL server 2008 R2 from a remote machine, but when i right click on the instance in object explorer it shows me Start,Restart,Stop, Pause, Resume options disabled
I am connecting ...
2
votes
1answer
837 views
'Service does not respond in a timely fashion' error when restarting Sql Server
When I try to restart my SQL server, I get the following error:
Why this error happens and how to solve this?
1
vote
1answer
223 views
Remote connection to SQL Server 2008 in LAN
I try many ways, but still doesn't work.
MSSQLSERVER is running.
SQL Agent is running.
SQL Browser is running.
TCP/IP is enabled (something else inside it must I change?)
Named Pipes is enabled
...
-2
votes
3answers
140 views
True or False: a table with large records (rows) and lots of fields (columns) will take longer to return a SQL query? [closed]
True or False: a table with large records (rows) due to lots of fields (columns) will take longer to return a SQL query?
That is, if I have a SELECT ... WHERE...query in SQL that operates on a table ...
0
votes
3answers
76 views
How to warehouse data that is not needed from MS SQL server
I have been asked to truncate a large table in MS SQL Server 2008. The data is not needed but might be needed once every two years. It will NEVER have to be changed, only viewed.
The question is, ...
4
votes
1answer
111 views
SQL Server Restore from Backup, Just primary File Group
Thankfully, this question is just a what-if, and I am not in an emergency right now.
But I have created a file group in my database (sql server 2008), and moved some massive data tables over to it. ...
2
votes
3answers
120 views
Trying to upgrade SQL Server 2008 to R2 getting strange error
The error states:
No mapping between account names and security IDs was done.
This is during an upgrade of 2008 sql server with sp3 to r2.
This results in the database engine not being installed :(
...
4
votes
3answers
1k views
How does SQL Server handle simulataneous read/write requests?
Background:
We have an application which uses an SQL Server 2008 database heavily. We are trying to optimize this application. It was single threaded, and we noticed through logging/ profiling of the ...
1
vote
1answer
238 views
SQL server 2008 installation error
I had installed trial version of SQL 2008 R2 on my machine with win 7 as OS. Today I uninstalled it since trial expired then I tried to install SQL 2008 express edition with Advanced services but I ...
0
votes
2answers
97 views
The Transactional Log is Full
I am getting below error.
The transaction log for database 'CRM_QA_V6' is full.
To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases likely ...
0
votes
1answer
385 views
Error installing SQL Server 2008
I keep getting the following error when trying to install SQL Server 2008 R2, during the Server Configuration Screen:
The full-text service account must be a domain account on windows 2003
...
2
votes
1answer
94 views
What options for Windows Server 2008/SQL Server 2008 replication/mirroring across data centres?
Our Microsoft web-application processes around 2000 orders per day. I need to support failover to a secondary data centre.
What are the options and experience of implementing a replication/mirroring ...
0
votes
1answer
186 views
Allocation error in Database in sql server 2008?
I have found following errors when I use DBCC CHECKDB command.
I don't have idea to fix the error. please help me.
CHECKDB found 124 allocation errors and 0 consistency errors not associated with ...
0
votes
1answer
282 views
move 2008 sql database .mdf and .ldf files to a new folder location
Logical Name
my_Data
my_Log
Path:
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA
FileName:
my.MDF
...
1
vote
0answers
848 views
Unable to authenticate proxy when starting SQL snapshot agent
I have a Windows Server 2008 R2 install running SQL Server 2008 R2 with all the latest updates etc applied,
I have restored a database from an old image (SQL 2005) and am trying to get web-sync ...
