Related posts about sql-server

• SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

  as seen on SQL Authority - Search for 'SQL Authority'
  I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More

• How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

  as seen on Server Fault - Search for 'Server Fault'
  Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More

• [MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

  as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
  Modification technique pour le site de l'article. >>> More

• How to create SQL Server Express DB from SQL Server DB

  as seen on Stack Overflow - Search for 'Stack Overflow'
  I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More

• sql server 2000 error, error trying to connect to sql server 2005

  as seen on Stack Overflow - Search for 'Stack Overflow'
  i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More

Related posts about database-restore

• Database operations through SQL: Database Restore ...

  as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
  If using sql to perform a database restoring , care the sql-codes very well. Any trivial mistake may prevent a successful execution. Cases are listed here based on simple experiments. with operation: MOVE 'logical_file_name_in_backup' TO 'operating_system_file_name' If logical file name… >>> More

• SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot

  as seen on SQL Authority - Search for 'SQL Authority'
  Snapshot database is one of the most interesting concepts that I have used at some places recently. Here is a quick definition of the subject from Book On Line: A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source database and… >>> More

• Undo Database Restore in SQL Server 2008

  as seen on Server Fault - Search for 'Server Fault'
  I accidentally restored a SQL Server 2008 database with a wrong backup. Is there any way to undo this and restore to previous version? -Vivek >>> More

• Restore SQL Server 2008 db without affecting users

  as seen on Server Fault - Search for 'Server Fault'
  When I restore a db in Sql Server 2008 R2 from data on another server, it makes a mess of the users. I have a Windows User and MsSql Login named Web_SqlA on both machines. Before the Restore, Web_SqlA is properly mapped to the right Windows user in the database. After the Restore, Web_SqlA is still… >>> More

• Undo Database Restore in SQL Server 2008

  as seen on Stack Overflow - Search for 'Stack Overflow'
  I accidentally restored a SQL Server 2008 database with a wrong backup. Is there any way to undo this and restore to previous version? >>> More