All Questions
Tagged with sql-server sql-server-2008
43
questions
1
vote
1
answer
2k
views
SQL Sever Management Studio 2008 does not let me back up my database
I tried to back up a server I created in SQL Server, but I received the following message:
TITLE: Microsoft SQL Server Management Studio
Backup failed for Server 'LAPTOP-6D0L83DV\SQLEXPRESS'.
...
1
vote
0
answers
32
views
What does it mean "Microsoft SQL 2010 R2" as an application requirement?
I have this terrible doubt of windows and hope someone of you might know what is it.
I bought a contability software (here in mexico there are few providers cause they are regulated), the thing is ...
1
vote
1
answer
3k
views
How to reduce the database size of MS SQL server
I have a website that runs on MS SQL Server 2014 Enterprise with two clustered virtual machines and AlwaysOn. A database backup is created each night and the size is now 20GB.
On my laptop, I also ...
0
votes
0
answers
135
views
SQL Server 2008 SA account locked
Trying to access SQL Server 2008 database of production server but admin and SA account was not accepting it.
After trying several time SA account is locked. How to unlock it without any production ...
2
votes
0
answers
586
views
SQL Server Express no longer starts up automatically
I had SQL Server 2008 Express (SP1) on Windows 7 Pro and it was working fine.
After upgrading to Windows 10, SQL Server 2008 Express was still working normally.
However, after the last Windows update (...
1
vote
1
answer
564
views
How to schedule a recurring SQL Server 2012 DB backup using sqlcmd ?
I'm looking for a way to create a monthly recurring backup of a SQL server database using sqlcmd.
I've seen scripts for SQL Express, but they only execute once. I'm looking for a sql script that will ...
2
votes
2
answers
3k
views
SQL : Restrict view of tables in database
This is probably a no but, I want to be sure. A client wants to connect to SQL Server 2008 that we host. They will be accessing a table to execute an SSIS package to copy some data they have on their ...
75
votes
2
answers
223k
views
Where is SQL Configuration Manager in Windows 10?
I just have upgraded to Windows 10. I can't find SQL Server Configuration Manager. I have MSSQL 2008 and 2014 installed but there is no configuration manager in "All Apps".
This is just a picture of ...
0
votes
1
answer
5k
views
Updating MS SQL Server from 10.50.1600 to 10.50.1617
How do I update my MS SQL Server from the version 10.50.1600 to 10.50.1617?
I have downloaded the KB from here https://www.microsoft.com/en-us/download/details.aspx?id=26304 but i am still not ...
4
votes
1
answer
4k
views
SQL Installation hanging on windows 10
I've tried installed every version of SQL Express I can get my hands on (And I've got the MSDN SQL 2016 CTP 2).
Everythings hangs, and always at this point.
I've a feeling its a .net related issue ...
4
votes
3
answers
35k
views
SQL Server not working after upgrading windows 10 from windows 8.1
My Sql server 2012 has stopped working and now its not letting me login. Here is the error:
https://drive.google.com/file/d/0ByGXmosQgHUqdGw4alFSb3otVkk/view?usp=sharing
TITLE: Connect to Server
...
0
votes
1
answer
1k
views
Can't install SQL server 2008 or SQL Server 2014
When I try to run the SQL SERVER 2008 setup, it shows the following error and exits:
SQL Server Setup has encountered the following error:
Unable to cast object of type
'System.Configuration....
0
votes
1
answer
93
views
SQL Server 2008 Backup to networked drive
When I go to backup a SQL database - I only see options to do the backup on a local disk.
Is it possible to backup to a network drive directly?
0
votes
0
answers
59
views
Change SQL server back to a trial
I need to convert a SQL Server 2008 instance on a VM (which is licensed) back to a trial.
What are the steps to do this?
REASON for this: Need to give a VM with a custom solution on it to a 3rd ...
1
vote
1
answer
12k
views
Remove column header from sql query output in powershell
I want to remove column header from sql server query output. I did the search but not found any solution. I have a script.
$Database = "temp"
$Server = "localhost"
$AttachmentPath = "output.csv"
# ...