SQL-Server: Is there a SQL script that I can use to determine the ...
121 When I backup or restore a database using MS SQL Server Management Studio, I get a visual indication of how far the process has progressed, and thus how much longer I still need …
"The transaction log for database is full due to 'LOG_BACKUP'" in a ...
Jan 20, 2014 · Occasionally when a disk runs out of space, the message "transaction log for database XXXXXXXXXX is full due to 'LOG_BACKUP'" will be returned when an update SQL …
How can I backup a remote SQL Server database to a local drive?
Oct 15, 2010 · Create a new local (or remote) database, and change the first 'USE' statement in the script to use your new database. Save the script in a safe place, and go ahead and run it …
How to restore to a different database in SQL Server?
Jun 7, 2011 · To restore a database to a new location, and optionally rename the database Connect to the appropriate instance of the SQL Server Database Engine, and then in Object …
sql server 2008 - Cannot open backup device. Operating System …
Oct 18, 2010 · Just remember, its the service account of the sql server performing the actual BACKUP DATABASE command is what needs privileges on the file system, not the agent.
sql server - Database stuck in "Restoring" state - Stack Overflow
I had this situation restoring a database to an SQL Server 2005 Standard Edition instance using Symantec Backup Exec 11d. After the restore job completed the database remained in a …
sql - How do I back up a database to a .bak file? - Stack Overflow
May 19, 2009 · I have a website I've created in Visual Studio 2008 and I need to take it live. How can I backup the database file to a .bak so I can hand it over to the hosting company to place …
SQL Server database backup restore on lower version
May 31, 2011 · How to restore a higher version SQL Server database backup file onto a lower version SQL Server? Using SQL Server 2008 R2 (10.50.1600), I made a backup file and now I …
Import .bak file to a database in SQL server - Stack Overflow
May 26, 2023 · I have a file with .bak extension. How can I import this file data to a database in SQL Server?
SQL Server Operating system error 5: "5(Access is denied.)"
Aug 17, 2013 · The SQL Server database engine service account must have permissions to read/write in the new folder. Check out the blog post Attaching Database – Unable to Open …