Dear all,
I'm reposting this as it seemed to become associated with replies which were not on the topic.
If this is not the best place to ask, can anyone direct me to an appropriate forum for SQL Server questions?
Many Thanks,
John
I'm having some trouble running a backup running a backup using a query
contained withn a .sql file.
I need to resolve this issue so I can automate backups for my client.
Any advice would be gladly appreciated.
PC is Windows 7 Professional, 64 Bit
SQL Server Express Edition with Advanced Services (2008 R2)
I have two scripts (below) saved as FULLBU.sql and DIFFBU.sql. Neither are
working how I would expect. scripts which are identical except for database name
and file location are working perfectly on another server.
<<<FULL DATABASE BACKUP>>>
BACKUP DATABASE [ASEEDA] TO DISK = N'C:\Program Files (x86)\Microsoft SQL
Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ASEEDA.bak' WITH NOFORMAT, NOINIT,
NAME = N'ASEEDA-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
AND
<<<DIFFERENTIAL DATABASE BACKUP>>>
BACKUP DATABASE [ASEEDA] TO DISK = N'C:\Program Files (x86)\Microsoft SQL
Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ASEEDA.bak' WITH DIFFERENTIAL ,
NOFORMAT, NOINIT, NAME = N'ASEEDA-Differential Database Backup', SKIP,
NOREWIND, NOUNLOAD, STATS = 10
GO
When I execute either file with SQL Server Management Studio closed; no backup
happens, SQL Server Management Studio opens, but does not connect to any
objects.
When I execute either file with SQL Server Management Studio open; the text of
the script file opens in the Query window but does not execute. If I click on
Execute, the backup runs as expected. This makes me think that there's nothing
wrong with the query, but it's somehow failing to connect. I'm stumped.
From SQL Server Configuration Manager, the running services are;
SQL Server and
SQL Server Browser
(on the other computer where these .sql files do execute correctly there is one
other service running, "SQL Full-text Filter Daemon Launcher"
This is the information from SQL Server Management Studio - About:
Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.7601.17514
Microsoft .NET Framework 2.0.50727.5446
Operating System 6.1.7601
Thanks
John
Tidak ada komentar:
Posting Komentar