Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-27 : 11:08:02
|
| srinivas writes "hello, i am trying to take backup of a large SQL server database (around 10GB) on to a NAS device. the problem is SQL server is writing the database successfully but the verifiaction of the database is failed. i can't restore it back. [note that how ever, i can successfully take backup of small databases (5-7 GB size)]this problem occurs only if i use windows 2000. but if i do the same from windows NT , it writes and verifies successfully. could you please tell me how to take large back up from SQL server(with winodws 2000 as OS) to a NAS device. i am running : SQL server 2000 7 on windows 2000. thanks in advance,srinivas" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-08-27 : 13:07:22
|
| Please post the error you receive when you try to verify/restore the backup.-Chad |
 |
|
|
prabhakar
Starting Member
2 Posts |
Posted - 2002-08-28 : 02:26:32
|
quote:
Please post the error you receive when you try to verify/restore the backup.-Chad
sorry for posting late. here is the error i got:"[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3242: [Microsoft][ODBC SQL Server Driver][SQL Server]The file on device '\\Ntbt-emcfs-SQL_Data_A$\DEVSQL\DataWarehouse\Database_Backu p\Datawarehouse_db_200206101333.BAK' is not a valid Microsoft Tape- Format backup set. [Microsoft][ODBC SQL Server Driver][SQL Se rver]VERIFY DATABASE is terminating abnormally" |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-08-28 : 13:08:51
|
| Please run a DBCC CheckDB on the 10GB DB.-Chad |
|
|
|
|
|
|
SQL server backup with NAS device