Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2005]

Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This tag is for questions on the 2005 version

1072 questions
4
votes
3 answers

Best Practice: Using Asp.net and Microsoft SQL 2005 what is the best way to load balance/achieve high availability accross two physical sites?

I asked this on StackOverflow when serverfault was in beta. Giving it a second shot. I have 4 Servers in two physically separate locations. Each server is running Windows Server 2003 Standard and Microsoft SQL Server 2005 standard edition. Server…
Josiah Peters
  • 141
  • 2
4
votes
2 answers

How long can a mirrored fail-over partner be offline before a full backup is required to re-synchronize?

Running a db mirroring in sql server 2005 sp2. There is SAN maintenance that needs to occur and i want to know if I stop SQL Server on the fail-over partner (mirror) and the principal keeps doing log backups, will i need to re-initialize database…
Nick Kavadias
  • 10,796
  • 7
  • 37
  • 47
4
votes
5 answers

What is the best way to move 20+ databases to a new database server? SQL 2005

Current database server: SQL Server 2005 - Windows Server 2003 New destination database server: SQL Server 2005 - Windows Server 2003 Enterprise - VM Ware image Current database server has 20+ databases on it, some application databases...others…
kmc
4
votes
3 answers

SQL Server do I need my differential backups?

I have about 10 databases on a server that I have in Full Recovery model and all are mirrored using Sql Server Mirroring. My current backup strategy is as follows: Full Backup 1am Differential Backup every 2 hours Transactional Log Backup every 15…
MrEdmundo
  • 291
  • 6
  • 14
4
votes
1 answer

SQL Server linked server: "Cannot start more transactions on this session."

i am trying to perform an INSERT operation against a linked server: DBCC TRACEON (3604, 7300) BEGIN TRANSACTION INSERT INTO LIVE.Contoso.dbo.Events (EventGUID, EventDate, LoginGUID, UserGUID, EventType, Notes, TargetGUID) VALUES…
Ian Boyd
  • 5,293
  • 14
  • 60
  • 82
4
votes
3 answers

Transaction Log filling up on SQL database set to Simple

We have a database on a SQL 2005 server that is set to Simple transaction mode. The logging is set to 1 MB and is set to grow by 10% when it needs to. We keep running into an issue where the transaction log fills up and we need to shrink it. What…
Will
  • 826
  • 2
  • 9
  • 19
4
votes
2 answers

What permission is needed for my SQL Server 2005 DB for a WebUser?

I have a connection string in my asp.net code that looks at a SQL Server 2005 database. I created a UserName called WebUser and granted him db_datawriter and db_datareader in SQL Server 2005. Both under Login and under the database the user must be…
Etienne
  • 273
  • 5
  • 16
4
votes
3 answers

SQL Server 2005: Proper Backup Schedule

I'm a .NET Developer and I know how to write SQL but am clueless at doing any form of database maintenance scheduling yadda So, I've recently taken over a project from a previous client. The site is hosted with Rackspace. Anyway, the previous…
Jack Marchetti
  • 561
  • 1
  • 6
  • 15
4
votes
0 answers

Cannot telnet to SQL Server on port 1433

I've been working solidly on this issue for the past three weeks. I cannot seem to find where the actual issue is. I just recently found this article on how to troubleshoot the connection. I made it down to step 4 on the client machine and telnet…
Otacon
  • 41
  • 1
  • 1
  • 5
4
votes
3 answers

Add SSH host key to another user's PuTTY cache

I have written a PS1 script that 7-zips a file and uses PuTTY's SCP to store it at my back-up server. I have tested it and it works perfectly. Then I log into my SQL Server Agent and add an extra step to my back-up job to execute that script as soon…
Liz Av
  • 464
  • 2
  • 6
  • 16
4
votes
1 answer

Repair mssqlsystemresource.ldf

I accidently deleted mssqlsystemresource.mdf and mssqlsystemresource.ldf. I undeleted them both, but the .ldf file is corrupted (bad FGID), and because of this I can no longer start up my database instance. There have never been any backups of the…
nograde
  • 143
  • 1
  • 5
4
votes
3 answers

Domain User Access to SQL Server Reporting Services 2005 on IIS7

What are the required steps to properly allow domain users access to reports via the Reporting Services web site? I've tried to give domain users access both through the site itself and through Management Studio, but whenever a user tries to access…
triniMahn
  • 51
  • 1
  • 5
4
votes
3 answers

What is the best practice for the database owner in SQL Server 2005?

What is the best practice for the database owner in SQL Server 2005? I have already searched this page... http://technet.microsoft.com/en-us/sqlserver/bb331794.aspx and didn't find what I was looking for. This is the principals that is displayed in…
DBAndrew
  • 170
  • 2
  • 8
4
votes
5 answers

Recovering a specific job definition from an MSDB backup?

We've been asked to recover a specific SQL 2005 job from how it existed at a certain time in the past. We have MSDB database backups from that time period, but I can't overwrite the current MSDB database, because I don't want to lose more recent…
BradC
  • 2,220
  • 4
  • 27
  • 36
4
votes
3 answers

SQL Server Linked Server RPC Options?

When setting up a linked server in SQL Server (we're on 2005), you can set two server options: Rpc Rpc Out Looking at the MSDN article, all it states is: RPC - Enables RPC from the specified server. RPC Out - Enables RPC to the specified …
Aaron Daniels
  • 447
  • 2
  • 5
  • 10
1 2 3
…
71 72